Answer Posted / chintu

Any ubnormal event in a program is called Exception.
In pl/ sql there are two types of exceptions they are
Userdefind Exception and predefined Exceptions.
Predefined exceptions 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.
user defined exceptions are defined by raise_application_
error("error msg","error number") and
pragma_exception_init()

what is the command line end user interface - mysql? : Sql dba

925

---

Explain locks? : Transact sql

949

---

What are different types of queries in sql?

1044

---

What is row_number () in sql?

930

---

Can a commit statement be executed as part of a trigger?

995

---

What is the sql*loader? : aql loader

1003

---

Is sql a microsoft product?

895

---

what is datawarehouse? : Sql dba

952

---

How do you delete duplicates in sql query using rowid?

891

---

explain advantages of innodb over myisam. : Sql dba

1082

---

What is the example of procedure?

873

---

Why triggers are used?

936

---

What is sql*loader?

1071

---

Is sql a dbms?

937

---

Why do we need cursor in pl sql?

1078

---