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 happens if you no create privilege in a database? : Sql dba

0 Answers  

---

How to find string or key value using pl/sql code?

2 Answers   Ramco,

---

Is crud a cuss word?

0 Answers  

---

explain the difference between bool, tinyint and bit. : Sql dba

0 Answers  

---

How can triggers be used for the table auditing?

0 Answers  

---

what is normalization? : Sql dba

0 Answers  

---

how to check myisam tables for errors? : Sql dba

0 Answers  

---

What is prepared statement in sql?

0 Answers  

---

i have a table with fields(id,name,accnt_type)and in account type are FD,SAVING,RD. Write a query to get How many number of People are in each type of Account?

6 Answers   Fidelity, IBM,

---

ename empno deptno amar 1 10 akbar 2 20 anthonny 3 30 jonathan 4 40 write a procedure to dispaly the column values ina row separated by a deleimiter eg - input - select ename from emp '|' output - amar|akbar|anthony|jonathan input - select empno from emp '@' o/p - 1@2@3@4 input - select deptno from emp '/' o/p - 10/20/30/40 Pls answer this questn.

2 Answers  

---

use of IN/ANY/ALL

5 Answers   Ramco,

---

how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

0 Answers  

---