create table tq84_ident_test ( id integer generated always as identity primary key, val number(6,2) ); select object_name, (sysdate - created) * 24*60*60 created_secs_ago, user_objects.* from user_objects where object_type = 'SEQUENCE' order by created desc; drop table tq84_ident_test;