HomeОбразованиеRelated VideosMore From: Manish Sharma

PL/SQL tutorial 84: ALTER & DROP table DDL with Execute Immediate of Dynamic SQL

46 ratings | 3297 views
Learn how to modify and delete a table using ALTER and DROP TABLE DDL with EXECUTE IMMEDIATE of native dynamic SQL in Oracle Database by Manish Sharma from RebellionRider.com 02:12 ALTER TABLE with Execute Immediate 04:48 DROP TABLE with Execute Immediate ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/nds-5 Previous Tutorial ► PL/SQL Tutorial 83 https://youtu.be/dl39itjrWYw ► Facebook Note Ora--12505 TNS error http://bit.ly/Ora-12505 ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ------------------------------------------------------------------------- ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ ___Facebook Official Page of Manish Sharma___ https://www.facebook.com/TheRebellionRider/ ___Facebook Official Page of RebellionRider.com___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check the About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Html code for embedding videos on your blog
Text Comments (5)
Manish Sharma (11 months ago)
Why this tutorial? Some may find the topic irrelevant, but it’s not rather it is a very important topic especially from Oracle Certification and Interview perspective. Also, being a developer we all must have our fundamentals clear because you never know when you will need it. Thanks and enjoy
ganny C (11 months ago)
Please do a video on Materialized View..
samba siva (7 months ago)
Hi I have small doubt which scenario we need to run ddl statement in plsql block. We can create ,altar, truncate table directly. Why should I go for plsql block? Thanks in advance.
Pragash T (8 months ago)
Could please explain Execute immediate "Alter session enable parallel dml" . Thanks in advance
mahi4121 (11 months ago)
Thanks for such an insightful lecture

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.