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

DDL Commands (Data Definition Language)

Oracle Pre-defined Functions

Clauses used in SELECT statement,

Joins in Oracle database

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

PL/SQL


Others


Recent Post in Oracle Database

Know Program

DROP Table in Oracle

The DROP command in the Oracle database is used to remove database objects (like the table, index, view e.t.c.) from the database. To drop a…
Know Program

Oracle RENAME Table Example

The RENAME command of the Oracle database is used for renaming the database objects like tables, constraints. To rename a table in the Oracle database…
Know Program

Oracle SQL Create Table Example

In Oracle SQL, the CREATE command is used to create database objects like table, view, synonym, index, and e.t.c. To create a new table in…
Know Program

Oracle FOREIGN KEY Constraint

In the Oracle database, FOREIGN KEY Constraint is used to establish the relationship between tables. Generally, foreign key values are based on referenced primary key…