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;

What are aggregate functions in sql?

0 Answers  

---

how to use in conditions? : Sql dba

0 Answers  

---

What is acid property in a database?

0 Answers  

---

What is a merge query?

1 Answers  

---

How can I make sql query run faster?

0 Answers  

---

---

What does the acronym acid stand for in database management?

0 Answers  

---

What is a nested table in word?

0 Answers  

---

Can a commit statement be executed as part of a trigger?

0 Answers  

---

Is a foreign key always unique?

0 Answers  

---

select top 3 sal from each dept?

17 Answers   IBM, TCS,

---

What is the difference between a primary key and a unique key?

0 Answers  

---

How do you declare a variable in pl sql?

0 Answers  

---