Show Menu
Cheatography

Oracle SQL Cheat Sheet (DRAFT) by

This is a draft cheat sheet. It is a work in progress and is not finished yet.

SQL Facts

SQL stands for Structured Query Language
SQL is pronounced “sequel”
SQL is declar­ative language
SQL is used to access & manipulate data in databases
Top SQL DBs are MS SQL Server, Oracle, DB2, and MySQL

Types of SQL Statements

Data Definition Language (DDL)
Data Manipu­lation Language (DML)
Transa­ction Control Language (TCL)
Data Control Language (DCL)
CREATE
INSERT
COMMIT
GRANT
ALTER
UPDATE
ROLLBACK
REVOKE
DROP
DELETE
SAVEPOINT
TRUNCATE
MERGE
RENAME
  
                                   

Help Us Go Positive!

We offset our carbon usage with Ecologi. Click the link below to help us!

We offset our carbon footprint via Ecologi