Showing posts from 2020Show all
learn advanced pl sql PL/SQL 13-5: Managing Triggers

PL/SQL 13-5: Managing Triggers

Programmer December 01, 2020

Database Programming with PL/SQL 13-5: Managing Triggers Practice Activities Try It / Solve It 1. Query the data dictionary to display information a…

Read more
DDL and Database Triggers PL/SQL 13-4: Creating DDL and Database Event Triggers

PL/SQL 13-4: Creating DDL and Database Event Triggers

Programmer December 01, 2020

Database Programming with PL/SQL 13-4: Creating DDL and Database Event Triggers Practice Activities Vocabulary are fired by DDL statements: CREATE, …

Read more
dml triggers PL/SQL 13-3: Creating DML Triggers: Part II

PL/SQL 13-3: Creating DML Triggers: Part II

Programmer December 01, 2020

Database Programming with PL/SQL 13-3: Creating DML Triggers: Part II Practice Activities Vocabulary is a single trigger that can include actions fo…

Read more
dml triggers PL/SQL 13-2: Creating DML Triggers: Part I

PL/SQL 13-2: Creating DML Triggers: Part I

Programmer November 30, 2020

Database Programming with PL/SQL 13-2: Creating DML Triggers: Part I Practice Activities Vocabulary fires once for each row affected by the triggeri…

Read more
introduction to triggers PL/SQL 13-1: Introduction to Triggers

PL/SQL 13-1: Introduction to Triggers

Programmer November 30, 2020

Database Programming with PL/SQL 13-1: Introduction to Triggers Practice Activities Vocabulary Execute automatically whenever a particular event occ…

Read more
dynamic sql PL/SQL 12-2: Improving PL/SQL Performance

PL/SQL 12-2: Improving PL/SQL Performance

Programmer November 30, 2020

Database Programming with PL/SQL 12-2: Improving PL/SQL Performance Practice Activities Vocabulary passes arguments by reference rather than by valu…

Read more
dynamic sql PL/SQL 12-1: Using Dynamic SQL

PL/SQL 12-1: Using Dynamic SQL

Programmer November 30, 2020

Database Programming with PL/SQL 12-1: Using Dynamic SQL Practice Activities Vocabulary SQL statements that cannot be parsed at compile time, but mu…

Read more
invokers rights PL/SQL 9-6: Using Invoker’s Rights

PL/SQL 9-6: Using Invoker’s Rights

Programmer November 26, 2020

Database Programming with PL/SQL 9-6: Using Invoker’s Rights Practice Activities Vocabulary Routines are bound to the schema in which they reside. -…

Read more
learn advanced pl sql PL/SQL 9-5: Review of Object Privileges

PL/SQL 9-5: Review of Object Privileges

Programmer November 26, 2020

Database Programming with PL/SQL 9-5: Review of Object Privileges Practice Activities Vocabulary Allows the grantee to invoke and execute a PL/SQL s…

Read more
data dictionary PL/SQL 9-4: Managing Procedures and Functions

PL/SQL 9-4: Managing Procedures and Functions

Programmer November 25, 2020

Database Programming with PL/SQL 9-4: Managing Procedures and Functions Practice Activities Vocabulary The dictionary table that contains source code…

Read more
data dictionary PL/SQL 9-3: Review of the Data Dictionary

PL/SQL 9-3: Review of the Data Dictionary

Programmer November 24, 2020

Database Programming with PL/SQL 9-3: Review of the Data Dictionary Practice Activities Vocabulary Contain information about everything in the datab…

Read more
learn advanced pl sql PL/SQL 9-2: Using Functions in SQL Statements

PL/SQL 9-2: Using Functions in SQL Statements

Programmer November 24, 2020

Database Programming with PL/SQL 9-2: Using Functions in SQL Statements Practice Activities Vocabulary A function created by the PL/SQL programmer t…

Read more
creating functions PL/SQL 9-1: Creating Functions

PL/SQL 9-1: Creating Functions

Programmer November 24, 2020

Database Programming with PL/SQL 9-1: Creating Functions Practice Activities Vocabulary A named PL/SQL block that can accept optional IN parameters …

Read more
learn advanced pl sql PL/SQL 8-3: Passing Parameters

PL/SQL 8-3: Passing Parameters

Programmer November 23, 2020

Database Programming with PL/SQL 8-3: Passing Parameters Practice Activities Vocabulary Returns a value to the caller -  OUT Parameter Provides valu…

Read more
learn advanced pl sql PL/SQL 8-2: Using Parameters in Procedures

PL/SQL 8-2: Using Parameters in Procedures

Programmer November 23, 2020

Database Programming with PL/SQL 8-2: Using Parameters in Procedures Practice Activities Vocabulary Pass or communicate data between the caller and …

Read more
Creating procedures PL/SQL 8-1: Creating Procedures

PL/SQL 8-1: Creating Procedures

Programmer November 21, 2020

Database Programming with PL/SQL 8-1: Creating Procedures Practice Activities Vocabulary Named PL/SQL blocks that are compiled and stored in the dat…

Read more