what is global temporary tables and how use that tables in pl/sql packages

1 Answers   Cap Gemini,

---

What is the left table in sql?

0 Answers  

---

What is an Exception ? What are types of Exception ?

2 Answers  

---

what is schema? : Sql dba

0 Answers  

---

I am creating an index on Emp table Empno column,if u using this indexed column in ur SELECT stmt. where clause,then how do u know that yr index will be working or nor? Thanks Advance...

3 Answers  

---

display your age in months?

2 Answers  

---

if we give update table_name set column_name= default. what will happen?

4 Answers   iFlex,

---

can we use out parameter in a function?Give an example.

4 Answers   Logica CMG, TCS,

---

What are inbuilt functions in sql?

0 Answers  

---

how to debugg a procedure or package using dbms_output.put_line in plsql

1 Answers   Polaris,

---

Can a primary key be a foreign key?

0 Answers  

---

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

1 Answers   IAS,

---