Answer / charlyne zeno sohtun

Instead Of Trigger helps in modify a table directly from the
View.

Answer / sanjay

Using Instead of Trigger, you can restore the deleted
record.
Its primary use can be when you accidentally delete a
record from a table. In case of Instead of trigger the view
doesn't get updated and hence the deleted record can be
retrieved.

Answer / sardhara piyush

insted of trigget is provied transparant way of modifying
view that can not be modified directly through dmal
statement like(insert,update ane delete)

How do you rename a table in sql?

0 Answers  

---

Is sql microsoft?

0 Answers  

---

What is pls integer?

0 Answers  

---

What is the use of nvl function?

0 Answers  

---

How do you write a complex sql query?

0 Answers  

---

If 100 tables are there in user_tables.I want to find in which table zero records are there with table name.Is it possible?

2 Answers  

---

- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

0 Answers   CTS,

---

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,

---

How will you make performance better for application including front end and back

2 Answers   Metric Stream,

---

How do I find duplicates in a single column in sql?

0 Answers  

---

what is overloading procedure or overloading function ?

3 Answers   Genpact,

---

Why is stored procedure faster than query?

0 Answers  

---