Thanks Linus and RB1Kenobi for your answer but my case is diff...by firing the query mentioned by Kenobi, I can get the table content. But that's not what I need. I am building an automatic code where if you know or don't know the table name. If you give like statement ,it will fetch the table name and it will be used as a source table for the target. In oracle it could be somewhat like this..... select table_name from all_tables where table_name like '%emp%' -----output : 5 row with table name have been received. loop 1..max_count(in this case it is 5) insert into target_table select a.col1,a.col2 from &table_name ----- the loop will be executed 5 times and for 5 diff table data will be inserted in the target table.... hope I have illustrated my situation vividly..:)
... View more
