-
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
-
created table
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:
Code:
SELECT table_name FROM user_objects WHERE table_name = '';
desc
select object_name, object_type, status, created from user objects order by 1;
You should show the SQL that you used to create the table. You should also read the Concepts guide.
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|