1. What is PL/SQL? How is it different from SQL*Plus?
PL/SQL is Oracle's extension to SQL incorporating Procedural Language. It allows the data manipulation and query statements of SQL to be included in logical program blocks and procedural units of code.
SQL*Plus is an Oracle Server tool that recognizes and executes SQL statements.
2. What is the basic Structure of the PL/SQL Block?
Every unit of PL/SQL comprises one or more blocks. These may be entirely separate or nested. The general structure of the block is:
HEADER: Used only for named blocks
DECLARE: Defines the PL/SQL Objects to be used in this block
BEGIN
/* start of executable actions */
EXCEPTION
/* Error Handlers; Defines what to do if an executable action produces exceptions or errors */
END;
3. What are some of the control statements in PL/SQL?
- IF Statement
- GOTO statement
- Basic Loops
- FOR Loops
- WHILE Loops
4. How do you process PL/SQL blocks in SQL*Plus?
- Define a block in the SQL buffer and then run the buffer
- Define a block as part of a SQL*Plus script and then run the file

5. While using PL/SQL in SQL*Plus, how can one print to screen?
Issue:
SQL> set serveroutput on;
then run your PL/SQL block
6. How do you show errors while compiling from SQL*Plus?
issue:
SQL> show errors
7. How do you issue create table from PL/SQL?
Starting with 8i, DDL statements e.g. CREATE, TRUNCATE and DROP can be called within PL/SQL by using EXECUTE IMMEDATE.
Example:
begin
EXECUTE IMMEDIATE 'CREATE TABLE SAMPLETABLE(ID NUMBER)';
end;