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 you improve the performance of sql*loader? : aql loader

0 Answers  

---

what are properties of a transaction? : Sql dba

0 Answers  

---

What is dml statement?

0 Answers  

---

how to achieve this problem?i am having table with two colums like empno,gender. in gender column, i am having records male,female like that .my final output will be male female 5 6

4 Answers   Hexaware,

---

How can you select unique records from a table?

0 Answers  

---

What is pl sql package?

0 Answers  

---

Does truncate free space?

0 Answers  

---

What is indexing in sql and its types?

0 Answers  

---

What is sql stand for?

0 Answers  

---

what are the non-standard sql commands supported by 'mysql'? : Sql dba

0 Answers  

---

what is the difference between to_char and to_date functions?

10 Answers   Infosys,

---

Can we use join in subquery?

0 Answers  

---