Answer Posted / selvaraj v , anna univ coe

To Use same database :
======================

CREATE TABLE NEW_TBLNAME AS SELECT * FROM OLD_TBLNAME WHERE
1=2;


EXAMPLE :
---------
CREATE Emp_tbl2 AS SELECT * FROM Employee_Tbl1 WHERE 1=2;

Table creation From One USER To Another USER :
======================================================

COPY FROM coeot1a2/coeot1a2@coeau TO scott/tiger@server1
CREATE s11 USING SELECT * FROM major_List;

coeot1a2 ----> USER NAME
coeot1a2 ----> PASSWORD
coeau -------> SERVER NAME
scott -------> Another USER NAME
tiger -------> Another User PASSWORD
server1 -----> Another SERVER NAME

What is AUTH_ID and AUTH_USER in pl/sql ?

2180

---

What are the types of join in sql?

1089

---

How delete all data from all tables in sql?

942

---

Cite the differences between execution of triggers and stored procedures?

1075

---

Do we need to rebuild index after truncate?

1030

---

What is the use of function in sql?

1082

---

What are the sql commands?

1160

---

How do you optimize a query?

990

---

What is a Mapplet?

1116

---

how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc

4004

---

What are the different parts of a package?

1105

---

What is foreign key sql?

979

---

Why should I use postgresql?

1007

---

What is the syntax and use of the coalesce function?

1155

---

How can we debug in PL/SQL?

1127

---