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. #4
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Five finger exercise on a theme proposed by slimdave. Second variation (after edit!):
    Code:
    SQL> create table "from" 
    ("select" varchar2(10),
     "where" varchar2(10),
     "order by" varchar2(10));
    
    Table created.
    
    SQL> insert into "from" values ('select','where','order by');
    
    1 row created.
    
    SQL> select "select"
      2  from   "from"
      3  where  "where" = 'where'
      4  order by "order by"
      5  /
    
    select
    ----------
    select
    Last edited by DaPi; 11-18-2003 at 07:04 PM.

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