Oracle Sql Reference Card
ADVERTISEMENT
1
2
3
4
5C. Michael Eliasz,
ORACLE SQL REFERENCE CARD
Sr. Oracle Data Architect
Reserved Words
Built-in Functions
Common Clauses/Misc Cmds
ALTER / DROP COMMANDS
CREATE Commands
ACCESS
ABS
allocate_extent_clause
ALTER CLUSTER
CREATE CLUSTER
ADD
ACOS
constraints
ALTER DATABASE
CREATE CONTEXT
ALL
ADD_MONTHS
deallocate_unused_clause
ALTER DIMENSION
CREATE CONTROLFILE
ALTER
ASCII
file_specification
ALTER FUNCTION
CREATE DATABASE
AND
ASCIISTR
logging_clause
ALTER INDEX
CREATE DATABASE LINK
ANY
ASIN
parallel_clause
ALTER INDEXTYPE
CREATE DIMENSION
AS
ATAN
physical_attributes_clause
ALTER JAVA
CREATE DIRECTORY
ASC
ATAN2
storage_clause
ALTER MATERIALIZED VIEW
CREATE FUNCTION
AUDIT
AVG
CREATE INDEX
ALTER MATERIALIZED VIEW LOG
BETWEEN
BFILENAME
ALTER OPERATOR
CREATE INDEXTYPE
BY
BIN_TO_NUM
ALTER OUTLINE
CREATE JAVA
CHAR
BITAND
ALTER PACKAGE
CREATE LIBRARY
MISCELLANEOUS COMMANDS
CHECK
CAST
ANALYZE
ALTER PROCEDURE
CREATE MATERIALIZED VIEW
CLUSTER
CEIL
ASSOCIATE STATISTICS
ALTER PROFILE
CREATE MATERIALIZED VIEW LOG
COLUMN
CHARTOROWID
AUDIT
ALTER RESOURCE COST
CREATE OPERATOR
COMMENT
CHR
CALL
ALTER ROLE
CREATE OUTLINE
COMPRESS
COALESCE
COMMENT
ALTER ROLLBACK SEGMENT
CREATE PACKAGE
CONNECT
COMPOSE
COMMIT
ALTER SEQUENCE
CREATE PACKAGE BODY
CREATE
CONCAT
DELETE
ALTER SESSION
CREATE PFILE
CURRENT
CONVERT
DISASSOCIATE STATISTICS
ALTER SYSTEM
CREATE PROCEDURE
DATE
CORR
EXPLAIN PLAN
ALTER TABLE
CREATE PROFILE
DECIMAL
COS
GRANT
ALTER TABLESPACE
CREATE ROLE
DEFAULT
COSH
INSERT
ALTER TRIGGER
CREATE ROLLBACK SEGMENT
DELETE
COUNT
LOCK TABLE
ALTER TYPE
CREATE SCHEMA
DESC
COVAR_POP
MERGE
ALTER USER
CREATE SEQUENCE
DISTINCT
COVAR_SAMP
NOAUDIT
ALTER VIEW
CREATE SPFILE
DROP
CUME_DIST
RENAME
CREATE SYNONYM
ELSE
CURRENT_DATE
REVOKE
CREATE TABLE
EXCLUSIVE
CURRENT_TIMESTAMP
ROLLBACK
CREATE TABLESPACE
DROP COMMANDS
EXISTS
DBTIMEZONE
SAVEPOINT
DROP CLUSTER
CREATE TEMPORARY TABLESPACE
FILE
DECODE
SELECT
DROP CONTEXT
CREATE TRIGGER
FLOAT
DECOMPOSE
SET CONSTRAINT[S]
DROP DATABASE LINK
CREATE TYPE
FOR
DENSE_RANK
SET ROLE
DROP DIMENSION
CREATE TYPE BODY
FROM
DEPTH
SET TRANSACTION
DROP DIRECTORY
CREATE USER
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Education