- Course
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.
Beginner
- Course
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.
Beginner
Get started today
Access this course and other top-rated tech content with one of our business plans.
Try this course for free
Access this course and other top-rated tech content with one of our individual plans.
This course is included in the libraries shown below:
- Data
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.
Oracle Developer Essentials: Views, Synonyms and Triggers
Beginner
Table of contents
David Berry is a software engineer with over 15 years of experience developing applications in languages such as Java and C#. Throughout his career, he has worked extensively with enterprise database systems including Oracle and SQL Server.