Answer Posted / 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;

Can a table have no primary key?

1068

---

what is the difference between truncate and delete statement? : Transact sql

1073

---

What is pl sql in dbms?

954

---

What is the purpose of the partition table?

1049

---

What is cursor explain with example?

992

---

What is a sql profiler?

1032

---

what happens if null values are involved in expressions? : Sql dba

1045

---

What is a loop in sql?

990

---

What is interval partition?

1061

---

Is sql a scripting language?

1022

---

Write a sql query to find the names of employees that begin with ‘a’?

1017

---

What is sql*loader and what is it used for?

1158

---

What is the purpose of cursors in pl/sql?

1138

---

what is “go” in t-sql? : Transact sql

1113

---

what is the different between now() and current_date()? : Sql dba

1026

---