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 fetch common records from two tables? : Sql dba

0 Answers  

---

Is it possible for a table to have more than one foreign key?

0 Answers  

---

What is query syntax?

0 Answers  

---

Is join and inner join the same?

0 Answers  

---

Can you alter start with clause?

1 Answers   TCS,

---

---

What are the uses of merge?

0 Answers  

---

What is composite primary key in sql?

0 Answers  

---

how to create a new view in mysql? : Sql dba

0 Answers  

---

What are the types of join and explain each?

0 Answers  

---

What is a data manipulation language?

0 Answers  

---

How many row comparison operators are used while working with a subquery?

0 Answers  

---

What is union and union all keyword in sql?

0 Answers  

---