Oracle Database

Oracle Database (commonly referred to as Oracle DBMS or simply as Oracle) is a multi-model database management system produced and marketed by Oracle Corporation.

An Oracle database is a collection of data treated as a unit. The purpose of a database is to store and retrieve related information. A database server is the key to solving the problems of information management.

SQL

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

PL/SQL

• PL/SQL Introduction
• PL/SQL Variable
• IF Statement in PL/SQL

• Oracle UTL_FILE Package 

Others

• How to unlock Scott user in SQL Plus
• How to Find SID in Oracle database
• Check Oracle Database Version
• Check Database Size in Oracle
• Error ORA 01031 insufficient privileges

Recent Post in Oracle Database