A small doubt in SQL Copy Table

By: abhish* On:** Sat Feb 11 13:34:44 IST 2017 0 0 0	0

you have given the code to copy data from one table to another table is SELECT * INTO <destination_table> FROM <source_table> but its not working in oracle database the code below is working INSERT INTO <destination_table> SELECT * FROM <source_table>	0

the 1st query is to insert a single row into a table it will not copy the entire data to copy the entire data from one table to another the second syntax is used	0

By: [email protected] On: Sun Feb 12 22:34:31 IST 2017 0 0 0	0
Are You Satisfied :0Yes0No

	0

By: [email protected] On: Sun Feb 12 22:40:42 IST 2017 0 0 0	0
Are You Satisfied :0Yes0No

^{Like/Subscribe us for latest updates or newsletter}