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 do you mean by “trigger” in sql?

0 Answers  

---

Name three sql operations that perform a sort.

0 Answers  

---

What is the primary key?

0 Answers  

---

Enlist the characteristics of pl/sql?

0 Answers  

---

Why is partition used in sql?

0 Answers  

---

Who is the owner of mysql database?

0 Answers  

---

How global cursor can be declare with dynamic trigger ?

0 Answers  

---

what are Dynamic SQL statements?

9 Answers  

---

what are date and time intervals? : Sql dba

0 Answers  

---

What is a data definition language?

0 Answers  

---

What are the differences between in and exists clause?

0 Answers  

---

Table Student has 3 columns,Student_id,Student_Name & Course_Id. Table Course has 2 columns, Course_Id & Course_Name.Write a query to listdown all the Courses and number of student in each course.

10 Answers   TCS,

---