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

Nice explanation sir..

Shiva truly your contents are spot on ❤😊

Can we use commit in trigger body?

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

I undeestand in function we can do that.

Can you add videos for how create and drop TABLE in side a package please...

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

Q) Can we use Procedure inside the function ? -- I gave the answer YES because in 19c we can use
Q) Can we use a Function inside the Procedure? -- I gave the answer YES

These are interview questions asked in google company please help us to get an answer

Sir can you provide me sql and plsql notes

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

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

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

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

Nice Video!!! Is there any video on "Dynamic SQL"???

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

I have one doubt sir can I modified the views sir

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

You take class of Postgresql DBA ?

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

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

If we dont use the function in select statement, then will it allow us to do dmls and ddls without autonomous transaction aa sir.?

Can we call a procedure inside a function and vice versa . Please explain

declare
n0 number(38):=&n0;
n1 number(38):=&na;
n2 number(38):=&n2;
res number(38'2);
begin
case n0
when 1 then
res:=n1+n2;
dbms_output.put_line('Sum ='||res);
end case;
exception
when no_data_found then
dbms_output.put_line('Number not valid')
end;
/

agr m invalid value enter krra hu to error handle hokr program success ho jaega but m chahta hu k after exception block program again ask me value n number of value means koi bhi value

in short m exception block k bad phr se code run krna chahta hu jo begin section m h

Really awesome ❤️👍

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.

Once in interview interviewer asked me one question. ..


If u have 100000 lines of code and there is runtime error occurred. ..supposed junk value is inserted into a some tables..

How can u resolved it...

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

Siva bhayya,please upload your pic or come live once,we want to see you and love you for your wonderful and valuable videos, keeping going.

nice 👌🏼👌🏼

Hi siva,
You are the amazing person , sharing knowledge not expecting anything .
Your all wishes come true in quick way.

Can you please make video on pragma autonomous transaction .

Thanks sir

Can you explain bulk collect

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.

Excellent explanation in your all videos 🕺🕺👌

Hi sir, can you explain the difference between PL/SQL and Java with SQL?

Can we write autonomous function in SQL server

Can we write autonomous function in SQL server

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

Sir please make a video on partitions and differences between cluster and indexes

Very Nice explanation!!

Wow what an explanation 👌🏼

Hi siva, why procedure cannot be called from sql statement...

FUNCTION COMPILED SUCCESSFULLY BUT IN EXECUTING IN SELECT STATEMENT IT IS ASKING INSUFFICIENT PRIVILEGES
CAN YOU GIVE ME THE SOLUTION FOR THIS

Sir im getting insufficient privileges error on executing execute immediate in function last one plz tell why its so

If am using ddl in function dynamically using execute immediate and pragma autonomous transaction through select statement..it is showing INSUFFICIENT PRIVILEGES

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

Hi,


Well explained! Just can you please confirm below one,


What if we call functions having DML/DDL (using dynamic sql) statements through anonymous pl/sql block instead of using SELECT? I guess Pragma_Autonomous_transaction is not required.


Is that correct ?

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.