Working with sequences, indexes and synonyms- Oracle PL SQL Course - Lesson 15 | SQL courses

Duration: 15:36 min

Summary: The Oracle database contain many important objects that best be known by a PL/SQL Developer. This video explains and demonstrates how to work with sequences, indexes and synonyms. Sequences are objects employed to create numerical positive or negative sequences that can be used to generate values for columns that have primary keys. Indexes are objects that speed up the execution time of SQL statements such as the SELECT. Synonyms are objects that work like aliases to simplify the naming of object that is stored inside a schema. The video explain these objects and how examples of how to use then in basic usage scenarios.