Database Programming with PL/SQL 4-2: Conditional Control: Case Statements Practice Activities Vocabulary An expression that selects a result and re…

Database Programming with PL/SQL 4-1: Conditional Control: IF Statements Practice Activities Vocabulary Statement that enables PL/SQL to perform act…

Database Programming with PL/SQL 3-4: Using Transaction Control Statements Practice Activities Vocabulary An inseparable list of database operations…

Database Programming with PL/SQL 3-3: Manipulating Data in PL/SQL Practice Activities Vocabulary Defined automatically by Oracle for all SQL data ma…

Database Programming with PL/SQL 3-2: Retrieving Data in PL/SQL Practice Activities Try It / Solve It 1. State whether each of the following SQL sta…

Database Programming with PL/SQL 3-1: Review of SQL DML Practice Activities Vocabulary Statement used to remove existing rows in a table. -  DELETE …

Database Programming with PL/SQL 2-7: Good Programming Practices Practice Activities Try It / Solve It 1. Enter and run the following PL/SQL block. …

Database Programming with PL/SQL 2-6: Nested Blocks and Variable Scope Practice Activities Vocabulary A name given to a block of code which allows a…

Database Programming with PL/SQL 2-5: Writing PL/SQL Executable Statements Practice Activities Vocabulary Converts values from one data type to anot…

Database Programming with PL/SQL 2-4: Using Scalar Data Types Practice Activities Vocabulary A datatype that stores one of the three possible values…

Database Programming with PL/SQL  2-3: Recognizing Data Types  Practice Activities  Vocabulary Store large blocks of single-byte or fixed width mult…

Database Programming with PL/SQL  2-2: Recognizing PL/SQL Lexical Units  Practice Activities  Vocabulary An explicit numeric, character string, date…

Database Programming with PL/SQL 2-1: Using Variables in PL/SQL Practice Activities Vocabulary Used for storage of data and manipulation of stored v…

Database Programming with PL/SQL  1-3: Creating PL/SQL Blocks  Practice Activities  Vocabulary Unnamed blocks of code not stored in the database and…

Database Programming with PL/SQL  1-2: Benefits of PL/SQL  Practice Activities  Vocabulary The ability for PL/SQL programs to run anywhere an Oracle …

Database Programming with PL/SQL 1-1: Introduction to PL/SQL  Practice Activities  Vocabulary  Programming language features such as reusable/callab…