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 the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

0 Answers  

---

What are the different type of joins in sql?

0 Answers  

---

What is error ora-12154: tns:could not resolve the connect identifier specified?

0 Answers  

---

Why procedure is used in sql?

0 Answers  

---

What port does sql server use?

0 Answers  

---

Why left join is used in sql?

0 Answers  

---

What are the operators in sql?

0 Answers  

---

How to write html code in pl sql?

0 Answers  

---

What are the difference between Functions/Stored Procs and Triggers and where are they used.

1 Answers   CGI, TCS,

---

what does the t-sql command ident_current does? : Transact sql

0 Answers  

---

write a query to find out the no. of employees whose age is less than 25 and max of salary for the employees belonging to a particular department is less than 20000

6 Answers  

---

Why do we create stored procedures & functions in pl/sql and how are they different?

0 Answers  

---