Oracle Sql Reference Card Page 3
ADVERTISEMENT
1
2
3
4
5Reserved Words
Built-in Functions
Common Clauses/Misc Cmds
ALTER / DROP COMMANDS
CREATE Commands
PCTFREE
MONTHS_BETWEEN
PRIOR
NCHR
PRIVILEGES
NEW_TIME
SQL STANDARDS
PUBLIC
NEXT_DAY
ANSI Standards
RAW
NLS_CHARSET_DECL_LEN
ISO Standards
SET OPERATORS
RENAME
UNION
NLS_CHARSET_ID
FIPS Compliance
RESOURCE
UNION ALL
NLS_CHARSET_NAME
UNICODE
REVOKE
INTERSECT
NLS_INITCAP
Oracle Standards Compliance
ROW
MINUS
NLS_LOWER
ROWID
NLSSORT
American National Standards Institute
ROWNUM
NLS_UPPER
11 West 42nd Street
ROWS
NTILE
New York, NY 10036 USA
SELECT
NULLIF
Telephone: (212) 642-4900
JOIN OPERATORS
SESSION
NUMTODSINTERVAL
(+) - OUTER JOIN
Fax: (212) 398-0023
SET
NUMTOYMINTERVAL
equijoins (=)
SHARE
INNER - inner join
NVL
RIGHT - right outer join.
SIZE
NVL2
International Organization for Standardization
LEFT - left outer join.
SMALLINT
PATH
1 Rue de Varembé
FULL - full or two-sided outer join
START
PERCENT_RANK
Case postale 56
OUTER - join keyword following
RIGHT, LEFT, or FULL
SUCCESSFUL
PERCENTILE_CONT
CH-1211, Geneva 20, Switzerland
SYNONYM
PERCENTILE_DISC
star joins
Telephone: +41 (22) 749-0111
SYSDATE
POWER
Fax: +41 (22) 733-3430
TABLE
RANK
THEN
RATIO_TO_REPORT
TO
RAWTOHEX
NIST / FIPS
TRIGGER
RAWTONHEX
UID
REF
FIPS Std 127-2:
UNION
REFTOHEX
fip127-2.htm
UNIQUE
REGR_ (Linear Regression) Functions
UPDATE
REPLACE
USER
ROUND (number)
UNICODE
VALIDATE
ROUND (date)
VALUES
Oracle9i complies fully with Unicode 3.0
ROW_NUMBER
VARCHAR
ROWIDTOCHAR
VARCHAR2
ROWIDTONCHAR
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Education