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 is a behavioral trigger?
What is date functions?
Is sql considered coding?
Do stored procedures prevent sql injection?
what are local and global variables and their differences? : Sql dba
Is sqlite free?
What are the different types of dbms?
How you improve the performance of sql*loader? : aql loader
What is partition by in sql?
how to include comments in sql statements? : Sql dba
What is the purpose of my sql?
What is a schema? How is it useful in sql servers?
Is it possible to sort a column using a column alias?
How do I run a sql query?
Explain what is rdbms?