Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

Get object id for created table

SQL> SQL> create table t   2   (c1 number primary key,   3    c2 number not null )   4  ; Table created. SQL> SQL> create sequence s1; Sequence created. SQL> SQL> insert into t values(s1.nextval, s1.nextval+10); 1 row created. SQL> / 1 row created. SQL> / 1 row created. SQL> / 1 row created. SQL> / 1 row created. SQL> commit; Commit complete. SQL> SQL> select object_id from user_objects where object_name = 'T';      20955 1 row selected. SQL> SQL> SQL> drop table t; Table dropped. SQL> SQL> drop sequence s1; Sequence dropped.