Base de connaissances Oracle

Liste alphabétique des mots clé

%

%ISOPEN
%FOUND
%NOTFOUND
%ROWCOUNT
%ROWTYPE
%TYPE

A (^)

ABS
ACCESS PARAMETERS (CREATE TABLE)
ACOS
ADD (ALTER TABLE)
ADD constraint (ALTER TABLE)
ADD_MONTHS
Administration Oracle    Article complet (Orafrance)
ADD OVERFLOW (ALTER TABLE)
ADD PARTITION (ALTER TABLE)
ADD VALUES (ALTER TABLE)
AFTER
ALTER DATABASE
ALL_TRIGGERS
ALLOCATE EXTENTS (ALTER TABLE)
ALTER_FUNCTION
ALTER PACKAGE
ALTER TABLE
ALTER TABLESPACE
ALTER TRIGGER
ANYTYPE, ANYDATA, ANYDATASET    Article complet (Laurent Dardenne)
ANYTYPE, ANYDATA, ANYDATASET (définition)
ANYDATASET (détail)
APPEND (DBMS_LOB)
ATAN
AUTONOMOUS_TRANSACTION

B (^)

BEFORE
BEGIN
BFILE
BINARY_INTEGER
BIN_TO_NUM
BITAND
BLOB
BODY
BOOLEAN
BROKEN (DBMS_JOB)
BUFFER_POOL (ALTER/CREATE TABLE)
BULK COLLECT

C (^)

CACHE (ALTER/CREATE TABLE)
CACHE BUFFER CHAIN    Article complet
CASCADE CONSTRAINTS (ALTER TABLE)
CASCADE DROP INDEX (ALTER TABLE)
CASCADE KEEP INDEX (ALTER TABLE)
CASE
CEIL
CHANGE (DBMS_JOB)
CHAR
CHARTOROWID
CHECKPOINT (ALTER TABLE)
CHECK_PRIVS (DBMS_JOB)
CHUNK (ALTER/CREATE TABLE)
CLOB
CLOSE
CLOSE (DBMS_LOB)
COALESCE (ALTER TABLE)
COALESCE PARTITION (ALTER TABLE)
COALESCE SUBPARTITION (ALTER TABLE)
COMPARE (DBMS_LOB)
COMPRESS (ALTER/CREATE TABLE)
CONVERTTOBLOB (DBMS_LOB)
CONVERTTOCLOB (DBMS_LOB)
COMMIT
CONCAT
Control Files    Article complet
CONSTANT
CONVERT
COPY (DBMS_LOB)
CORR (Fonctions analytiques)
COS
COSH
COUNT
COUNT (Fonctions analytiques)
.COUNT
CREATE FUNCTION
CREATE PACKAGE
CREATE PROCEDURE
CREATE TABLE
CREATE TABLESPACE
CREATE TRIGGER
CREATE VIEW
CREATETEMPORARY (DBMS_LOB)
CURSOR

D (^)

DATAFILE (ALTER TABLE)
DATE
DBMS_JOB    Article complet
DBMS_LOB Syntaxe et exemples
DBMS_OUTPUT Syntaxe et exemples
DEALLOCATE UNUSED (ALTER TABLE)
DECLARE
DECODE
DEFAULT
DELETE
.DELETE
DENSE_RANK (Fonctions analytiques)
DISABLE
DISABLE (DBMS_OUTPUT)
DISABLE ROW MOVEMENT (ALTER/CREATE TABLE)
DISABLE STORAGE IN ROW (ALTER/CREATE TABLE)
DISABLE [VALIDATE | NOVALIDATE] (ALTER/CREATE TABLE)
DROP COLUMN (ALTER TABLE)
DROP CONSTRAINT (ALTER TABLE)
DROP FUNCTION
DROP PACKAGE
DROP PARTITION (ALTER TABLE)
DROP PRIMARY KEY (ALTER TABLE)
DROP PROCEDURE
DROP SUBPARTITION (ALTER TABLE)
DROP TABLESPACE
DROP TRIGGER
DROP UNIQUE (ALTER TABLE)
DROP VALUES (ALTER TABLE)
DUMP

E (^)

ELEMENT IS OF TYPE (ALTER TABLE)
ELSE
ELSIF
EMPTY_BLOB
EMPTY_CLOB
ENABLE
ENABLE (DBMS_OUTPUT)
ENABLE [VALIDATE | NOVALIDATE] (ALTER/CREATE TABLE)
ENABLE ROW MOVEMENT (ALTER/CREATE TABLE)
ENABLE STORAGE IN ROW (ALTER/CREATE TABLE)
END
ERASE (DBMS_LOB)
EXCEPTION
EXCEPTION_INIT
EXCEPTIONS INTO (ALTER TABLE)
EXECUTE IMMEDIATE
Execute immediate    Article complet
EXCHANGE (SUB)PARTITION (ALTER TABLE)
.EXISTS
EXIT
EXP
EXPLAIN PLAN    Article complet
Export
.EXTEND
EXTRACT

F (^)

FCLOSE
FCLOSE_ALL
FETCH
FFLUSH
FGETATTR
FGETPOS
FILECLOSE (DBMS_LOB)
FILECLOSEALL (DBMS_LOB)
FILEEXISTS (DBMS_LOB)
FILEGETNAME (DBMS_LOB)
FILEISOPEN (DBMS_LOB)
FILEOPEN (DBMS_LOB)
FIRST (Fonctions analytiques)
FIRST_VALUE (Fonctions analytiques)
.FIRST
Flashback    Article complet
FLOOR
Fonctions analytiques    Article complet
FOPEN
FOPEN_NCHAR
FOR (boucle)
FOR (curseur)
FOR EACH ROW
FORALL
Forms    Article complet
FREELIST GROUPS (ALTER/CREATE TABLE)
FREEPOOLS (ALTER/CREATE TABLE)
FREETEMPORARY (DBMS_LOB)
FREMOVE
FRENAME
FSEEK

G (^)

GETCHUNKSIZE (DBMS_LOB)
GETLENGTH (DBMS_LOB)
GET_LINE (UTL_FILE)
GET_LINE (DBMS_OUTPUT)
GET_LINES (DBMS_OUTPUT)
GET_LINE_NCHAR
GET_RAW
GLOBAL PARTITION BY RANGE (ALTER/CREATE TABLE)
GLOBAL TEMPORARY (ALTER/CREATE TABLE)
GOTO
GREATEST

H (^)

HEXTORAW
High Water Mark (WHM)

I (^)

IF
Import
IN
INCLUDING (ALTER/CREATE TABLE)
INITIAL (ALTER/CREATE TABLE)
INITCAP
INITRANS
INSERT
Installations Oracle (Denisys)
Instance Oracle    Article complet
Instance Oracle (création)
INSTANCE (ALTER TABLE)
INSTANCE (DBMS_JOB)
INSTEAD OF
INSTR
INSTR (DBMS_LOB)
Intervalles
INTERVAL (DBMS_JOB)
INTERVAL DAY TO SECOND
INTERVAL YEAR TO MONTH
INVALIDATE (ALTER TABLE)
INVALIDATE GLOBAL INDEXES (ALTER TABLE)
IS_OPEN
ISOPEN (DBMS_LOB)
ISTEMPORARY (DBMS_LOB)
ISUBMIT (DBMS_JOB)

K (^)

KEEP (ALTER/CREATE TABLE)

L (^)

LAG, LEAD (Fonctions analytiques)
LAST (Fonctions analytiques)
.LAST
LAST_DAY
LAST_VALUE (Fonctions analytiques)
LATCH FREE    Article complet
LEAST
LENGTH
LIMIT
LN
LOADFROMFILE
LOADBLOBFROMFILE
LOADCLOBFROMFILE
LOBs    Article complet
LOCATION (ALTER/CREATE TABLE)
LOGGING clause (ALTER/CREATE TABLE)
Logminer    Article complet
LONG
LONG RAW
LOOP
LOWER
LPAD
LTRIM

M (^)

MAPPING TABLE (ALTER/CREATE TABLE)
MAX
MAX, MIN (Fonctions analytiques)
MAXEXTENTS (ALTER/CREATE TABLE)
MAXTRANS
MAXVALUE (ALTER/CREATE TABLE)
MERGE PARTITIONS (ALTER TABLE)
MERGE SUBPARTITIONS (ALTER TABLE)
MIN
MINEXTENTS (ALTER/CREATE TABLE)
MINIMIZE (ALTER TABLE)
MOD
MODIFY (ALTER TABLE)
MODIFY CONSTRAINT (ALTER TABLE)
MODIFY DEFAULT ATTRIBUTES (ALTER TABLE)
MODIFY LOB (ALTER TABLE)
MODIFY PARTITION (ALTER TABLE)
MODIFY PRIMARY KEY (ALTER TABLE)
MODIFY UNIQUE (ALTER TABLE)
MODIFY NESTED TABLE (ALTER TABLE)
MODIFY SUBPARTITION (ALTER TABLE)
MODIFY VARRAY (ALTER TABLE)
MONITORING (ALTER/CREATE TABLE)
MONTHS_BETWEEN
MOVE [ONLINE] (ALTER TABLE)
MOVE PARTITION (ALTER TABLE)
MOVE (subpartition) (ALTER TABLE)

N (^)

NCHAR
NCLOB
NESTED TABLE (ALTER/CREATE TABLE)
NEW_LINE (UTL_FILE)
NEW_LINE (DBMS_OUTPUT)
NEW_TIME
.NEXT
NEXT (ALTER/CREATE TABLE)
NEXT_DATE (DBMS_JOB)
NOCACHE (ALTER/CREATE TABLE)
NOCOMPRESS (ALTER/CREATE TABLE)
NOMAPPING (ALTER/CREATE TABLE)
NOMINIMIZE (ALTER TABLE)
NOMONITORING (ALTER/CREATE TABLE)
NOPARALLEL (ALTER/CREATE TABLE)
NOROWDEPENDENCIES (ALTER/CREATE TABLE)
NTILE (Fonctions analytiques)
NUMTODSINTERVAL
NUMTOYMINTERVAL
NVARCHAR2

O (^)

OBJECT TABLE (ALTER/CREATE TABLE)
OF object_type (ALTER/CREATE TABLE)
OID clause (ALTER/CREATE TABLE)
ON COMMIT [DELETE | PRESERVE ROWS]
OPEN
OPEN (DBMS_LOB)
OPEN FOR
OPTIMAL (ALTER/CREATE TABLE)
ORGANIZATION (ALTER/CREATE TABLE)
OTHERS
OVERFLOW (ALTER/CREATE TABLE)

P (^)

PARALLEL (ALTER/CREATE TABLE)
PARTITION BY HASH (ALTER/CREATE TABLE)
PARTITION BY LIST (ALTER/CREATE TABLE)
PARTITION BY RANGE (ALTER/CREATE TABLE)
Partition composite (ALTER/CREATE TABLE)
PCTINCREASE (ALTER/CREATE TABLE)
PCTUSED, PCTFREE
PCTTHRESHOLD (ALTER/CREATE TABLE)
PCTVERSION (ALTER/CREATE TABLE)
PERCENTILE_CONT, PERCENTILE_DISC (Fonctions analytiques)
PIPELINED
PL/SQL    Article complet
PLS_INTEGER
POWER
Profils Oracle    Article complet
Processus d'arrière plan (descrition)
Processus d'arrière plan (SMON)
Processus d'arrière plan (PMON)
Processus d'arrière plan (DBWn)
Processus d'arrière plan (LGWR)
Processus d'arrière plan (CKPT)
Processus d'arrière plan (ARCn)
PUT (UTL_FILE)
PUT (DBMS_OUTPUT)
PUT_NCHAR
PUT_RAW
PUTF
PUT_LINE (DBMS_OUTPUT)
PUT_LINE (UTL_FILE)
PUT_LINE_NCHAR (UTL_FILE)
PUTF
PUTF_NCHAR (UTL_FILE)

R (^)

RAISE
RANK (Fonctions analytiques)
RATIO_TO_REPORT (Fonctions analytiques)
RAW
ROWTOHEX
READ (DBMS_LOB)
REBUILD FREEPOOLS (ALTER TABLE)
REBUILD UNUSABLE LOCAL INDEX (ALTER TABLE)
RECYCLE (ALTER/CREATE TABLE)
REJECT LIMIT (ALTER/CREATE TABLE)
REMOVE (DBMS_JOB)
RENAME COLUMN (ALTER TABLE)
RENAME CONSTRAINT (ALTER TABLE)
RENAME (SUB)PARTITION (ALTER TABLE)
REPLACE
Restauration    Article complet (Jaouad)
RETENTION (ALTER/CREATE TABLE)
RETURN
RETURN AS (ALTER/CREATE TABLE)
RETURNING INTO
REVERSE
RMAN    Article complet (Gregory Broissard)
Rôles Oracle    Article complet
ROLLBACK
ROUND
ROWDEPENDENCIES (ALTER/CREATE TABLE)
ROWIDTOCHAR
ROW_NUMBER (Fonctions analytiques)
RPAD
RTRIM
RUN (DBMS_JOB)

S (^)

Sauvagearde    Article complet (Jaouad)
SAVEPOINT
SELECT INTO
SET SUBPARTITION TEMPLATE (ALTER TABLE)
SET UNUSED (ALTER TABLE)
SGA (description)
SGA (Shared Pool)
SGA (Library Cache)
SGA (Dictionary Cache)
SGA (Database Buffer Cache)
SGA (Program Global Area)
SGA (Redo Log Buffer)
SIGN
SIN
SINH
SIZE (ALTER TABLE)
SPLIT PARTITION (ALTER TABLE)
SPLIT SUBPARTITION (ALTER TABLE)
SQL dynamique natif    Article complet
SQLCODE
SQLERRM
Sql*Loader    Article complet (Jaouad)
SQRT
STDDEV (Fonctions analytiques)
STORE AS (XML) (ALTER/CREATE TABLE)
SUBMIT (DBMS_JOB)
SUBPARTITION BY HASH (ALTER/CREATE TABLE)
SUBPARTITION BY LIST (ALTER/CREATE TABLE)
SUBPARTITION TEMPLATE (ALTER/CREATE TABLE)
SUBSTITUTABLE (ALTER/CREATE TABLE)
SUBSTR
SUBSTR (DBMS_LOB)
SUBTYPE
SUM
SYS.ANYTYPE
SYS.ANYDATA
SYS.ANYDATASET
SYS_EXTRACT_UTC

T (^)

Table mutante (mutating table)    Article complet
Tables Oracle    Article complet
Tablespaces    Article complet
Tablespace (temporaire)
Tablespace (UNDO)
Tablespace (transportable)
Tablespace (locally managed)
TAN
TANH
THEN
TIMESTAMP
TO SAVEPOINT
TO_CHAR
TO_CLOB
TO_DATE
TO_DSINTERVAL
TO_MULTI_BYTE
TO_NUMBER
TO_SINGLE_BYTE
TO_TIMESTAMP
TO_YMINTERVAL
TKPROF    Article complet
TRANSLATE
TRIM
TRIM (DBMS_LOB)
TRUNC
TRUNCATE (SUB)PARTITION (ALTER TABLE)
TYPE access_driver_type (ALTER/CREATE TABLE)

U (^)

UPDATE
UPDATE BLOCK REFERENCES (ALTER TABLE)
UPDATE GLOBAL INDEXES (ALTER TABLE)
UPGRADE (ALTER TABLE)
UPPER
USER_EXPORT (DBMS_JOB)
USING
USING INDEX (ALTER/CREATE TABLE)
Utilisateur Oracle    Article complet
UTL_FILE Syntaxe et exemples

V (^)

VALUES LESS THAN (ALTER/CREATE TABLE)
VARCHAR2
VARIANCE (Fonctions analytiques)
VSIZE

W (^)

WHAT (DBMS_JOB)
WHEN
WHILE
WRITE (DBMS_LOB)
WRITEAPPEND (DBMS_LOB)

X (^)

XMLType_table (ALTER/CREATE TABLE)
XMLType (ALTER/CREATE TABLE)
XMLType storage (ALTER/CREATE TABLE)
XMLSchema (ALTER/CREATE TABLE)