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
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
How do I view an execution plan in sql?
What is the advantage of index in sql?
Why do we need unique key in a table?
What is error ora-12154: tns:could not resolve the connect identifier specified?
Is primary key always clustered index?
What does where 1/2 mean in sql?
What are some emotional triggers?
What is the difference between clustered and non-clustered index in sql?
Is sql a oracle?
how many ways we can we find the current date using mysql? : Sql dba
What is the difference between delete, truncate and drop command?
How many types of index are there?
Does sql support programming?
how to present a past time in hours, minutes and seconds? : Sql dba