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;

Can we create index on primary key?

949

---

how to delete an existing column in a table? : Sql dba

988

---

what is a table in a database ? : Sql dba

1024

---

Why stored procedure is better than query?

924

---

What are the query optimization techniques?

913

---

How many tables can a sql database have?

958

---

What is group function in sql?

1002

---

Does sql support programming?

1048

---

Is sql a oracle?

951

---

Explain polymorphism in pl/sql.

1096

---

Can a table have no primary key?

1038

---

how to concatenate two character strings? : Sql dba

1078

---

what are rollup and cube in t-sql? : Transact sql

1072

---

What is the difference between local and global temporary table?

1025

---

what is a foreign key ? : Sql dba

1065

---