Oracle Developer Essentials: Views, Synonyms and Triggers
This course covers the essentials of creating and using views, synonyms, sequences, and triggers in your Oracle database.
What you'll learn
Oracle offers a variety of objects that can be used to complement the tables in your database. Views allow you to store a SQL query that defines a logical representation of data in one or more tables, allowing you to create a type of virtual table over your physical tables. Synonyms allow you to define an alternate name for almost any object in Oracle. Sequences help create unique integer values in a thread-safe manner. Triggers allow you to define a behavior when a DML statement is executed against one of your tables. Combined with the tables and indexes in your database, you will be well equipped to handle almost any situation that occurs in your database design.
Table of contents
- Overview 1m
- Where Triggers Are Used 3m
- Types of Triggers 1m
- Defining Triggers 5m
- Enabling and Disabling Triggers 1m
- Triggers and Transactions 1m
- Firing Order of Triggers 2m
- Demo: Updating Administrative Columns With a Trigger 6m
- Demo: Archiving Rows With a Trigger 4m
- Demo: Creating an Auto-Number With a Trigger 3m
- Compound Triggers 3m
- Demo: Compound Triggers 5m
- Summary 1m
About the author
David Berry is a software engineer with over 15 years of application development experience. He started developing software in Java 1.0 using an Oracle 7 backend. Making the switch to Microsoft .NET when it was released, he has worked with every version of .NET since. He has also worked with every version of Oracle since Oracle 7 and ever version of SQL Server since SQL Server 7. His experience spans a broad range of industries including semiconductors, financial services, insurance an gove... more