Controlling User Access Understanding the Concepts of Users,
Roles, and Privileges
Granting and Revoking Object Privileges
Creating Roles and Granting Privileges to Roles
Creating Synonyms for Ease of Table Access
SQL Workshop Applying Techniques Learned in
This Course
Preparing for Future Oracle Courses
Declaring Variables Recognizing the Basic PL/SQL Block
and Its Sections
Describing the Significance of Variables in PL/SQL
Distinguishing Between PL/SQL and Non-PL/SQL Variables
Declaring Variables and Constants
Executing a PL/SQL Block
Writing Executable Statements Recognizing the Significance of
the Executable Section
Writing Statements Within the Executable Section
Describing the Rules of Nested Blocks
Executing and Testing a PL/SQL Block
Using Coding Conventions
Interacting with the Oracle Server
Writing a Successful SELECT Statement
in PL/SQL
Declaring the Data type and Size of a PL/SQL Variable
Dynamically
Writing DML Statements in PL/SQL
Controlling Transactions in PL/SQL
Determining the Outcome of SQL DML Statements
Writing Control Structures Identifying the Uses and Types
of Control Structures
Constructing an IF Statement
Constructing and Identifying Different Loop Statements
Controlling Block Flow Using Nested Loops and Labels Using Logic Tables.
