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


Please Help Members By Posting Answers For Below Questions

What are the uses of merge?

715


What is plpgsql language?

523


what happens if null values are involved in expressions? : Sql dba

559


How many times can we commit in a loop?

561


Why use subqueries instead of joins?

595






What are synonyms in sql?

528


What is sql data?

542


How do I write a cron which will run a sql query and mail the results to agroup?

520


How do I order columns in sql?

522


What is over () in sql?

519


What is the benefit of foreign key?

522


What are sql injection vulnerabilities?

493


How you can copy a file to file content and file to pl/sql table in advance pl/sql?

615


What is a design view?

516


How many types of cursors supported in pl/sql?

582