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;

Which command is used to delete a package?

1148

---

Are sql connections encrypted?

999

---

How sql query is executed?

1112

---

Is it possible to update views?

947

---

Can we commit inside a trigger?

979

---

What is cursor and its types?

1047

---

How to get list of all tables from a database?

1139

---

Mention what pl/sql package consists of?

980

---

What is rank () in sql?

926

---

What is the difference between cross join and natural join?

999

---

What does an inner join do?

1160

---

What is query execution plan in sql?

1167

---

What is loop in pl sql?

1019

---

How can we solve sql error: ora-00904: invalid identifier?

1236

---

How many sql statements are used?

1001

---