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.

Search

Search

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 a key to solving the problems of information management.

SQL

• Char vs Varchar in SQL
• Varchar Vs Varchar2 in Oracle

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 the 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

---

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
• Oracle List Users
• Oracle Show Current User
• List Schemas in Oracle
• Oracle Change User Password

• EMP Table Script in SQL Server

Latest

• 2nd Last Record SQL in Oracle
• Oracle Purge Recyclebin
• Oracle Convert Varchar2 to Date
• Oracle Change Column Length Varchar2
• Oracle Drop Table If Exists And Create
• Drop All Tables Oracle
• Truncate AUD$ table in Oracle 12c
• Oracle Make Table Read Only
• Oracle Semi Join
• Ora-12899 Value Too Large For Column Oracle
• Copy Data From One Column To Another in Oracle
• Oracle Hide Column From User
• How To Copy Table Data To Another In Oracle
• NVL Function in Oracle
• Coalesce in Oracle
• GraphQL vs SQL

Subscribe to our newsletter and follow us on Facebook, Instagram, and Twitter to receive the latest tutorial and programs to improve your programming skills.