How can I create a table from another table without copying
any values from the old table?
- 8 Answers
- 10690 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
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
What is the file extension for sql database?
what are the join types in tsql? : Transact sql
Why do we use cursors?
Is sql a dbms?
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????
What is the difference between the sql*loader and import utilities? : aql loader
How do I know if I have sql express or standard?
What is difference between rank () row_number () and dense_rank () in sql?
Why is sql better than hql?
explain the difference between delete , truncate and drop commands? : Sql dba
How do you break a loop in pl sql?
What is mutating error in pl sql?
Can a commit statement be executed as part of a trigger?
What is a null value?
