Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


I need a exceptoin in pl/sql block so that if any errors
occur in the block then no exception should errors should
raise?



I need a exceptoin in pl/sql block so that if any errors occur in the block then no exception shou..

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;

Is This Answer Correct ?    5 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

There is a table, In one column it has implemented a index, but the index is disturbed by the regular dml statements.. but still we need to keep the index. how it is possible?

1 Answers   Cognizant,


How do u count no of rows in a table?

8 Answers   CTS,


What is nested table in pl sql?

0 Answers  


When would you denormalize?

8 Answers   MBT, Microsoft, MMU,


What does := mean in pl sql?

0 Answers  






How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from <table_name>; except this you can't use another select statement. You can use no of variables as per requirement.

1 Answers  


Does it possible to pass object (or) table as an argument to a remote procedure?

1 Answers   TCS,


how to get a list of all tables in a database? : Sql dba

0 Answers  


What is a sql statement?

0 Answers  


What is hibernate and its relation to sql?

0 Answers  


Differentiate between sga and pga.

0 Answers  


What happens when a trigger is associated to a view?

0 Answers  






Categories