IdentifiantMot de passe
Mot de passe oublié ?Je m'inscris ! (gratuit)

Base de connaissances Oracle

Date de publication : Septembre 2004

Par Helyos (Page d'accueil)
 Orafrance (Page d'accueil)
 Pomalaix
 SheikYerbouti (Page d'accueil)
 

Index des mots clé Oracle





Liste alphabétique des mots clé

% A B C D E F G H I K L M N O P R S T U V W X
%

%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)
Administration Oracle    Article complet (Pomalaix)
ADD OVERFLOW (ALTER TABLE)
ADD PARTITION (ALTER TABLE)
ADD VALUES (ALTER TABLE)
AFTER
ALL_TRIGGERS
ALLOCATE EXTENTS (ALTER TABLE)
ALTER_FUNCTION
ALTER PACKAGE
ALTER SYSTEM SET
ALTER TABLE
ALTER TRIGGER
APPEND (DBMS_LOB)
SIN
AUTONOMOUS_TRANSACTION

B (^)

BEFORE
BEGIN
BFILE
BINARY_INTEGER
Bloc Oracle Définition
BLOB
BODY
BOOLEAN
BUFFER_POOL (ALTER/CREATE TABLE)
BULK COLLECT

C (^)

CACHE (ALTER/CREATE TABLE)
CASCADE CONSTRAINTS (ALTER TABLE)
CASCADE DROP INDEX (ALTER TABLE)
CASCADE KEEP INDEX (ALTER TABLE)
CASE
CEIL
CHAR
CHARTOROWID
CHECKPOINT (ALTER TABLE)
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
CONSTANT
CONVERT
COPY (DBMS_LOB)
COS
COSH
COUNT
.COUNT
CREATE FUNCTION
CREATE PACKAGE
CREATE PROCEDURE
CREATE TABLE
CREATE TRIGGER
CREATE VIEW
CREATETEMPORARY (DBMS_LOB)
CURSOR

D (^)

DATAFILE (ALTER TABLE)
DATE
DBMS_LOB Syntaxe et exemples
DBMS_OUTPUT Syntaxe et exemples
DEALLOCATE UNUSED (ALTER TABLE)
DECLARE
DECODE
DEFAULT
DELETE
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 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
.EXTEND
Extent Définition
EXTRACT

F (^)

FCLOSE
FCLOSE_ALL
FETCH
FFLUSH
FGETATTR
FGETPOS
Fichiers de contôle et de reprise Définition
FILECLOSE (DBMS_LOB)
FILECLOSEALL (DBMS_LOB)
FILEEXISTS (DBMS_LOB)
FILEGETNAME (DBMS_LOB)
FILEISOPEN (DBMS_LOB)
FILEOPEN (DBMS_LOB)
.FIRST
Flashback    Article complet
FLOOR
FOPEN
FOPEN_NCHAR
FOR (boucle)
FOR (curseur)
FOR EACH ROW
FORALL
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

I (^)

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

K (^)

KEEP (ALTER/CREATE TABLE)

L (^)

.LAST
LAST_DAY
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
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)
MONOTORING (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)
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)
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)
PIPELINED
PL/SQL    Article complet
PLS_INTEGER
POWER
Profils Oracle    Article complet
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
RAW
ROWTOHEX
READ (DBMS_LOB)
READ_LINE
REBUILD FREEPOOLS (ALTER TABLE)
REBUILD UNUSABLE LOCAL INDEX (ALTER TABLE)
RECYCLE (ALTER/CREATE TABLE)
REJECT LIMIT (ALTER/CREATE TABLE)
RENAME COLUMN (ALTER TABLE)
RENAME CONSTRAINT (ALTER TABLE)
RENAME (SUB)PARTITION (ALTER TABLE)
REPLACE
RETENTION (ALTER/CREATE TABLE)
RETURN
RETURN AS (ALTER/CREATE TABLE)
RETURNING INTO
REVERSE
Rôles Oracle    Article complet
ROLLBACK
ROUND
ROWDEPENDENCIES (ALTER/CREATE TABLE)
ROWIDTOCHAR
RPAD
RTRIM

S (^)

SAVEPOINT
Segments et structures de stockage Définition
Segment Définition
Segment d'annulation Définition
SELECT INTO
SET SUBPARTITION TEMPLATE (ALTER TABLE)
SET UNUSED (ALTER TABLE)
SIGN
SIN
SINH
SIZE (ALTER TABLE)
SPLIT PARTITION (ALTER TABLE)
SPLIT SUBPARTITION (ALTER TABLE)
SQL dynamique natif    Article complet
SQLCODE
SQLERRM
SQRT
STORE AS (XML) (ALTER/CREATE TABLE)
Structures logiques et physiques Définition
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

T (^)

Table mutante (mutating table)    Article complet
Tables Oracle    Article complet
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
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
USING
USING INDEX (ALTER/CREATE TABLE)
Utilisateur Oracle    Article complet
UTL_FILE Syntaxe et exemples

V (^)

VALUES LESS THAN (ALTER/CREATE TABLE)
VARCHAR2

W (^)

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)


Le guide Oracle par Orafrance, Helyos et SheikYerbouti