can you call insert/update/delete in select statements. If yes how? If no what is the other way?

2 Answers  

---

Why do we use coalesce function in oracle?

0 Answers  

---

how to do daily transactions with out sql* loader control file regesterd in apps?

0 Answers   Arrow Electronics,

---

If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?

8 Answers   IBM,

---

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

0 Answers  

---

---

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

0 Answers   Wipro,

---

what is difference between foreign key and reference key

3 Answers   AZTEC, Infosys,

---

We have one Package(which has many function/procedures, SQL quires etc). Now we need to check, which query or procedure is taking lot of time in that Package. ? How do we do it.

2 Answers   IBM,

---

Explain the truncate in oracle?

0 Answers  

---

What is Library Cache in Oracle?

0 Answers   MCN Solutions,

---

What is clusters ?

2 Answers  

---

Oracle

0 Answers   ABC, Genpact, HUI, Oracle,

---