1) Does oracle have any table which contain all the exceptions and it's code internally?
- 1 Answers
- 1842 Views
- CTS, I also Faced
- E-Mail Answers
Answer / Rupali Sachan
Oracle's built-in package DBMS_SQL offers a feature called SAVE EXCEPTION that can be used to save exception information in a table. You can create custom tables to store Oracle errors and their corresponding codes.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is key preserved table?
How do I recompile a procedure in oracle?
What is backup in Oracle?
When do you get a .pll extension in oracle?
Can we create more than one constraint to column ?
Please explain oracle data types with examples?
How to use values from other tables in update statements using oracle?
What are inner join and outer join?
what is a view?
Given two table employee and department EMP ---------------- empid deptid(fk) Dept --------------------- deptid(pk) deptname que-Write a query to find count of employee in each department. Expected Output- deptid countofEmployee --------------------------- 10 57 20 20 30 15
We have one Package(which has many function/procedures, SQL quires etc). Now we need to check, which query or procedure is taking lot of time in that Package. ? How do we do it.
How can windows applications connect to oracle servers?
Oracle General 
