Answer Posted / selvaraj v
In Oracle 10g :
---------------
Create New Table in another table with same data's:
---------------------------------------------------
copy from coeot1a2/coeot1a2@coeau to scott/tiger@coeau
CREATE s11 using select * from major_list;
Insert data's into another table with same data's:
---------------------------------------------------
copy from coeot1a2/coeot1a2@coeau to scott/tiger@coeau
INSERT s11 using select * from major_list;
Append data's into another table with same data's:
---------------------------------------------------
copy from coeot1a2/coeot1a2@coeau to scott/tiger@coeau
APPEND s11 using select * from major_list;
Replace data's into another table with same data's:
---------------------------------------------------
copy from coeot1a2/coeot1a2@coeau to scott/tiger@coeau
REPLACE s11 using select * from major_list;
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are commit, rollback, and savepoint?
How to run sql functions in pl/sql?
How do I sort a table in sql?
What is meant by cursor in sql?
Can we create clustered index without primary key?
What is field delimiter?
How many types of tables are there?
How do temporal tables work?
Can a table contain multiple primary key’s?
Can a primary key be a foreign key?
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
Explain locks? : Transact sql
What is meant by temporal data?
What is t sql used for?
What does count (*) mean in sql?