Answer Posted / 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.

Show code of a cursor for loop.

1000

---

Does truncate require commit?

918

---

How do I run a query in pl sql developer?

925

---

Can you have more than one key in a database?

890

---

how do you login to mysql using unix shell? : Sql dba

1016

---

What do you know by pl/sql cursors?

1034

---

What is sqlerrm?

882

---

what are all types of user defined functions? : Sql dba

996

---

explain the advantages and disadvantages of stored procedure? : Sql dba

956

---

Why do we need cursors in pl sql?

1001

---

Explain isolation levels. : Transact sql

1015

---

Can we debug stored procedure?

957

---

How many types of relationship are there?

973

---

What is the use of sql trace?

894

---

Can sql function call stored procedure?

956

---