Answer / guest

A View can be updated/deleted/inserted if it has only one
base table if the view is based on columns from one or
more tables then insert, update and delete is not possible.

Answer / anurag

Also with the help of instead of trigger we can update the
view

Answer / swapnareddy

A View can be updated/deleted/inserted if it has only one
base table if the view is based on columns from one or
more tables then insert, update and delete is possible with
thehelp of instead of trigger.

Can procedure in package be overloaded?

0 Answers   EXL,

---

What is the diff between Truncate table / delete <table name> purge

3 Answers   TCS,

---

What program will open a mdb file?

0 Answers  

---

Why do we use procedures in sql?

0 Answers  

---

what is collation? : Sql dba

0 Answers  

---

---

How do I add a database to sql?

0 Answers  

---

What is an implicit commit?

0 Answers  

---

PL/SQL allocates memory for the variable's at runtime or at compile time

3 Answers  

---

Is sql injection illegal?

0 Answers  

---

Is it possible for a table to have more than one foreign key?

0 Answers  

---

how view used for security purposes?

3 Answers   Glam India,

---

Which one of the following is a reason that an INSERT statement might cause an error instead of executing correctly? 1. The INSERT statement was attempting to insert a record into a view that was created from more than one table. 2. The INSERT statement was attempting to insert a record using a combination of constants and values from an existing table. 3. The INSERT statement was attempting to insert a record with a non-NULL value into a table that has that column defined as NULL. 4. The INSERT statement was attempting to insert a record into a table by selecting a record from that same table. 5. The INSERT statement was attempting to insert a record into a view rather than a table.

1 Answers   Sonata,

---