Interested to Buy Any Domain ? << Click Here >> for more details...
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
can a stored procedure call itself or recursive stored procedure? : Sql dba
How do you identify a primary key?
can sql servers linked to other servers like oracle? : Sql dba
What is pl sql script?
How do I run a program in pl sql?
What is the difference between the conventional and direct path loads? : aql loader
Does sap use sql?
What is query execution plan in sql?
What are the most important ddl statements in sql?
what are null values? : Sql dba
how to add a new column to an existing table in mysql? : Sql dba
how can we repair a mysql table? : Sql dba
What is trigger with example?
How do I find duplicates in a single column in sql?
What is sql*loader?
