Connor and Chris will both be at AI World from October 12 to October 17 , the premier Oracle conference of 2025. If you're in Vegas, please come say Hi or pop into our sessions
Thanks for the question, Nita.
Asked: September 21, 2017 - 1:59 pm UTC
Last updated: September 21, 2017 - 4:49 pm UTC
Version: 12c
Viewed 10K+ times! This question is
create table t ( x int ); create sequence s; alter table t modify x default s.nextval; insert into t values (default); select * from t; X 1
alter table t add ( y int generated as identity ); insert into t values (default, default); select * from t; X Y 1 1 2 2
Nita Mann, September 21, 2017 - 5:15 pm UTC
New to good database design? Check out Chris Saxon's full fundamentals class.