Check new created tables in user_objects : USER_OBJECTS « System Tables Views « Oracle PL / SQL

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

Check new created tables in user_objects

    
SQL> create table myTable ( x int );

Table created.

SQL> create table myTable2 ( x int );

Table created.

SQL> insert into myTable values ( 1 );

1 row created.

SQL> insert into myTable2 values ( 1 );

1 row created.

SQL>
SQL>
SQL> select object_name, object_id
  2    from user_objects
  3   where object_name in ('MYTABLE','MYTABLE2')
  4  /
SQL>
SQL>
SQL>
SQL> drop table myTable;

Table dropped.

SQL> drop table myTable2;

Table dropped.

SQL>

   
    
    
    
  

Related examples in the same category