Duration: 20:08 min
Summary: The constraints are the recommend objects to guarantee the integrity inside the tables of an Oracle database and also to implement basic business rules that affect the data in order to make sure that no data, domain and referential integrity problems happen. This video explains the 5 basic constraints types that can be used on tables: NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY and CHECK constraints. The examples demonstrate how to use then, their limitations, and the scenario that each constraint can be used. Also, the video show how alter, remove, rename, disable and enable existing constraint by accessing them with their names.