Oracle identity column - START WITH - INCREMENT BY
START WITH option example
First, recreates the identity_demo table whose the id column is defined as an identity column with the initial value starting from 100:
id NUMBER GENERATED BY DEFAULT ON NULL AS IDENTITY START WITH 100,
First, change the id column of the identity_demo table that includes both START WITH and INCREMENT BY options.
id NUMBER GENERATED BY DEFAULT ON NULL AS IDENTITY START WITH
#oracleplsql #banglatutorial #oracle