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
Which table is left in left join?
Can we call procedure in select statement?
What is the difference between pl and sql?
What is union, minus and interact commands?
What is the use of sqlerrd 3?
What are pl/sql cursors?
what are the differences between char and nchar? : Sql dba
Do we need to create index on primary key?
what are the different tables present in mysql? : Sql dba
What are the different types of triggers?
How many joins can you have in sql?
What are sql data types?
Can you join a table to itself?
What is asqueryable?
What is the syntax and use of the coalesce function?