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
Why primary key is required?
How do you use join?
What are the advantages of sql?
How can we avoid duplicating records in a query?
What is a function in oracle pl sql?
What is a temp table?
what is the syntax for using sql_variant_property? : Transact sql
What is sql server and ase?
Mention what are the benefits of pl/sql packages?
What is a Mapplet?
Explain the difference between 'between' & 'and' operators in sql
In what condition is it good to disable a trigger?
Difference between global and parameter variables?
How many commands are in sql?
How to create your own reports in sql developer?
