-
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.
-
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
-
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|