I need a exceptoin in pl/sql block so that if any errors
occur in the block then no exception should errors should
raise?
- 1 Answers
- 4598 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
what is primary key? : Sql dba
How do I view tables in sql developer?
What are all types of user defined functions?
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
The select into statement is most often used to create backup copies of tables or for archiving records?
What is normalization in sql?
Can we write dml inside a function in sql server?
Are sql database names case sensitive?
What is trigger explain with example?
Why truncate is used in sql?
what is acid property in database? : Sql dba
How many types of functions are there in sql?
Is sqlite free?
What is trigger in flip flop?
How do you write an inner join query?
