Oracle Syllabus

• What is Oracle
• Oracle Tables
• Create Table
• Create Table As
• Alter Table
• Drop Table
• Global Temp Tables
• Local Temp Tables
• Oracle Views
• Create View
• Oracle Query
• Oracle Queries
• Oracle Select
• Oracle Insert
• Oracle Insert All
• Oracle Update
• Oracle Delete
• Truncate Table
• Oracle Clauses
• Oracle DISTINCT
• Oracle FROM
• Oracle ORDER BY
• Oracle GROUP BY
• Oracle HAVING
• Oracle Operators
• Oracle Union
• Oracle Union All
• Oracle Intersect
• Oracle Joins
• Oracle Joins
• Inner Join
• Outer Join
• Equi Join
• Self Join
• Cross Join
• Anti Join
• Semi Join
• Oracle Advance
• Oracle Procedure
• Oracle Function
• Oracle Cursor
• Oracle Trigger
• Oracle BEFORE Trigger
• Oracle AFTER Trigger
• Oracle DROP Trigger
• Oracle DISABLE Trigger
• Oracle ENABLE Trigger
• Oracle Misc
• ALIASES
• AND
• AND & OR
• BETWEEN
• COMPARISON OPERATORS
• EXISTS
• IN
• INTERSECT
• IS NOT NULL
• IS NULL
• LIKE
• NOT
• OR
• PIVOT
• REGEXP_LIKE
• SUBQUERY
• TRUNCATE
• WHERE
• Change Password
• Check Constraints
• Comments
• Primary Key