Answer Posted / tulsi

Exception is the error handling part of PL/SQL block. The
types are Predefined and user_defined. Some of Predefined
execptions are.
CURSOR_ALREADY_OPEN
DUP_VAL_ON_INDEX
NO_DATA_FOUND
TOO_MANY_ROWS
INVALID_CURSOR
INVALID_NUMBER
LOGON_DENIED
NOT_LOGGED_ON
PROGRAM-ERROR
STORAGE_ERROR
TIMEOUT_ON_RESOURCE
VALUE_ERROR
ZERO_DIVIDE
OTHERS.

Can a key be both primary and foreign?

986

---

Is sql workbench free?

984

---

How do you use collections in procedure to return the resultset?

2235

---

Explain the order of sql statement execution?

1037

---

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

957

---

what are different types of collation sensitivity? : Sql dba

1060

---

How do you determine the current isolation level? : Transact sql

1146

---

what are the non-standard sql commands supported by 'mysql'? : Sql dba

1114

---

Is coalesce faster than isnull?

961

---

Is drop table faster than truncate?

984

---

What is localdb mssqllocaldb?

1064

---

How can a pl sql block be executed?

941

---

How to convert comma separated string to array in pl/sql?

1169

---

What are the different type of joins in sql?

943

---

which types of join is used in sql widely? : Sql dba

975

---