SQL Problem - Chained Rows

[Lani2000]

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

[Lani2000]

Is there a reason no one will reply?

[Shestakov]

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.

[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

[chrisrlong]

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?