SQL Problem - Chained Rows
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: SQL Problem - Chained Rows

  1. #1
    Join Date
    Nov 2001
    Location
    Atlanta GA
    Posts
    45
    Missing Paren? I don't see it !!


    SQL> create table new_table as
    2 select * from table
    3 where rowid in
    4 (select head_rowid
    5 from chained_rows
    6 where table_name ='NEWTAB');
    where rowid in
    *
    ERROR at line 3:
    ORA-00906: missing left parenthesis

  2. #2
    Join Date
    Nov 2001
    Location
    Atlanta GA
    Posts
    45
    Is there a reason no one will reply?

  3. #3
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    In first, is this is real statment or not?

    if REAL then u have to know that TABLE is reserved word in Oracle.

    SQL> create table new_table as
    2 select * from table
    3 where rowid in
    4 (select head_rowid
    5 from chained_rows
    6 where table_name ='NEWTAB');

    This is ur problem.


  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    Originally posted by Lani2000
    Is there a reason no one will reply?

    yes, it's weekend and free support has to have a break

    geez

  5. #5
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    Originally posted by pando
    Originally posted by Lani2000
    Is there a reason no one will reply?

    yes, it's weekend and free support has to have a break

    geez
    Come on Pando, we all know you read this forum 24x7. What's the problem?
    Christopher R. Long
    ChrisRLong@HotMail.Com
    But that's just my opinion. I could be wrong

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