Interested to Buy Any Domain ? << Click Here >> for more details...
How can I create a table from another table without copying
any values from the old table?
- 8 Answers
- 13214 Views
- I also Faced
- E-Mail Answers
Answer Posted / anji
create table table_name as ( select * from old_table where 1=2)
from this query we can create a new table structure from old
table structure with out data
| Is This Answer Correct ? | 26 Yes | 1 No |
Post New Answer View All Answers
Can we use having without group by in sql?
Explain aggregate functions are available there in sql?
How to create an array in pl/sql?
How can you tell the difference between an index and a view?
What are conditional predicates?
Can we use view in stored procedure?
What are the two types of exceptions in pl/sql?
what is a composite key ? : Sql dba
Explain the methods used to protect source code of pl/sql.
Does sql*plus have a pl/sql engine?
What is function and procedure?
Explain the significance of the & and && operators in pl sql.
Is nosql faster than sql?
What is plpgsql language?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
