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 is a behavioral trigger?

604


What is date functions?

658


Is sql considered coding?

665


Do stored procedures prevent sql injection?

648


what are local and global variables and their differences? : Sql dba

623






Is sqlite free?

642


What are the different types of dbms?

640


How you improve the performance of sql*loader? : aql loader

658


What is partition by in sql?

667


how to include comments in sql statements? : Sql dba

635


What is the purpose of my sql?

599


What is a schema? How is it useful in sql servers?

683


Is it possible to sort a column using a column alias?

694


How do I run a sql query?

626


Explain what is rdbms?

697