Fine Points

• Can have CASE statement in the WHERE clause
• All the DDL statements are auto commit.
• SELECT SYSTIMESTAMP FROM DUAL
• Triggers Cannot have ROLLBACK, COMMIT, SAVEPOINT and TRUNCATE.