Oracle interview question : Can we use DML and DDL statements inside function?

Oracle interview question : Can we use DML and DDL statements inside function?

[subhrapriyadarshini]

I was never be clear with plsql until i have watched these videos. Thanks for the clear explanation

[sandeeps]

Thanks Sir, The video is worth of watching, neatly explained and the contents in your channel seems unique. Keep uploading videos ..

[WorldEye]

This is very helpful. I would suggest never executing DDL ststms in a function but if it must be done, now it is clear how to. Thank you.

[pkrt]

sir, I have just gone through your vedio..it really helpful for the beginners as well as for experienced professionals. thanks for this great work.

[monicabn]

Shiva truly your contents are spot on ❤😊

[akshaybhong]

Like all your videos sir...and your actually explaining with real time scenario so it will help very well to understand and explain in interviews..

[vishalpathak]

Very nice video of plsql, well explained. I used to refer my friends "siva Academy" for plsql. Excellent work shiva🎉🥳🥳👏👏 with this video series i have learnt a lot, and switched 2 companies till date🙏🤩🤩

[premgona]

Good question... But as per my knowledge I feel like it is a dummy question... No one use Function to do the DML and DDL... Function generally used for computing the results means returning the calculations of some operation...
DDL statements can be applied directly by using the plsql anonymous block if we don't want to run sql statements.

For this question, my answer also is YES.. We can use DML and DDL inside a function by using the select statement as well as pl/sql anonymous block.

I have tried both the ways and it worked.

[Ananda_vmp]

I have been asked the same question by the interviewer. I wish I would have seen your video before heading to the interview .

[gurumoorthysivakolunthu]

Thank you, Sir....
...
If we are calling the function seperately not in select statement -- do we still need to mention
Thank you, Sir....

[ramkumarj]

Is there a way to verify the DDL & DML statement execution getting successful inside the PRAGMA autonomous_transaction function.

[peramsudheerreddy]

Tq u so much bro.this question exactly asking in interview.tq so much

[swamivivekananda-cyclonicm]

Fanstatic. Concept becomes clear with perfect example. Thank you.

[somyashreem]

Please put video of complete SQL course...I am just liking your way of teaching..

[rajasekarm]

how to create table and insert values by using DYNAMIC SQL
in stored procedure

[pkdancereels]

Excellent explanation in your all videos 🕺🕺👌

[sheetalbahirat]

Procedure execution are inside the function is possible or not?

[SatyendraSingh-uliq]

can we use DML inside a function if we do not call function with select statement.

[hariharan-zezq]

How to find exact error line while using functions...is there any options...

[SUJATAMANNA]

Hi...can we use commit inside a stored procedure?

I undeestand in function we can do that.