Oracle Database - Know Program

➤ Computer Basic
➤ Software Quotes
➤ C Tutorial
➤ C Programs
➤ C Quiz
➤ C++ Programs
➤ Python Programs
➤ Java Tutorial
➤ Java Programs
➤ Java Quiz
➤ Oracle Database
➤ JDBC Tutorial
➤ Servlet Tutorial
➤ Eclipse IDE
➤ Design Pattern
➤ Hibernate
➤ Algorithm
➤ XML

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

SQL

Operators in Oracle database

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,

Oracle Constraints

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

Oracle UTL_FILE Package

Others

EMP Table Script in SQL Server

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