I got clear picture on exceptions, till not i m very much confused as my complete journey from starting of my career, i was involved only into support project. Never got chance to write code, we will always miss clarity on small points. Now with this series on exception it ruled out all my confusion. thq so much
@SivaAcademy
3 жыл бұрын
Its my pleasure
@sujaa1000
4 жыл бұрын
Thank you Siva, I am understanding exception handling better. Regards, Sujaa
@SivaAcademy
4 жыл бұрын
It's my pleasure,Thank you so much :-)
@swamivivekananda-cyclonicm8781
2 жыл бұрын
Really Underated channel. Excellent videos.
@SivaAcademy
2 жыл бұрын
Thank you
@Ashokkumar-qx7ld
7 ай бұрын
fantastic explanation. you are fabulous :)
@SivaAcademy
7 ай бұрын
Thank you
@randomcreator1006
5 жыл бұрын
please make videos on performance tuning in Oracle. and thanks for the awesome and helpful videos.
@SivaAcademy
5 жыл бұрын
@Ankur, Thanks for your comments, Sure, will post performance related videos soon, Please stay tuned Regards, Siva
@SudhirBhajnawale
4 жыл бұрын
@@SivaAcademy I also waiting for Performance Tuning Videos . Your explain very nicely all the concepts . Thanks in Advance
@lekhyadivya2626
4 жыл бұрын
Very informative a d easy to understand... Nice sir
@SivaAcademy
4 жыл бұрын
Welcome
@ghoshjayanta10
2 жыл бұрын
Hi Siva sir, like other exceptions(user defined/system defined exceptions) this would move the control to the exception handling section. But this raise_application_error does not need any exception handling section to be defined. It would just stop execution and return to caller program? Is my understanding is correct?
@gouthamipasham4901
3 жыл бұрын
how are we handling an exception after raising it using raise_application_error ? is it just by using when others clause in the calling procedure exception block?
@muhammadyasir8880
Жыл бұрын
Exceptional video 🤩
@SivaAcademy
Жыл бұрын
Thank you
@gsraj511
2 жыл бұрын
Thanks Siva.
@SivaAcademy
2 жыл бұрын
Welcome bro
@Shivanshkamti9390
2 жыл бұрын
We should take code.... any number between range is given.
@mdnizamraza7939
4 жыл бұрын
What is the use of third parameter in raise_application_error()? Plz explain it with an example.
@siddhartharao8490
2 жыл бұрын
Sir, can we use pre defined error code in any user defined exception. For Ex : ORA-01476 is Zero Divide Exception. Can we use this zero divide exception error code as a part of Raise application error or Pragma exception_init?
@singaravelulingam6368
5 жыл бұрын
Hi Thanks lot for your videos , Could you please confirm do we need to add exception part for raise_application_error as same for raise ?
@SivaAcademy
5 жыл бұрын
@singaravelu, it depends of you/functionality, if you are not handling, automatically the exception will thrown back to calling api., but generally we use raise_application_error to throw back the exception to caller with user defined error message.
@singaravelulingam6368
5 жыл бұрын
@@SivaAcademy thanks for your response
@vickypatekar9532
5 жыл бұрын
Siva Sir pls tell me the Difference between Raise application error and Pragma exception init?
@SivaAcademy
5 жыл бұрын
@vicky, please watch video no 31 and 32, I will explain in detail about difference only in next subscriber reply video, please stay tuned.
@achyutdeokatepatil897
5 жыл бұрын
Hi sir, your videos are very powerful as knowledge perspective, thanks you for this work. Also can you elaborate on compound trigger with example.
@SivaAcademy
5 жыл бұрын
Thanks for your comments bro 🙏 🙏, the next video on interview question series will be compound trigger only, the content I have already created, just I need to record edit and post. Will try to post this week. Please stay tuned
@achyutdeokatepatil897
5 жыл бұрын
@@SivaAcademy Thank you..
@nandiniadatrao4825
2 жыл бұрын
What is the difference between raise application error and pragma exception init sir??
@SivaAcademy
2 жыл бұрын
raise application error --> to raise user defined expection pragma exception init --> to give a name for un-nammed exception, pls let me know if its clear, else i will post a video clarifying the same
@sharathyamsani7117
2 жыл бұрын
Can we use EXCEPTION When OTHERS THEN ---code1 when NO_DATA_FOUND then --code2 end;
Пікірлер: 40