Where is my table
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Where is my table

  1. #1
    Join Date
    Jun 2014
    Posts
    3

    Where is my table

    i do not know what happen to the table i created

  2. #2
    Join Date
    Jun 2014
    Posts
    3
    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

  3. #3
    Join Date
    Jun 2014
    Posts
    3

    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?

  4. #4
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,997
    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
    this space intentionally left blank

  5. #5
    Join Date
    Feb 2014
    Posts
    14
    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
  •  



Click Here to Expand Forum to Full Width