Answer / sivachandran

we can use 12 trigger in single table.

How are multiple column = value pairs delimited in the SET clause of an UPDATE statement? 1. With commas (SET price = 0, status = 'I') 2. With parentheses (SET (price = 0) (status = 'I')) 3. With double-pipes (SET price = 0 || status = 'I') 4. With square-brackets (SET [price = 0] [status = 'I'] 5. With single or multiple spaces (SET price = 0 status = 'I')

2 Answers  

---

What is rownum?

0 Answers  

---

How delete all data from all tables in sql?

0 Answers  

---

Define commit, rollback and savepoint?

0 Answers  

---

Explain about various levels of constraint.

0 Answers  

---

How does sql developer connect to oracle database?

0 Answers  

---

What is thread join () in threading?

0 Answers  

---

What is string join?

0 Answers  

---

What does the hierarchical profiler does?

0 Answers  

---

What is rank () in sql?

0 Answers  

---

How does rowid help in running a query faster?

0 Answers  

---

type type_name is table of varchar2(30) index by binary_integer for the above type you have to create a identifier... like identifier_name type_name; for the above type you can use the below methods..like first , last , prior, next , delege..etc...like this.. if you create a cursor...like cursor cursor_name is select * from scott.emp; is there any methods like above to use prior, fist , last , next , trim ,etc...

1 Answers   Satyam,

---