Oracle Sql Reference Card Page 2
ADVERTISEMENT
1
2
3
4
5Reserved Words
Built-in Functions
Common Clauses/Misc Cmds
ALTER / DROP COMMANDS
CREATE Commands
GRANT
DEREF
TRUNCATE
DROP FUNCTION
CREATE VIEW
GROUP
DUMP
UPDATE
DROP INDEX
HAVING
EMPTY_BLOB, _CLOB
DROP INDEXTYPE
IDENTIFIED
EXISTSNODE
DROP JAVA
IMMEDIATE
EXP
DROP LIBRARY
DML COMMANDS
PSUEDO COLUMNS
IN
EXTRACT (datetime)
COMMIT
DROP MATERIALIZED VIEW
CURRVAL and NEXTVAL
INCREMENT
EXTRACT (XML)
DELETE
LEVEL
DROP MATERIALIZED VIEW LOG
INDEX
EXTRACTVALUE
INSERT
DROP OPERATOR
ROWID
INITIAL
FIRST
MERGE
DROP OUTLINE
ROWNUM
INSERT
FIRST_VALUE
ROLLBACK
DROP PACKAGE
XMLDATA
INTEGER
FLOOR
SAVEPOINT
DROP PROCEDURE
INTERSECT
FROM_TZ
SELECT
DROP PROFILE
INTO
GREATEST
TRUNCATE
DROP ROLE
DB OBJECTS (SCHEMA)
IS
GROUP_ID
UPDATE
DROP ROLLBACK SEGMENT
Clusters
LEVEL
GROUPING
DROP SEQUENCE
Constraints
LIKE
GROUPING_ID
DROP SYNONYM
Database links
LOCK
HEXTORAW
DROP TABLE
Database triggers
DCL COMMANDS
LONG
INITCAP
AUDIT
DROP TABLESPACE
Dimensions
MAXEXTENTS
INSTR
GRANT
DROP TRIGGER
External procedure libraries
MINUS
LAG
NOAUDIT
DROP TYPE
Index-organized tables
MLSLABEL
LAST
REVOKE
DROP TYPE BODY
Indexes
MODE
LAST_DAY
DROP USER
Indextypes
MODIFY
LAST_VALUE
DROP VIEW
Java classes, resources, source code
NOAUDIT
LEAD
Materialized views
DDL COMMANDS
NOCOMPRESS
LEAST
see ALTER commands
Materialized view logs
NOT
LENGTH
ANALYZE
Object tables
DB OBJECTS (NON SCHEMA)
NOWAIT
LN
ASSOCIATE STATISTICS
Contexts
Object types
NULL
LOCALTIMESTAMP
COMMENT
Directories
Object views
NUMBER
LOG
see CREATE commands
PFILES & SPFILES
Operators
OF
LOWER
DISASSOCIATE STATISTICS
Profiles
Packages
OFFLINE
LPAD
see DROP commands
Roles
Sequences
ON
LTRIM
EXPLAIN PLAN
Rollback segments
Stored functions, stored procedures
ONLINE
MAKE_REF
Tablespaces
Synonyms
OPTION
MAX
Users
Tables
OR
MIN
Views
ORDER
MOD
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Education