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
Does oracle use sql?
What is a dynamic query?
What is the trigger in sql?
What is Histogram?
How do you update a table in sql?
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
Is t sql a programming language?
Are sql database names case sensitive?
How do I enable sql encryption?
What is rownum in sql?
Explain the working of primary key?
Can we alter stored procedure?
What view means?
Explain 3 basic parts of a trigger.
Explain what is dbms?