|
I want to copy a table as another table. Like copying a document in windows. Is it possible? I have a scenario where I need to create 5 tables similar to existing table. The only change is table name and adding some prefix text to existing columns. Is there any simple way we can do this?
(comments are locked)
|
|
Check out the 'CREATE TABLE AS SELECT' syntax. You can build a table based on the results of a SELECT statement. Thank you very much. This reduced lot of my work. I found the required link here - http://www.oracle-training.cc/t_garmany_easyoracle_create_table_as_select.htm
Dec 15 '09 at 03:53 PM
OraLearner
It's one of my FAVORITE SQL tricks, and way less overhead than manually populating a table with multiple INSERTS.
Dec 15 '09 at 04:02 PM
HillbillyToad
I guess.. this would be my favourite too now onwards :)
Dec 15 '09 at 04:30 PM
OraLearner
(comments are locked)
|
Your answer
