SQL Problem - Chained Rows

[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.