I need a exceptoin in pl/sql block so that if any errors
occur in the block then no exception should errors should
raise?
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 |
List the various privileges that a user can grant to another user?
Which version of sql do I have?
How to count the no of records of a table without using COUNT function?
what is explain plan?, given an example...
Is primary key clustered or nonclustered?
how i do the database testing of online money transactions between two parties (client and organization). suppose our company makes a website for our client and give a extra feature of online money transaction with there clients then how i test this feature in database testing
Can we perform dml on view?
which will default fire first statement level trigger or row level trigger
2 Answers Cap Gemini, Data Vision,
what is a tablespace? : Sql dba
What are the qualities of 2nf?
source destination distance chennai bangalore 500 bangalore chennai 500 hyd delhi 1000 delhi hyd 1000 bangalore hyd 800 Here chennai to bangalore and bangalore to chennai is same distance. and hyd and delhi also same criteria. Based on the distance i want to display only one row using sql query?
Can instead of triggers be used to fire once for each statement on a view?