Answer Posted / shai

Follow best practice for exceptions:

Try using: (available from 10g)

1. dbms_utility.format_error_backtrace
2. dbms_utility.format_error_stack

Example:

declare
x varchar2(10);
begin
select 15445454545 into x from dual;
exception
when others then
dbms_output.put_line
(dbms_utility.format_error_backtrace || ' ' ||
dbms_utility.format_error_stack);
end;

Explain 3 basic parts of a trigger.

1304

---

What is the cause of mutating table error and how can we solve it?

1044

---

How to display the records between two range in Oracle SQL Plus?

1138

---

Explain the order of sql statement execution?

1040

---

How sql query is executed?

1125

---

what is text? : Sql dba

1065

---

how to include comments in sql statements? : Sql dba

948

---

Can we use the cursor's to create the collection in PL/SQL?

1019

---

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

2478

---

What is a database event trigger?

1153

---

Is it important to partition hard disk?

1022

---

Is it possible to link two groups inside a cross products after the cross products group has been created?

1002

---

what is a table in a database ? : Sql dba

1035

---

How does left join work in sql?

997

---

What is the process of debugging?

1061

---