DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Can I use 'ORDER' as the table name to create a table?

Threaded View

  1. #3
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    Code:
    sql> create table ORDER (c1 number);
    create table ORDER (c1 number)
                 *
    ERROR at line 1:
    ORA-00903: invalid table name
    
    
    Elapsed: 00:00:00.16
    sql> create table "order" (c1 number);
    
    Table created.
    
    Elapsed: 00:00:00.32
    sql> desc order
    ERROR:
    ORA-00931: missing identifier
    
    
    sql> desc "order"
     Name                                                                 Null?    Type
     -------------------------------------------------------------------- -------- ---------------------
     C1                                                                            NUMBER
    
    sql> drop table order;
    drop table order
               *
    ERROR at line 1:
    ORA-00903: invalid table name
    
    
    Elapsed: 00:00:00.00
    
    sql> drop table "order";
    
    Table dropped.
    
    Elapsed: 00:00:00.31
    Maybe you created table "ORDER" using quotes.

    HTH
    Last edited by patel_dil; 11-18-2003 at 02:40 PM.
    -- Dilip

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