How can I create a table from another table without copying
any values from the old table?
Answer Posted / tejas wajge
create table emp as select * from project where rownum <1;
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is partition in sql query?
Is sql difficult?
What is benefit of creating memory optimized table?
How many sql core licenses do I need?
what is a foreign key ? : Sql dba
Mention what is the function that is used to transfer a pl/sql table log to a database table?
what is csv? : Sql dba
What language is oracle sql developer?
What is difference between inner join and self join?
Explain spool.
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
What is cursor and its types?
What is record variable?
How do you identify a primary key?
How do you modify a trigger?