Operators in Oracle database

• EMP DEPT Tables Queries
• Set Operators in Oracle

DDL Commands (Data Definition Language)

• DDL commands
• CREATE command
• RENAME command
• DROP command
• TRUNCATE command
• ALTER command
• ALTER … ADD
• ALTER … RENAME
• ALTER … MODIFY
• ALTER … DROP

• Oracle add column with default value

Oracle Pre-defined Functions

• Number or Math functions in Oracle
  • ABS(), CEIL()
• Date functions in Oracle
  • SYSDATE, Trunc Oracle date
• Character or String functions in Oracle
• Conversion Functions
  • TO_CHAR()

Clauses used in SELECT statement,

• GROUP BY Clause
• Having Clause
• ORDER BY Clause

Oracle Constraints

• Constraints in Oracle
• Rename Constraint
• Disable Constraint
• Drop Constraint
• NOT NULL Constraint
• UNIQUE Constraint
• PRIMARY KEY Constraint
• FOREIGN KEY Constraint
• CHECK Constraint

Joins in Oracle database

• Joins in Oracle database
• INNER Join
• LEFT OUTER Join
• RIGHT OUTER Join
• FULL OUTER Join
• SELF Join
• CROSS Join