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.

What are the different ways to optimize a sql query?

949

---

What is nvarchar in sql?

927

---

What is the difference between cluster and non-cluster index?

1108

---

What is partition by in sql?

1071

---

If a cursor is open, how can we find in a pl/sql block?

1167

---

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

958

---

What is sql integrity?

1164

---

What does count (*) mean in sql?

1592

---

How do you sort in sql?

1030

---

Explain correlated query work?

1059

---

what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

1041

---

What are triggers and its types?

1070

---

how to add a new column to an existing table in mysql? : Sql dba

1074

---

Do we need to create index on primary key?

930

---

How to write html code in pl sql?

1119

---