Answer / madhav

Exceptions are 3 types
.Predefined
.by default oracle provide error handlers and error
numbers.user can handle that.
data_not_found,too_many_rows,cursor_already_open
.Non predefined exceptions
.Error handlers are not available
.Only Error numbers are avalable
.By using pragma user can handle that
example:- child_record exception;
pragma exception_init(child_record,-2292);
.User defined exceptions
.Error handlers are not available
.Error numbers are also not available
.user can raise and handle that based on business
logic
example:-no_data exception(declaration section)
raise no_data(execution section)
when no_data then(exception sectiion)
dbms_output.put_line('data is not
available');
end;

Answer / suresh babu

Two types of exceptions used in oracle.
1.Predefined exceptions,which defined by oracle
already.Ex-NO_DATA_FOUND,DIVIDE_BY_ZERO,etc...
2.User defined exceptions,which defined by the user based on
their application requirement.

pragma autonomous_transaction is an independent
transaction.Once we issue commit,we cannot rollback except
the block,where we mentioned autonomous_transaction.

Answer / muthu nagaraj

pragma autonomous_transaction are used to implement DCL
queries in a trigger

Answer / rajesh venati

Exceptions are classified into two types,
They are
1. Predefined Exceptions
2. User Defined Exceptions
==> Oracle created some of the Predefined Exceptions like
ex: no_data_found etc.,

==> User Defined Exceptions are created by us.
types of user defined exceptions are
a. Raise
b. Raise_Application_Error
One more exception also there
pragma exception_init(exception,error_code)

Then come for Pragma Autonomous Transaction.

Pragma Autonomous Transaction is used to commit or rollback
the active block only.
As well as in a triggers dcl commands are not possible to
used, if u want use dcl command inside a triggers then we
will go for pragma autonomous transaction.

Is postgresql a nosql database?

0 Answers  

---

how to do backup entire database? : Transact sql

0 Answers  

---

What are triggers and its uses?

0 Answers  

---

When you have to use a default "rollback to" savepoint of plvlog?

0 Answers  

---

Can we use ddl commands in pl sql?

0 Answers  

---

SELECT emp_num, years, SUM(salary) FROM sales UNION ALL SELECT emp_id, SUM(takehomepay) FROM marketing What error is present in the sample code above? 1. Queries being combined with the UNION ALL statement are not allowed to have SELECT lists with a different number of expressions. 2. You are not allowed to use aggregate functions within two queries joined by a UNION ALL statement. 3. The UNION ALL statement incorrectly combines the "years" result from the first query with the "SUM (takehomepay)" result from the second query. 4. Unless the UNION ALL statement is replaced with a UNION statement, the queries will return duplicates. 5. The "emp_id" column from the second query must be renamed (or aliased) as "emp_num" so that it corresponds to the column name from the first query. Otherwise, the queries will not execute.

3 Answers  

---

Name the operator which is used in the query for pattern matching?

0 Answers  

---

what is difference between stored procedures and application procedures,stored function and application function?

1 Answers  

---

How do you copy a table in sql?

0 Answers  

---

Can we join 3 tables in sql?

0 Answers  

---

Can we use more than one null value for unique key?

31 Answers   A1 Technology, Wipro,

---

What is the use of desc in sql?

0 Answers  

---