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 sql procedures and functions?
Which type of cursor is used to execute the dml statement?
what is row? : Sql dba
What is query syntax?
How do you create an update query?
How to revise and re-run the last sql command?
What is pragma in pl sql?
How many unique keys can a table have?
What is microsoft t sql?
Can we use having without group by in sql?
What are properties of the transaction?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
how to create a new table by selecting rows from another table in mysql? : Sql dba
What are types of joins?
What does where 1/2 mean in sql?
