Get object id for created table : USER_OBJECTS « System Tables Views « Oracle PL / SQL

1. Oracle PL / SQL
2. System Tables Views
3. USER_OBJECTS

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.

   
    
    
    
  

Related examples in the same category