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

preview_player
Показать описание

02:12 ALTER TABLE with Execute Immediate
04:48 DROP TABLE with Execute Immediate
------------------------------------------------------------------------
►►►LINKS◄◄◄
Previous Tutorial
► Facebook Note Ora--12505 TNS error

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

___Facebook Official Page of Manish Sharma___

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

♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
  1. Manish Sharma
  2. SQL
  3. rebellion rider
  4. SQL tutorials
  5. PL/SQL tutorials
  6. PL/SQL
Рекомендации по теме
PL/SQL tutorial 84: 0:07:46

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

Oracle PL/SQL -- 0:05:40

Oracle PL/SQL -- Alter Table Statement (Part--1)

84.SCOPE OF THE 0:03:21

84.SCOPE OF THE CURSOR AND FETCH OPTIONS IN SQL

ALTER TABLE 0:01:04

ALTER TABLE

Rename Table and 0:03:45

Rename Table and Drop Table In Oracle Pl/SQL

68/125 Oracle PLSQL: 0:16:10

68/125 Oracle PLSQL: Dynamic SQL / Execute Immediate 1

14. Drop Table 0:02:11

14. Drop Table Statement in Oracle PL/SQL

PL/SQL tutorial 82: 0:10:32

PL/SQL tutorial 82: How to Execute DDL statements with Execute Immediate Dynamic SQL

Oracle SQL Developer 0:01:21

Oracle SQL Developer Tutorial For Beginners 84 SELECT EVERYTHING

PL/SQL tutorial 88: 0:07:51

PL/SQL tutorial 88: PL/SQL Block using Execute Immediate of Dynamic SQL by Manish Sharma

PL/SQL tutorial 85: 0:08:45

PL/SQL tutorial 85: Execute Immediate with Using Clause in Native Dynamic SQL by Manish Sharma

14-Group By Rollup 0:02:56

14-Group By Rollup | SQL Tutorial

PL/SQL tutorial 80: 0:04:31

PL/SQL tutorial 80: Introduction to Native Dynamic SQL by Manish Sharma

ORACLE SQL AND 0:13:18

ORACLE SQL AND PL/SQL INTERVIEW QUESTION : HOW TO CHANGE DATATYPE IN ORACLE SQL?

Alter Command in 0:16:49

Alter Command in Oracle - SQL with Example

84. Introduction to 0:18:16

84. Introduction to Procedure and Function in PL/SQL Oracle

PL/SQL tutorial 81: 0:08:51

PL/SQL tutorial 81: PL/SQL Execute Immediate with INTO clause in Oracle Database

70/125 Oracle PLSQL: 0:08:13

70/125 Oracle PLSQL: Dynamic SQL / Execute Immediate 3

Select Insert Update 0:06:25

Select Insert Update Delete Using Stored Procedure in Oracle

DYNAMIC SQL WITH 0:19:41

DYNAMIC SQL WITH EXECUTE IMMEDIATE IN ORACLE PL/SQL

PL/SQL tutorial 86: 0:12:29

PL/SQL tutorial 86: Multiple Bind Variable with Execute Immediate of Dynamic SQL By Manish Sharma

69/125 Oracle PLSQL: 0:07:26

69/125 Oracle PLSQL: Dynamic SQL / Execute Immediate 2

Oracle execute immediate 0:06:47

Oracle execute immediate dynamic sql delete with and without using bind argument Part 4

84.SCOPE AND FETCH 0:04:59

84.SCOPE AND FETCH OPTIONS OF CURSOR IN SQL - HINDI

Комментарии
Автор

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

Rebellionrider
Автор

Please make a Dynamic SQL video using DBMS_SQL package. like DBMS_SQL.Parse..etc.

lakshaygulati
Автор

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.

sambasiva
Автор

Can u explain menu driven program to add, delete a column in plsql

pradeepgs
Автор

Could please explain Execute immediate "Alter session enable parallel dml" . Thanks in advance

pragasht