Oracle Tutorial

• Oracle Tutorial
• 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 Minus

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
• SUBQUERY
• TRUNCATE
• WHERE
• Change Password
• Check Constraints
• Comments
• Primary Key

Interview Questions

• Oracle Interview
• SQL Interview
• PL/SQL Interview
• MongoDB Interview