The same question I have been asked in capgemini ...
@subhrapriyadarshini70
5 жыл бұрын
I was never be clear with plsql until i have watched these videos. Thanks for the clear explanation
@SivaAcademy
5 жыл бұрын
@SubhraPriyadarshini, I'm glad it helped, It's my pleasure. Thanks for your comment :-)
@sandeeps373
5 жыл бұрын
Thanks Sir,The video is worth of watching,neatly explained and the contents in your channel seems unique. Keep uploading videos ..
@SivaAcademy
5 жыл бұрын
Thank you 🙏 🙏 🙏 sure, please stay tuned for more videos
@pkrt085
3 жыл бұрын
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.
@SivaAcademy
3 жыл бұрын
Welcome 🙏, thanks for your comments bro 💐
@monicabn3067
10 ай бұрын
Shiva truly your contents are spot on ❤😊
@swamivivekananda-cyclonicm8781
2 жыл бұрын
Fanstatic. Concept becomes clear with perfect example. Thank you.
@SivaAcademy
2 жыл бұрын
Welcome bro
@vishalpathak8835
7 ай бұрын
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🙏🤩🤩
@SivaAcademy
7 ай бұрын
My pleasure bro, thank you
@WorldEye88
4 жыл бұрын
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.
@SivaAcademy
4 жыл бұрын
Welcome 🙏
@Ananda_vmp
3 жыл бұрын
I have been asked the same question by the interviewer. I wish I would have seen your video before heading to the interview .
@SivaAcademy
3 жыл бұрын
No worries, now you will be able to answer 👍👍
@akshaybhong2898
3 жыл бұрын
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..
@SivaAcademy
3 жыл бұрын
Its my pleasure thank you 💐🙏
@premgona5587
6 жыл бұрын
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.
@SivaAcademy
6 жыл бұрын
Right, though we might not use DML in functions, many times this question is being asked in interviews.
@gurumoorthysivakolunthu9878
2 жыл бұрын
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....
@peramsudheerreddy9888
2 жыл бұрын
Tq u so much bro.this question exactly asking in interview.tq so much
@SivaAcademy
2 жыл бұрын
Welcome bro
@sheetalbahirat7664
2 ай бұрын
Procedure execution are inside the function is possible or not?
@hariharan-ze2zq
Жыл бұрын
How to find exact error line while using functions...is there any options...
@ramkumarj4216
3 жыл бұрын
Is there a way to verify the DDL & DML statement execution getting successful inside the PRAGMA autonomous_transaction function.
@akshaybhong2898
3 жыл бұрын
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...
@somyashreem5109
2 жыл бұрын
Please put video of complete SQL course...I am just liking your way of teaching..
@SivaAcademy
2 жыл бұрын
sure bro, please stay tuned
@SatyendraSingh-ul5iq
Жыл бұрын
can we use DML inside a function if we do not call function with select statement.
@ganeshshirke8564
Жыл бұрын
Sir can you provide me sql and plsql notes
@rajasekarm3009
2 жыл бұрын
how to create table and insert values by using DYNAMIC SQL in stored procedure
@pkdancereels
4 жыл бұрын
Excellent explanation in your all videos 🕺🕺👌
@SivaAcademy
4 жыл бұрын
It's my pleasure,Thank you so much :-)
@himanshunikhade1593
5 жыл бұрын
Wow what an explanation 👌🏼
@naveenmogasala7327
3 жыл бұрын
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.
@SivaAcademy
3 жыл бұрын
Sure bro, I will do, thanks for your wonderful comments 🙏💐 and support
@vishalsaxena5081
3 жыл бұрын
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
@pradnyabapat9531
Жыл бұрын
Can we use commit in trigger body?
@nitinmishra5027
5 жыл бұрын
Very Nice explanation!!
@SUJATAMANNA
Жыл бұрын
Hi...can we use commit inside a stored procedure? I undeestand in function we can do that.
@SivaAcademy
Жыл бұрын
Yes we can use commit in procedure
@ashtyson7831
5 жыл бұрын
If am using ddl in function dynamically using execute immediate and pragma autonomous transaction through select statement..it is showing INSUFFICIENT PRIVILEGES
@SivaAcademy
5 жыл бұрын
@Ash Tyson, This should work. Here is a sample code, that i have tested, and its working for me...... create table t1(c1 number); CREATE OR REPLACE FUNCTION fn_test1 RETURN NUMBER AS PRAGMA AUTONOMOUS_TRANSACTION; BEGIN EXECUTE IMMEDIATE 'truncate table t1'; RETURN 1; END; / select fn_test1 from dual; Please check, whether you are able to do dynamic sql with ddl command in some other procedure........
@narendrascollections7445
5 жыл бұрын
Can we write autonomous function in SQL server
@chsurekha4126
3 жыл бұрын
If we dont use the function in select statement, then will it allow us to do dmls and ddls without autonomous transaction aa sir.?
@SivaAcademy
3 жыл бұрын
Yes, this restriction is applicable only if used as part of select statement
@azharsha3476
3 жыл бұрын
Really awesome ❤️👍
@SivaAcademy
3 жыл бұрын
Thank you
@ranjithavellaisamy15
5 жыл бұрын
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 ?
@SivaAcademy
5 жыл бұрын
@Rajitha, Thanks for your comments, You are correct, if the function having DML/DDL(via dynamic SQL) is called through pl/sql, the function will get executed successfully. This I have covered in the second part of video, You can look into this video here, kzitem.info/news/bejne/pH2CvXivraGGmHo Thanks,Siva
@bharathipandian45
5 жыл бұрын
Hi siva, why procedure cannot be called from sql statement...
@SivaAcademy
5 жыл бұрын
@Barathi, procedures are meant for logical implementation, and its not necessary to sent out the value, however function must return value...., and functions meant for computational purpose., may be thats one reason why proc are not supported from SQL statement.....However in with clause, the procedures are supported from recent versions....throug we cannot call directly, we can call procedure via functions.
@RAMPRASAD-sv7is
3 жыл бұрын
Can we call a procedure inside a function and vice versa . Please explain
@SivaAcademy
3 жыл бұрын
yes, we can
@simhadrisuresh8630
2 жыл бұрын
I have one doubt sir can I modified the views sir
@SivaAcademy
2 жыл бұрын
Yes, you can, recreate view with new query
@shaheenshaikh6701
5 жыл бұрын
Sir im getting insufficient privileges error on executing execute immediate in function last one plz tell why its so
@SivaAcademy
5 жыл бұрын
@Shaheen, this might be due to permission/privilege issue, can you try executing "execute immediate" outside of function, ie., in a simple anonymous block
@vikitech9029
2 жыл бұрын
Sorry for the delayed reply but you can grant the privileges to your current user to overcome the issue. "connect/ as sysdba; grant all privileges to hr;"
@govindugovindu617
5 жыл бұрын
FUNCTION COMPILED SUCCESSFULLY BUT IN EXECUTING IN SELECT STATEMENT IT IS ASKING INSUFFICIENT PRIVILEGES CAN YOU GIVE ME THE SOLUTION FOR THIS
@SivaAcademy
5 жыл бұрын
Can you please try as an anonymous block rather than trying in function, check whether you are able to execute ddl from anonymous block using dynamic sql
@SANDEEPSUBH
3 жыл бұрын
You take class of Postgresql DBA ?
@SivaAcademy
3 жыл бұрын
No
@rekhad2756
Жыл бұрын
Can you add videos for how create and drop TABLE in side a package please...
@SivaAcademy
Жыл бұрын
Sure please stay tuned, this needs dynamic sql, will cover in upcoming videos
@rekhad2756
Жыл бұрын
Thank you so much, I know only we can use pragma for using DML and DDL in function, but understood more from this video, nice explanation...
@SivaAcademy
Жыл бұрын
Welcome 🙏💐
@ankithag9152
4 жыл бұрын
Hi sir, can you explain the difference between PL/SQL and Java with SQL?
@SivaAcademy
4 жыл бұрын
Please elaborate your question... Is it Java vs oracle, or sql in Java vs plsql
@rajeshnaidu9331
4 жыл бұрын
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 .
@SivaAcademy
4 жыл бұрын
It's my pleasure,Thank you so much :-)
@pankajkharade6936
3 жыл бұрын
nice 👌🏼👌🏼
@SivaAcademy
3 жыл бұрын
Thanks
@learntolive5001
2 жыл бұрын
Nice Video!!! Is there any video on "Dynamic SQL"???
@SivaAcademy
2 жыл бұрын
Thank you, will post soon, please stay tuned
@sateeshbabu5792
4 жыл бұрын
Thanks sir
@SivaAcademy
4 жыл бұрын
Welcome 🙏
@harishharish-ug7vz
5 жыл бұрын
Sir please make a video on partitions and differences between cluster and indexes
@SivaAcademy
5 жыл бұрын
@Harish, sure, Please stay tuned.
@manjutharak
Жыл бұрын
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
@SivaAcademy
Жыл бұрын
Answer is Yes, but with few limitations, I will cover in detail with examples and limitations soon, please stay tuned
@wishyfisy
7 ай бұрын
Can I send questions now days
@SivaAcademy
7 ай бұрын
Yes, you can send questions to siva.k.academy@gmail.com
@wishyfisy
7 ай бұрын
@@SivaAcademy have sent you a mail with questions and also some request, thanks for replying
@SivaAcademy
7 ай бұрын
Welcome
@mustaqali8849
4 жыл бұрын
Can you explain bulk collect
@SivaAcademy
4 жыл бұрын
Please have a look into this video kzitem.info/news/bejne/0n5qnYF5qImggYo
Пікірлер: 93