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

Подписаться 46 тыс.

Просмотров 61 тыс.

50% 1

Oracle PL SQL interview question What is exception and how to handle exception in PLSQL
Click here to subscribe to my youtube channel / @sivaacademy
Oracle Interview questions and Answers at • oracle interview quest...
Oracle 18C New features at • Oracle 18C New Feature
Oracle 12C New features at • Oracle 12C New Feature...
Oracle PLSQL records and collections at • oracle plsql records a...

Наука

Опубликовано:

14 янв 2019

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 48

@sujaa1000 4 года назад

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

@SivaAcademy 4 года назад

Welcome :-)

@yasirkhan-em8ec 5 лет назад

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 5 лет назад

@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 3 года назад

@@SivaAcademy thank you sir

@jebba555 4 года назад

Thank you Bro....

@learnwithrajkumar252 5 лет назад

Ur teaching is awesome

@SivaAcademy 5 лет назад

🙏 for your comment bro

@sandeeplakkakula6279 4 года назад

Thank you so much

@SivaAcademy 4 года назад

Welcome bro 🙏

@parulverma3888 4 года назад

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

@SivaAcademy 4 года назад

Sure, please stay tuned for more videos

@gsraj511 2 года назад

Thanks Siva...

@SivaAcademy 2 года назад

Welcome George

@csekathir1 5 лет назад

Great sir

@SivaAcademy 5 лет назад

🙏 Thank you

@sarikabhagwat6498 3 года назад

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 3 года назад

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 3 года назад

Thank you so much for quick response

@vigneshv6603 5 лет назад

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 5 лет назад

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

@vigneshv6603 5 лет назад

@@SivaAcademy thanks

@Abhi-yp9um Год назад

Please provide mcqs also

@sandeeplakkakula4301 4 года назад

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

@SivaAcademy 4 года назад

@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.

@suyogthakare828 4 года назад

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

@SivaAcademy 4 года назад

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

@suyogthakare828 4 года назад

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

@radhachikkarangappa4132 2 года назад

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

@SivaAcademy 2 года назад

Yes, we can have exception across all plsql block

@likith4888liki 4 года назад

Sir please make video an exception propagation

@SivaAcademy 4 года назад

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

@manikandanr1682 Год назад

How to apply fresher sql developer

@vaniganapathi830 2 года назад

What is the use of set serveroutput on

@SivaAcademy Год назад

to enable the display of buffer values in output screen

@dheerajvarthi4657 2 года назад

Can we write a function without parameters ?

@SivaAcademy Год назад

Yes we can

@prathameshkhot5717 2 года назад

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 2 года назад

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

@lekhyadivya2626 4 года назад

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 4 года назад

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

@lekhyadivya2626 4 года назад

@@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 4 года назад

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

@lekhyadivya2626 4 года назад

@@SivaAcademy thank you

@patrikmelichercik7709 3 года назад

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