set serveroutput on; accept var_age number prompt 'What is your age'; declare ex_age exception; age number := &var_age; pragma exception_init(ex_age, -20008); begin if age < 18 then raise_application_error(-20008, 'You should be 18 or above for the drinks!'); end if; dbms_output.put_line('Sure!What would you like to have?'); exception when ex_age then dbms_output.put_line(SQLERRM); end; /
@NehaJain-ry9sr
4 жыл бұрын
Thanks Manish.. Your tutorial videos made PL/SQL easy to me.. keep it up.. my best wishes to you :)
@Rebellionrider
4 жыл бұрын
Glad to hear that😊. Thank you so much
@SuvradipDasPhotographyOfficial
5 жыл бұрын
exception handling done. AWESOME AWESOME AWESOME
@AnkurSharma-oz6dp
5 жыл бұрын
Thanks a lot for this video. A very big confusion of mine got cleared.👍
@Rebellionrider
5 жыл бұрын
Thanks for your appreciation. I'm glad that you liked my content.
@ankammareddybhavanam5269
6 жыл бұрын
Your videos helps me alot. Thank you manish
@trusharpatel5033
6 ай бұрын
Can you make a video on Oracle Interface data transfer Process..
@anujrana15893
6 жыл бұрын
if we change error number in raise_application_error then how oracle will find the error it has to handle is the one we created using pragma exception_Init ?
@NPC_YOUTUBE_USER
7 ай бұрын
Why we in EXCEPTION set 'WHEN ex_age'? Better is to set 'WHEN OTHERS' because that works for all, and 'WHEN ex_age' works only for 'ex_age'
@SivaKumar-rv1nn
3 жыл бұрын
Thankyou sir
@sivakrishna3550
7 жыл бұрын
hi sir, you are doing a great job. really your tutorials are helping me alot. if possible, can you please make tutorials on forms and reports.. thanq very much boss..
@mallu529
6 жыл бұрын
Thanks for your videos
@oracle_professor
7 жыл бұрын
Good effort
@dhpratik
5 жыл бұрын
accept myAge number prompt 'what is my age?'; declare ex_age Exception; age number := &myAge; pragma exception_init (ex_age, -20008); begin if age
@PriyaSingh-hx5dc
7 жыл бұрын
nice :) i learned something
@shaheenshaikh6701
5 жыл бұрын
Sir in this same program im getting illegal no of arguments for pragma exception_init plzz help ! Thnks !!
@TheCocoglam1
7 жыл бұрын
Thankyou :)
@shaheenshaikh6701
5 жыл бұрын
Sir why its -20008 means how to took this no
@aniketkoley9842
4 жыл бұрын
between -20,000 to -20,999
@siddhartha1310
7 жыл бұрын
Bro will be covering objects in plsql
@divyadevaraj5682
Жыл бұрын
Accept var_age number prompt "enter age"; Declare Age:=&var_age; Ex_exp exception ; Pragma exception_init(ex_exp,-2009); Begin If age
@shaheenshaikh6701
5 жыл бұрын
Sir whts the range of error codes for pragma exception_init function
@aniketkoley9842
4 жыл бұрын
-20,000 to -20,999 .
@azmalkhan8664
5 жыл бұрын
Please remove the music.its a kind of disturbance to learn ..
Пікірлер: 28