Answer / joseph p v

I think your question is as follows.
I need an exception in pl/sql block so that if any errors
occur in the block then no exception should raise?

For that see the below code part :-

exception
when others then
null;

--Example
declare
cha char(5):='TEST';
num number;
begin
num := cha;
exception
when others then null;
end;

How to find only %th Highest Sal

6 Answers   Infogain, Symphony,

---

Could you please provide oca (oracle 10g) dumps for my certification ?

1 Answers  

---

Which is faster joins or subqueries?

0 Answers  

---

What are the disadvantages of file system?

0 Answers  

---

what are the tunnig tables you used for tuning a query and tell me some of coloumns in that tuning tables?

1 Answers   Metric Stream,

---

what is the difference between join and union? : Sql dba

0 Answers  

---

SQL Tuning, Oracle Server 10g: Why is the following hint invalid? SELECT /*+ first_rows parallel(table_name,paral_number)*/

1 Answers   Accenture,

---

How to set up sql*plus output format in oracle?

0 Answers  

---

What is scalar and vector?

0 Answers  

---

while loading data into database how can u skip header and footer records in sql*loader

1 Answers   Oracle,

---

What is a variable in sql?

0 Answers  

---

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

0 Answers  

---