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;

What is a unique key?

1054

---

What is the purpose of the partition table?

1049

---

Why is a trigger used?

940

---

What is exception? What are the types of exceptions?

1073

---

What are some emotional triggers?

985

---

Explain the difference between triggers and constraints?

975

---

What is difference between sql function and stored procedure?

1002

---

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

1066

---

Is it possible to create startup or shutdown trigger for on-schema?

1029

---

Differentiate between % rowtype and type record.

1301

---

What is the use of & in pl sql?

1046

---

How can you load microsoft excel data into oracle? : aql loader

1174

---

What is pl sql in oracle?

1041

---

How does one load ebcdic data? : aql loader

1171

---

What is varchar data type in sql?

1082

---