PL/SQL INTERVIEW QUESTION & ANSWERS
|1.||What is PL/SQL?|
|PL/SQL is an acronym for Programming Language/SQL. Structured Query Language (SQL) is a scripting language. PL/SQL block can contain any number of SQL statements integrated with flow of control statements.|
|2.||What are the advantages of PL/SQL?|
|3.||What are the types of PL/SQL block?|
|4.||What are the structure of PL/SQL block?|
|5.||What is the difference between SQL vs SQL*PLUS?|
|SQL stands for Structured Query Language. SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems. This language is non procedural.
SQL *PLUS is an Oracle specific program, which accepts and executes SQL commands and PL/SQL blocks. SQL *PLUS allow us to manipulate SQL commands and PL/SQL blocks.