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

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…

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…

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…

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…