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

[@abhijeetshinde6303]

Your teaching skill, examples are just amazing..... Your's Each and Every video is building concepts.... I always think why i haven't seen your series before 6 years😊❤....

[@SivaAcademy]

Thank you bro 🙏💐

[@yasirkhan-em8ec]

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

[@SivaAcademy]

@Yasir, Thanks for your comment, For every question, I am trying to show give maximum information ( Theroy + Demo ), and will try to add more real time scenarios more in upcoming videos. Will add the "switching questions" part also wherever applicable from next video. stay tuned.

[@chavannamdev1959]

@@SivaAcademy thank you sir

[@jebba555]

Thank you Bro....

[@sujaa1000]

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

[@SivaAcademy]

Welcome :-)

[@learnwithrajkumar252]

Ur teaching is awesome

[@SivaAcademy]

🙏 for your comment bro

[@parulverma3888]

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

[@SivaAcademy]

Sure, please stay tuned for more videos

[@gsraj511]

Thanks Siva...

[@SivaAcademy]

Welcome George

[@sarikabhagwat6498]

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

[@SivaAcademy]

Thank you, pls find the query create table t1 (col1 number); insert into t1 values(1); insert into t1 values(2); insert into t1 values(3); insert into t1 values(-4); insert into t1 values(-5); insert into t1 values(-6); select decode(sign(col1),1,'Positive','Negative'),sum(col1) from t1 group by sign(col1);

[@sarikabhagwat6498]

Thank you so much for quick response

[@sandeeplakkakula6279]

Thank you so much

[@SivaAcademy]

Welcome bro 🙏

[@vigneshv6603]

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

[@SivaAcademy]

@Vignesh, sure I will post a video soon covering mailing features in PLSQL.

[@vigneshv6603]

@@SivaAcademy thanks

[@csekathir1]

Great sir

[@SivaAcademy]

🙏 Thank you

[@Abhi-yp9um]

Please provide mcqs also

[@radhachikkarangappa4132]

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

[@SivaAcademy]

Yes, we can have exception across all plsql block

[@suyogthakare828]

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

[@SivaAcademy]

Any columns can be added as part of composite key, it doesn't have to be unique or pk key column

[@suyogthakare828]

Sir i mean to say which constraint we make as composite key

[@sandeeplakkakula4301]

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

[@SivaAcademy]

@sandeep, you can handle exception for each statement, so that after execution and handling of exception from each statement, it continues with next statement. will explain with an example soon, please stay tuned.

[@dheerajvarthi4657]

Can we write a function without parameters ?

[@SivaAcademy]

Yes we can

[@vaniganapathi830]

What is the use of set serveroutput on

[@SivaAcademy]

to enable the display of buffer values in output screen

[@manikandanr1682]

How to apply fresher sql developer

[@lekhyadivya2626]

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

[@SivaAcademy]

Handel the error only for that dml statement, after handling the error you can continue with rest of the statements

[@lekhyadivya2626]

@@SivaAcademy in procedure we have return insert statement which inserts 100 rows, after inserting 50 rows there was some data error on 51st row but still we should ignore and continue from 52nd row insertion. This was one interview question.please let me knoe

[@SivaAcademy]

You can check of DML error logging tables, this will capture the errors,also proceed with inserting the subsequent rows

[@lekhyadivya2626]

@@SivaAcademy thank you

[@patrikmelichercik7709]

Hi Siva, i have seen many times that there is keyword IS or AS in the definition of Pl/SQL blocks of a function ,store procedure etc. is there any difference? thx

[@LIKHITH_MS]

Sir please make video an exception propagation

[@SivaAcademy]

@Likthith, sure, Please stay tuned. Will post on exception propagation soon.

[@prathameshkhot5717]

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

[@SivaAcademy]

When others should be the last cluase, otherwise you will get compilation error

[@vivekkhurpe1005]

Create video for error 38824