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
Printable View
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
Is there a reason no one will reply?
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.
Quote:
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? :DQuote:
Originally posted by pando
Quote:
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