Dynamic SQL / Can we use DDL,DCL commands in Oracle PL SQL Interview Questions And Answers For Experience & Freshers | Interview Preparation

Dynamic SQL / Can we use DDL,DCL commands in Oracle PL SQL Interview Questions And Answers For Experience & Freshers | Interview Preparation

Normally DDL,DCL commands are not allow in PLSQL block. but by using dynamic SQL we can use DDL,DCL commands in PLSQL block.

In this case we can use execute immediate clause. In this execute immediate clause we can use DDL,DCL within single quote.

Uses of dynamic SQL:

1) For dropping all indexes at a time.

2) Dynamic SQL is used in bulk exception. when we using bulk insert and executing program more number of times then data is displayed that number of times. so we need to truncate table but truncate is DDL which not allow to use in PLSQL block. so by using dynamic SQL
We can use this DDL command in PLSQL block. After this if we execute program more number of times also data will be displayed only once.

Please do check our daily posts, videos for beneficial informations, in case of any additional queries please do contact us, we are happy to assist you.

Please Do SUBSCRIBE our Youtube Channel and Support us :-
https://www.youtube.com/a4uofficial

If any difficulties regarding our posts, videos or other problem you can direct contact us:- allforyoucreators@gmail.com

If you found this post was helpful then please don't forget to SUBSCRIBE our channel.

Subscribe us for more such posts, videos and updates.. It's Free!!

Subscribe here : https://www.youtube.com/a4uofficial

For Businesses Inquiries :- allforyoucreators@gmail.com

_____________________________________________________________________________

Join Us on Social Media -

Like our Facebook Page :- https://www.facebook.com/a4u0fficial/

Follow me on Instagram :- https://www.instagram.com/allforyouofficial.01/

Twitter :- https://twitter.com/a4uofficial

Website :- https://allforyouofficial.com/

PLEASE SUBSCRIBE US FOR MORE POSTS, VIDEOS AND STAY TUNED..

CREATIVE, INFORMATIVE & BENEFICIAL CONTENTS TO BE FOUND ON OUR CHANNEL!!

BECAUSE WE KEEP UPLOADING VIDEOS ON YOUTUBE FOR YOU..

ALL WE NEED IS YOUR SUPPORT ❤

=▶ Thanks for your Love and Support ◀=

Copyright ©All For You Official