udemy-the-complete-oracle-sql-bootcamp-2022-2022-4-2

Manipulation Language (DML) Statements\ 6:07 COMMIT and ROLLBACK Statements 20:08 Row Lock in Oracle 29:38 SAVEPOINT Statement 44:31 FOR UPDATE Statement \ 1:00:56 What is a Constraint Oracle Constraint Types 1:08:07 NOT NULL Constraint 1:15:13 UNIQUE Constraint 1:37:31 PRIMARY KEY Constraint 1:48:43 FOREIGN KEY Constraint (Part 1) 2:02:05 FOREIGN KEY Constraint (Part 2) 2:12:54 The ON DELETE CASCADE ON DELETE SET NULL Clause 2:21:36 CHECK Constraint 2:30:37 Adding Constraints via ALTER TABLE Statements 2:41:56 Dropping (Removing) Constraints 2:48:32 Cascading Constraints in Oracle 2:54:39 Renaming Constraints 2:58:09 Disabling Constraints 3:09:23 Enabling Constraints 3:15:23 Status of Constraints 3:25:03 Deferring Constraints (Part 1) 3:34:45 Deferring Constraints (Part 2) Views\ 3:44:22 What is a View and What is it Used for 3:49:13 View Types in Oracle 3:51:41 Creating Simple Views 4:03:41 Creating Complex Views 4:07:04 Modifying Views 4:11:22 Performing DML Operations with Views 4:20:39 Using the WITH CHECK OPTION Clause in SQL 4:29:01 Using the WITH READ ONLY Clause on Views 4:32:26 Dropping Views \ 4:38:11 Appendix 1 Oracle Database 12c Installation into Your Computer 4:47:09 Appendix 3 Configuring and Using Oracle SQL Developer for Oracle Database 12c \ 4:57:03 Conclusion