Here’s definition of PL/SQL


• Procedural programming language
• Uses detailed instructions like a program
• Processes statements sequentially like a program in any programming language
• Combines SQL commands with procedural instructions (very Important)
• Used to perform sequential processing using an Oracle database (various objects)

PL/SQL Variables

• Variable names must follow the Oracle naming standard
• Make variable names descriptive
• Use lower-case letters, and separate words with underscores
• Example: current_s_id