Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / raghunanda
---With date from existing table to new table.
SQL> create table new_table_name as select * from old_table_name where 1=1;
---without data
SQL> create table new_table_name as select * from old_table_name where 1=2;
Thanks,
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do you drop a trigger?
What does (+) mean in sql joins?
how to create a new table by selecting rows from another table in mysql? : Sql dba
What is delete command in sql?
How does one use sql*loader to load images, sound clips and documents? : aql loader
What is use of trigger?
What is the use of partition by in sql?
Is nosql faster than sql?
How do I quit sql?
Give the order of sql select?
What are the 3 types of behavioral triggers?
How do I know if I have sql express or standard?
What is join view in sql?
Explain polymorphism in pl/sql.
How to sort the rows in sql.
