i do not know what happen to the table i created
Printable View
i do not know what happen to the table i created
i was doing the tutorial for sql and i created the table but now I cannot find it will it show up when i insert the columns
i cannot find the table i created i am doing the tutorial in sql and i created a table the next assignment is to insert columns where is the table i created?
Take a look at user_tables or user_objects as in:
You should show the SQL that you used to create the table. You should also read the Concepts guide.Code:SELECT table_name FROM user_objects WHERE table_name = '
';
desc
select object_name, object_type, status, created from user objects order by 1;
http://docs.oracle.com/cd/E11882_01/...e40540/toc.htm
You can do a select in all_tables for tablename and owner. Maybe it is under another schema?