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

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