Oracle SQL Reference - Cheat Sheet

[Pages:5]Reserved Words ACCESS ADD ALL ALTER AND ANY AS ASC AUDIT BETWEEN BY CHAR CHECK CLUSTER COLUMN COMMENT COMPRESS CONNECT CREATE CURRENT DATE DECIMAL DEFAULT DELETE DESC DISTINCT DROP ELSE EXCLUSIVE EXISTS FILE FLOAT FOR FROM

C. Michael Eliasz, Sr. Oracle Data Architect

ORACLE SQL REFERENCE CARD

Built-in Functions ABS

Common Clauses/Misc Cmds ALTER / DROP COMMANDS

allocate_extent_clause

ALTER CLUSTER

CREATE Commands CREATE CLUSTER

ACOS

constraints

ALTER DATABASE

CREATE CONTEXT

ADD_MONTHS

deallocate_unused_clause

ALTER DIMENSION

CREATE CONTROLFILE

ASCII

file_specification

ALTER FUNCTION

CREATE DATABASE

ASCIISTR

logging_clause

ALTER INDEX

CREATE DATABASE LINK

ASIN

parallel_clause

ALTER INDEXTYPE

CREATE DIMENSION

ATAN

physical_attributes_clause

ALTER JAVA

CREATE DIRECTORY

ATAN2

storage_clause

ALTER MATERIALIZED VIEW

CREATE FUNCTION

AVG

ALTER MATERIALIZED VIEW LOG

CREATE INDEX

BFILENAME

ALTER OPERATOR

CREATE INDEXTYPE

BIN_TO_NUM

ALTER OUTLINE

CREATE JAVA

BITAND

MISCELLANEOUS COMMANDS

ALTER PACKAGE

CREATE LIBRARY

CAST

ANALYZE

ALTER PROCEDURE

CREATE MATERIALIZED VIEW

CEIL

ASSOCIATE STATISTICS

ALTER PROFILE

CREATE MATERIALIZED VIEW LOG

CHARTOROWID

AUDIT

ALTER RESOURCE COST

CREATE OPERATOR

CHR

CALL

ALTER ROLE

CREATE OUTLINE

COALESCE

COMMENT

ALTER ROLLBACK SEGMENT

CREATE PACKAGE

COMPOSE

COMMIT

ALTER SEQUENCE

CREATE PACKAGE BODY

CONCAT

DELETE

ALTER SESSION

CREATE PFILE

CONVERT

DISASSOCIATE STATISTICS ALTER SYSTEM

CREATE PROCEDURE

CORR

EXPLAIN PLAN

ALTER TABLE

CREATE PROFILE

COS

GRANT

ALTER TABLESPACE

CREATE ROLE

COSH

INSERT

ALTER TRIGGER

CREATE ROLLBACK SEGMENT

COUNT

LOCK TABLE

ALTER TYPE

CREATE SCHEMA

COVAR_POP

MERGE

ALTER USER

CREATE SEQUENCE

COVAR_SAMP

NOAUDIT

ALTER VIEW

CREATE SPFILE

CUME_DIST

RENAME

CREATE SYNONYM

CURRENT_DATE

REVOKE

CREATE TABLE

CURRENT_TIMESTAMP ROLLBACK

DROP COMMANDS

CREATE TABLESPACE

DBTIMEZONE

SAVEPOINT

DROP CLUSTER

CREATE TEMPORARY TABLESPACE

DECODE

SELECT

DROP CONTEXT

CREATE TRIGGER

DECOMPOSE

SET CONSTRAINT[S]

DROP DATABASE LINK

CREATE TYPE

DENSE_RANK

SET ROLE

DROP DIMENSION

CREATE TYPE BODY

DEPTH

SET TRANSACTION

DROP DIRECTORY

CREATE USER

WWW.EM-GROUP-

Reserved Words GRANT GROUP HAVING IDENTIFIED IMMEDIATE IN INCREMENT INDEX INITIAL INSERT INTEGER INTERSECT INTO IS LEVEL LIKE LOCK LONG MAXEXTENTS MINUS MLSLABEL MODE MODIFY NOAUDIT NOCOMPRESS NOT NOWAIT NULL NUMBER OF OFFLINE ON ONLINE OPTION OR ORDER

Built-in Functions DEREF DUMP EMPTY_BLOB, _CLOB EXISTSNODE EXP EXTRACT (datetime) EXTRACT (XML) EXTRACTVALUE FIRST FIRST_VALUE FLOOR FROM_TZ GREATEST GROUP_ID GROUPING GROUPING_ID HEXTORAW INITCAP INSTR LAG LAST LAST_DAY LAST_VALUE LEAD LEAST LENGTH LN LOCALTIMESTAMP LOG LOWER LPAD LTRIM MAKE_REF MAX MIN MOD

Common Clauses/Misc Cmds TRUNCATE UPDATE

DML COMMANDS COMMIT DELETE INSERT MERGE ROLLBACK SAVEPOINT SELECT TRUNCATE UPDATE

DCL COMMANDS AUDIT GRANT NOAUDIT REVOKE

DDL COMMANDS see ALTER commands

ANALYZE ASSOCIATE STATISTICS COMMENT see CREATE commands DISASSOCIATE STATISTICS see DROP commands EXPLAIN PLAN

ALTER / DROP COMMANDS DROP FUNCTION DROP INDEX DROP INDEXTYPE DROP JAVA DROP LIBRARY DROP MATERIALIZED VIEW DROP MATERIALIZED VIEW LOG DROP OPERATOR DROP OUTLINE DROP PACKAGE DROP PROCEDURE DROP PROFILE DROP ROLE DROP ROLLBACK SEGMENT DROP SEQUENCE DROP SYNONYM DROP TABLE DROP TABLESPACE DROP TRIGGER DROP TYPE DROP TYPE BODY DROP USER DROP VIEW

DB OBJECTS (NON SCHEMA) Contexts Directories PFILES & SPFILES Profiles Roles Rollback segments Tablespaces Users

WWW.EM-GROUP-

CREATE Commands CREATE VIEW

PSUEDO COLUMNS CURRVAL and NEXTVAL LEVEL ROWID ROWNUM XMLDATA

DB OBJECTS (SCHEMA) Clusters Constraints Database links Database triggers Dimensions External procedure libraries Index-organized tables Indexes Indextypes Java classes, resources, source code Materialized views Materialized view logs Object tables Object types Object views Operators Packages Sequences Stored functions, stored procedures Synonyms Tables Views

Reserved Words PCTFREE PRIOR PRIVILEGES PUBLIC RAW RENAME RESOURCE REVOKE ROW ROWID ROWNUM ROWS SELECT SESSION SET SHARE SIZE SMALLINT START

SUCCESSFUL SYNONYM SYSDATE TABLE THEN TO TRIGGER UID UNION UNIQUE UPDATE USER VALIDATE VALUES VARCHAR VARCHAR2

Built-in Functions

Common Clauses/Misc Cmds

MONTHS_BETWEEN

NCHR

NEW_TIME

NEXT_DAY

NLS_CHARSET_DECL_LEN

NLS_CHARSET_ID

NLS_CHARSET_NAME

NLS_INITCAP

NLS_LOWER

NLSSORT

NLS_UPPER

NTILE

NULLIF

NUMTODSINTERVAL

NUMTOYMINTERVAL

NVL

NVL2

PATH

PERCENT_RANK

PERCENTILE_CONT PERCENTILE_DISC POWER RANK RATIO_TO_REPORT RAWTOHEX RAWTONHEX REF REFTOHEX REGR_ (Linear Regression) Functions REPLACE ROUND (number) ROUND (date) ROW_NUMBER ROWIDTOCHAR ROWIDTONCHAR

ALTER / DROP COMMANDS

SET OPERATORS UNION UNION ALL INTERSECT MINUS

JOIN OPERATORS (+) - OUTER JOIN

equijoins (=) INNER - inner join RIGHT - right outer join. LEFT - left outer join. FULL - full or two-sided outer join OUTER - join keyword following RIGHT, LEFT, or FULL

star joins

WWW.EM-GROUP-

CREATE Commands

SQL STANDARDS ANSI Standards ISO Standards FIPS Compliance UNICODE Oracle Standards Compliance

American National Standards Institute 11 West 42nd Street New York, NY 10036 USA Telephone: (212) 642-4900

Fax: (212) 398-0023

International Organization for Standardization

1 Rue de Varemb? Case postale 56

CH-1211, Geneva 20, Switzerland Telephone: +41 (22) 749-0111

Fax: +41 (22) 733-3430

NIST / FIPS FIPS Std 127-2:



UNICODE Oracle9i complies fully with Unicode 3.0

Reserved Words VIEW WHENEVER WHERE WITH

Built-in Functions RPAD

RTRIM

SESSIONTIMEZONE

SIGN

SIN SINH SOUNDEX SQRT STDDEV STDDEV_POP STDDEV_SAMP SUBSTR SUM

SYS_CONNECT_BY_PATH

SYS_CONTEXT SYS_DBURIGEN SYS_EXTRACT_UTC SYS_GUID SYS_TYPEID SYS_XMLAGG SYS_XMLGEN SYSDATE SYSTIMESTAMP TAN TANH TO_CHAR (character) TO_CHAR (datetime) TO_CHAR (number) TO_CLOB TO_DATE TO_DSINTERVAL TO_LOB TO_MULTI_BYTE TO_NCHAR (character) TO_NCHAR (datetime) TO_NCHAR (number) TO_NCLOB TO_NUMBER TO_SINGLE_BYTE TO_TIMESTAMP TO_TIMESTAMP_TZ TO_YMINTERVAL

Common Clauses/Misc Cmds

ALTER / DROP COMMANDS

WWW.EM-GROUP-

CREATE Commands

Reserved Words

Built-in Functions

Common Clauses/Misc Cmds

TRANSLATE

TRANSLATE ... USING

TREAT

TRIM

TRUNC (number)

TRUNC (date)

TZ_OFFSET

UID

UNISTR

UPDATEXML

UPPER

USER

USERENV

VALUE

VAR_POP

VAR_SAMP

VARIANCE VSIZE

WIDTH_BUCKET

XMLAGG

XMLCOLATTVAL XMLCONCAT

XMLELEMENT

XMLFOREST

XMLSEQUENCE XMLTRANSFORM

ROUND/TRUNC Date Functions

User-Defined Functions

ALTER / DROP COMMANDS

CREATE Commands

WWW.EM-GROUP-

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download