What is the usage of when clause in trigger?

0 Answers  

---

define a variable representing the expression used to calculate on emps total annual remuneration.use the variable in a statement which finds all emps who can earn 30000 a year or more.

5 Answers  

---

What is the use of index in sql?

0 Answers  

---

What is data type in database?

0 Answers  

---

write a query to delete similar records in particular fields(columns) in different tables

6 Answers   TCS,

---

What is materialized view in sql?

0 Answers  

---

How do I remove all records from a table?

0 Answers  

---

How does one use sql*loader to load images, sound clips and documents? : aql loader

0 Answers  

---

what are the disadvantages of mysql? : Sql dba

0 Answers  

---

how to eliminate null values in a column i.e table vlaues 1 2 3 NULL 3 4 1 5 NULL i want output like this 1 2 3 3 4 1 5 i dnt want to use nvl is null and i dnt want replace the NULL value with any value i.e nvl(col,o);

11 Answers   Satyam,

---

Why should I use postgresql?

0 Answers  

---

Explain uses of cursor.

1 Answers  

---