Oracle PL/SQL Syntax & Examples

Quick Search:


	CODE Oracle PL/SQL Code Library


	JOBS Find Or Post Oracle Jobs


	FORUM Oracle Discussion & Chat

Oracle PL/SQL Syntax & Examples [Return To Index]

Jump to:

Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

Type a few characters into the Search box to find Oracle and PL/SQL terms, functions, and keywords:

Or, click on a term in the list below:

(New terms are being added weekly)

ABS
ACCESS_INTO_NULL
ACOS
ADD_MONTHS
ALIAS
ALL
ALL_REPAUDIT_ATTRIBUTE
ALL_REPAUDIT_COLUMN
ALL_REPCAT
ALL_REPCATLOG
ALL_REPCAT_REFRESH_TEMPLATES
ALL_REPCAT_TEMPLATE_OBJECTS
ALL_REPCAT_TEMPLATE_PARMS
ALL_REPCAT_TEMPLATE_SITES
ALL_REPCAT_USER_AUTHORIZATIONS
ALL_REPCAT_USER_PARM_VALUES
ALL_REPCOLUMN
ALL_REPCOLUMN_GROUP
ALL_REPCONFLICT
ALL_REPDDL
ALL_REPFLAVORS
ALL_REPFLAVOR_COLUMNS
ALL_REPFLAVOR_OBJECTS
ALL_REPGENERATED
ALL_REPGENOBJECTS
ALL_REPGROUP
ALL_REPGROUPED_COLUMN
ALL_REPGROUP_PRIVILEGES
ALL_REPKEY_COLUMNS
ALL_REPOBJECT
ALL_REPPARAMETER_COLUMN
ALL_REPPRIORITY
ALL_REPPRIORITY_GROUP
ALL_REPPROP
ALL_REPRESOLUTION
ALL_REPRESOLUTION_METHOD
ALL_REPRESOLUTION_STATISTICS
ALL_REPRESOL_STATS_CONTROL
ALL_REPSCHEMA
ALL_REPSITES
ALTER
AND
ANY
ARRAY
AS
ASC
ASCII
ASCIISTR
ASIN
ATAN
ATAN2
AUTHID
AUTOEXTEND
AVG
BEGIN
BETWEEN
BFILENAME
BINARY_INTEGER
BIN_TO_NUM
BITAND
BODY
BOOLEAN
BULK
CALL_INTERFACE
CASE
CASE_NOT_FOUND
CAST
CEIL
CHAR
CHARTOROWID
CHAR_BASE
CHECK
CHR
CLOSE
CLUSTER
COALESCE
COLLECT
COLLECTION_IS_NULL
COLUMN
COMMENT
COMMIT
COMPOSE
COMPRESS
CONCAT
CONNECT
CONSTANT
CONSTRAINT
CONVERT
CORR
CORR_K
CORR_S
COS
COSH
COUNT
COVAR_POP
COVAR_SAMP
CREATE
CREATE_DATABASE_LINK
CREATE_INDEX
CREATE_TABLE
CREATE_VIEW
CUME_DIST
CURRENT
CURRENT_DATE
CURRENT_TIMESTAMP
CURRVAL
CURSOR
CURSOR_ALREADY_OPEN
DATATYPE
DAY_TO_SECOND
DBA_TAB_PRIVS
DBTIMEZONE
DEBUG_EXTPROC
DECLARE
DECODE
DECOMPOSE
DEFAULT
DELETE

DELETING
DISTINCT
DROP
DUAL
DUMP
DUP_VAL_ON_INDEX
ELSE
ELSIF
EMPTY_BLOB
EMPTY_CLOB
END
EXCEPTION
EXCLUSIVE
EXECUTE
EXECUTE_IMMEDIATE
EXISTS
EXISTSNODE
EXIT
EXP
EXPLAIN_PLAN
EXTEND
EXTRACT
EXTRACTVALUE
FALSE
FETCH
FIELD
FIRST
FIRST_VALUE
FLOAT
FLOOR
FOR
FORALL
FOREIGN_KEY
FROM
FROM_TZ
FUNCTION
GOTO
GRANT
GREATEST
GROUPING
GROUPING_ID
GROUP_BY
GROUP_ID
HAVING
HEAP
HEXTORAW
HOUR
IF
IN
INDEX
INITCAP
INSERT
INSERTING
INSTR
INTEGER
INTERSECT
INTERVAL
INTO
INVALID_CURSOR
INVALID_NUMBER
IS
ISOLATION
JOIN
LAG
LAST
LAST_DAY
LAST_VALUE
LEAD
LEAST
LENGTH
LEVEL
LIKE
LIMIT
LISTAGG
LN
LOCALTIMESTAMP
LOCK
LOG
LOGIN_DENIED
LONG
LOOP
LOWER
LPAD
LTRIM
MAKE_REF
MAX
MIN
MINUS
MINUTE
MLSLABEL
MOD
MODE
MONTH
MONTHS_BETWEEN
NATURAL
NATURALN
NCHR
NEW
NEW_TIME
NEXTVAL
NEXT_DAY
NLS_INITCAP
NLS_LANGUAGE
NLS_LOWER
NLS_SORT
NLS_UPPER
NOT_LOGGED_ON
NO_DATA_FOUND
NULL
NULLIF
NUMBER
NUMBER_BASE
NUMTODSINTERVAL
NUMTOYMINTERVAL
NVL
NVL2
OCIROWID
OF

ON
OPAQUE
OPEN
OPERATOR
OPTION
OR
ORDER
ORDER_BY
ORGANIZATION
OTHERS
OUT
PACKAGE
PARTITION
PATH
PCTFREE
PERCENTILE_CONT
PERCENTILE_DISC
PERCENT_RANK
PLS_INTEGER
POSITIVE
POSITIVEN
POWER
PRAGMA
PRIOR
PRIVATE
PRIVILEGE
PROCEDURE
PROGRAM_ERROR
PSEUDOCOLUMN
PUBLIC
QUOTA
RAISE
RANGE
RANK
RATIO_TO_REPORT
RAW
RAWTOHEX
RAWTONHEX
REAL
REBUILD
RECORD
REF
REFERENCES
REFTOHEX
REGR_AVGX
REGR_AVGY
REGR_COUNT
REGR_INTERCEPT
REGR_R2
REGR_SLOPE
REGR_SXX
REGR_SXY
REGR_SYY
RELEASE
REPLACE
RETURN
RETURNING
REVERSE
REVOKE
ROLE
ROLLBACK
ROUND
ROW
ROWID
ROWIDTOCHAR
ROWIDTONCHAR
ROWNUM
ROWTYPE
ROWTYPE_MISMATCH
RPAD
RTRIM
SAVEPOINT
SCHEMA
SDO_CS
SDO_GEOM
SDO_LRS
SDO_MIGRATE
SDO_TUNE
SDO_UTIL
SECOND
SELECT
SELF_IS_NULL
SEQUENCE
SESSIONTIMEZONE
SET
SHARE
SIGN
SIN
SINH
SMALLINT
SOUNDEX
SQL
SQLCODE
SQLERRM
SQRT
START_WITH
START_WITH_CONNECT_BY
STDDEV
STDDEV_POP
STDDEV_SAMP
STORAGE_ERROR
SUBSCRIPT_BEYOND_COUNT
SUBSCRIPT_OUTSIDE_LIMIT
SUBSTR
SUBTYPE
SUCCESSFUL
SUM
SYNONYM
SYSDATE
SYSTIMESTAMP
SYS_CONNECT_BY_PATH
SYS_CONTEXT
SYS_DBURIGEN
SYS_EXTRACT_UTC
SYS_GUID
SYS_INVALID_ROWID
SYS_REFCURSOR
SYS_TYPEID

SYS_XMLAGG
SYS_XMLGEN
TABLE
TABLESPACE
THEN
TIMEOUT_ON_RESOURCE
TIMESTAMP
TIMESTAMP_TO_SCN
TIMEZONE_ABBR
TIMEZONE_HOUR
TIMEZONE_MINUTE
TIMEZONE_REGION
TOO_MANY_ROWS
TO_CHAR
TO_CLOB
TO_DATE
TO_DSINTERVAL
TRANSLATE
TREAT
TRIGGER
TRIM
TRUE
TRUNC
TRUNCATE
TYPE
TZ_OFFSET
UID
UNDER_PATH
UNION
UNIQUE
UNISTR
UPDATE
UPDATEXML
UPDATING
UPPER
USER
USERENV
USER_REPAUDIT_ATTRIBUTE
USER_REPAUDIT_COLUMN
USER_REPCAT
USER_REPCATLOG
USER_REPCAT_REFRESH_TEMPLATES
USER_REPCAT_TEMPLATE_OBJECTS
USER_REPCAT_TEMPLATE_PARMS
USER_REPCAT_TEMPLATE_SITES
USER_REPCAT_USER_AUTHORIZATIONS
USER_REPCAT_USER_PARM_VALUES
USER_REPCOLUMN
USER_REPCOLUMN_GROUP
USER_REPCONFLICT
USER_REPDDL
USER_REPFLAVORS
USER_REPFLAVOR_COLUMNS
USER_REPFLAVOR_OBJECTS
USER_REPGENERATED
USER_REPGENOBJECTS
USER_REPGROUP
USER_REPGROUPED_COLUMN
USER_REPGROUP_PRIVILEGES
USER_REPKEY_COLUMNS
USER_REPOBJECT
USER_REPPARAMETER_COLUMN
USER_REPPRIORITY
USER_REPPRIORITY_GROUP
USER_REPPROP
USER_REPRESOLUTION
USER_REPRESOLUTION_METHOD
USER_REPRESOLUTION_STATISTICS
USER_REPRESOL_STATS_CONTROL
USER_REPSCHEMA
USER_REPSITES
USER_TAB_PRIVS
UTL_COLL
UTL_ENCODE
UTL_FILE
UTL_HTTP
UTL_INADDR
UTL_PG
UTL_RAW
UTL_REF
UTL_SMTP
UTL_TCP
UTL_URL
VALIDATE
VALUE
VALUES
VALUE_ERROR
VARCHAR
VARCHAR2
VARIANCE
VAR_POP
VAR_SAMP
VIEW
VSIZE
WHEN
WHENEVER
WHERE
WHILE
WIDTH_BUCKET
WITH
WM_CONCAT
WORK
XMLAGG
XMLCOLATTVAL
XMLCONCAT
XMLELEMENT
XMLFOREST
XMLSEQUENCE
XMLTRANSFORM
YEAR
YEAR_TO_MONTH
ZERO_DIVIDE

Home : Code Library : Sponsors : Privacy : Terms of Use : Contact Us

186 users online © 2009 psoug.org