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;

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

0 Answers  

---

What is difference between pl and sql?

0 Answers  

---

What is procedure explain with example?

0 Answers  

---

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

0 Answers  

---

What are the benefits of stored procedures?

0 Answers  

---

What is a function in oracle pl sql?

0 Answers  

---

What is sql prepared statement?

0 Answers  

---

what is a table in a database ? : Sql dba

0 Answers  

---

How do you handle exceptions. Give the syntax for it?

1 Answers   BCL, Microsoft,

---

What are the different tcl commands in sql?

0 Answers  

---

Define sql delete statement.

0 Answers  

---

How many types of literals are available in pl sql?

0 Answers  

---