SQL is a conventional database the language that is used to maintain, create and recover the relational database whereas PL/SQL, Procedural Language extension to SQL, it prolongs SQL and provides ...

So DDL statements are generally not included in PL/SQL blocks. DDL statements are those statements that we use to create things, like tables. And we use DDL statements to go in and alter existing ...

SQL - Structured Query Language is a domain-specific language used in programming and designed for managing data held in a relational database management system (RDBMS), or for stream processing in a ...

Well, if you happen to be using Sql Server you can do that sort of thing in T-Sql. In Oracle, you can also accomplish the same thing using pl/sql. Either way i'd do it in a stored ...