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 moreDatabase Programming with PL/SQL 13-4: Creating DDL and Database Event Triggers Practice Activities Vocabulary are fired by DDL statements: CREATE, …
Read moreDatabase Programming with PL/SQL 13-3: Creating DML Triggers: Part II Practice Activities Vocabulary is a single trigger that can include actions fo…
Read moreDatabase Programming with PL/SQL 13-2: Creating DML Triggers: Part I Practice Activities Vocabulary fires once for each row affected by the triggeri…
Read moreDatabase Programming with PL/SQL 13-1: Introduction to Triggers Practice Activities Vocabulary Execute automatically whenever a particular event occ…
Read moreDatabase Programming with PL/SQL 12-2: Improving PL/SQL Performance Practice Activities Vocabulary passes arguments by reference rather than by valu…
Read moreDatabase Programming with PL/SQL 12-1: Using Dynamic SQL Practice Activities Vocabulary SQL statements that cannot be parsed at compile time, but mu…
Read moreDatabase Programming with PL/SQL 9-6: Using Invoker’s Rights Practice Activities Vocabulary Routines are bound to the schema in which they reside. -…
Read moreDatabase 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 moreDatabase Programming with PL/SQL 9-4: Managing Procedures and Functions Practice Activities Vocabulary The dictionary table that contains source code…
Read more