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
what is a table in a database ? : Sql dba
What is sql and db2?
What is rtm in testing?
Mention what pl/sql package consists of?
What is sql*loader and what is it used for? : aql loader
Write the command to remove all players named sachin from the players table.
How do you use join?
What is the starting oracle error number? What is meant by forward declaration in functions?
Why is normalization important?
What is the difference between delete and truncate statement in sql?
What is the best partition size for windows 10?
What do you mean by rowid?
What is a null value?
Can we call dml statement in function?
What is sql query optimization?
