Where is my table
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.
SELECT table_name FROM user_objects WHERE table_name = '';
select object_name, object_type, status, created from user objects order by 1;
this space intentionally left blank
You can do a select in all_tables for tablename and owner. Maybe it is under another schema?
Click Here to Expand Forum to Full Width