Thanks for the question, Rahul.
Asked: August 04, 2017 - 10:28 am UTC
Last updated: August 04, 2017 - 3:13 pm UTC
Version: 12.1
Viewed 10K+ times! This question is
create table t ( x int generated as identity ); insert into t values (default); select * from t; X 1 select column_name, data_default from user_tab_cols where table_name = 'T'; COLUMN_NAME DATA_DEFAULT X "CHRIS"."ISEQ$$_197255".nextval select ISEQ$$_197255.currval + increment_by from user_sequences where sequence_name = 'ISEQ$$_197255'; ISEQ$$_197255.CURRVAL+INCREMENT_BY 2 insert into t values (default); select * from t; X 1 2
New to good database design? Check out Chris Saxon's full fundamentals class.