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;

Why do we use subquery?

1073

---

What is sql and its types?

1251

---

what does the t-sql command ident_current does? : Transact sql

1045

---

Why do we need a foreign key?

1165

---

Why do we use joins in sql?

1005

---

What is query optimization in sql?

1040

---

What are user defined functions?

1062

---

what is the difference between truncate and drop statements? : Sql dba

1177

---

Which normal form is best?

996

---

How are functions and procedures called in PL/SQL?

1306

---

What are records give examples?

1050

---

Are stored procedures faster than queries?

989

---

what is transaction? : Sql dba

1058

---

What are sql functions? Describe the different types of sql functions?

1209

---

Can you sum a count in sql?

1059

---