Oracle PL SQL interview question What is exception and how to handle exception in PLSQL

Oracle PL SQL interview question What is exception and how to handle exception in PLSQL

[yasirkhan-emec]

Sir you are doing a great job ...would like to see a full series on the interview questions not just the definitions and theory but all the scenario based questions .
Also how the interviewer is switching questions from our answers.
Thanks

[parulverma]

Hi Siva, your teaching method is really good. Can you please upload videos on partitioning in Oracle.

[sujaa]

Thank you Siva, the tutorial was very helpful.
Regards,
Sujaa

[sarikabhagwat]

Hi siva,

All videos are very helpful for interviews purpose.

Please give me the query how to sum negative numbers in one row and and positive numbers in second row.
Thanks In advance

[vigneshv]

Sir your videos are very use full for me. Can u upload video for automatic email using trigger concept.? If u uploaded It's very help full for me

[prathameshkhot]

What will happen if I write when others first and the no data found excpetion after that.

Which one will get fire if we don't have data ? When others or when no data found

[suyogthakare]

Sir can we make all the key are composite key. Or only make primary or unique as a composite key

[radhachikkarangappa]

How to handle exception in procedure or function? Can we add exception block in proc/functions?

[sandeeplakkakula]

Shiva can you please explain how How to continue execution of statements after an exception

[likithliki]

Sir please make video an exception propagation

[dheerajvarthi]

Can we write a function without parameters ?

[vaniganapathi]

What is the use of set serveroutput on

[lekhyadivya]

In case we get an error in procedure but we have to ignore the error and continue the dml how can we do that? Please let me know