How can I create a table from another table without copying
any values from the old table?
Answer Posted / srinivas
create table emp1
as
select * from scott.emp where rownum=0
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the uses of merge?
What is plpgsql language?
what happens if null values are involved in expressions? : Sql dba
How many times can we commit in a loop?
Why use subqueries instead of joins?
What are synonyms in sql?
What is sql data?
How do I write a cron which will run a sql query and mail the results to agroup?
How do I order columns in sql?
What is over () in sql?
What is the benefit of foreign key?
What are sql injection vulnerabilities?
How you can copy a file to file content and file to pl/sql table in advance pl/sql?
What is a design view?
How many types of cursors supported in pl/sql?