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