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 are triggers and its types?

1116

---

what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

1074

---

How can I make sql query run faster?

1063

---

Is sql similar to python?

1032

---

what are the different type of normalization? : Sql dba

1063

---

What is a recursive join sql?

1110

---

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

5238

---

how to use in conditions? : Sql dba

1056

---

what is data control language? : Sql dba

1065

---

What is pivot query?

1117

---

how to shutdown mysql server? : Sql dba

1142

---

What does subquery mean in sql?

1112

---

what is oltp (online transaction processing)? : Sql dba

1125

---

How does postgresql compare to "nosql"?

1078

---

Describe types of sql statements?

1101

---