Index des commandes SQL Oracle


COMMANDS

ABS

ADD_MONTHS

ALTER CLUSTER

ALTER DATABASE

ALTER FUNCTION

ALTER INDEX

ALTER PACKAGE

ALTER PROCEDURE

ALTER PROFILE

ALTER RESOURCE COST

ALTER ROLE

ALTER ROLLBACK SEGMENT

ALTER SEQUENCE

ALTER SESSION

ALTER SNAPSHOT

ALTER SNAPSHOT LOG

ALTER SYSTEM

ALTER TABLE

ALTER TABLESPACE

ALTER TRIGGER

ALTER USER

ALTER VIEW

ANALYZE

AND OPERATOR

ANSI, DB2, AND SQL/DS DATATYPES

ARCHIVE LOG

ARITHMETIC OPERATORS

ASCII

AUDIT (SQL Statements)

AUDIT (Schema Objects)

AVG

CEIL

CHAR DATATYPE

CHARACTER DATATYPES

CHARACTER OPERATORS

CHARTOROWID

CHR

COMMENT

COMMENTS (SQL)

COMMIT

COMPARISON OPERATORS

CONCAT

CONSTRAINT

CONVERT

COS

COSH

COUNT

CREATE CLUSTER

CREATE CONTROLFILE

CREATE DATABASE

CREATE DATABASE LINK

CREATE FUNCTION

CREATE INDEX

CREATE PACKAGE

CREATE PACKAGE BODY

CREATE PROCEDURE

CREATE PROFILE

CREATE ROLE

CREATE ROLLBACK SEGMENT

CREATE SCHEMA

CREATE SEQUENCE

CREATE SNAPSHOT

CREATE SNAPSHOT LOG

CREATE SYNONYM

CREATE TABLE

CREATE TABLESPACE

CREATE TRIGGER

CREATE USER

CREATE VIEW

CURRVAL AND NEXTVAL

Capitalization of Date Format Elements

Changing the Return Format

Character Functions

Character Functions Returning Character Values

Character Functions Returning Number Values

Condition

Conversion Functions

DATA CONVERSION

DATATYPE COMPARISON RULES

DATATYPES (ORACLE)

DATE DATATYPE

DATE FUNCTIONS

DEFAULT DATE FORMAT

DELETE

DISABLE

DROP

DROP CLUSTER

DROP DATABASE LINK

DROP FUNCTION

DROP INDEX

DROP PACKAGE

DROP PROCEDURE

DROP PROFILE

DROP ROLE

DROP ROLLBACK SEGMENT

DROP SEQUENCE

DROP SNAPSHOT

DROP SNAPSHOT LOG

DROP SYNONYM

DROP TABLE

DROP TABLESPACE

DROP TRIGGER

DROP USER

DROP VIEW

DUMP

Date Format Element Suffixes

Date Format Elements

Date Format Elements and National Language Support

Date Format Models

Decoded Expression

ENABLE

EXP

EXPLAIN PLAN

Expr

FLOOR

FM

FORMAT MODELS

FX

Filespec

Format Model Modifiers

GLB

GRANT (Object Privileges)

GRANT (System Privileges and Roles)

GREATEST

GREATEST_LB

GROUP FUNCTIONS

HEXTORAW

INITCAP

INSERT

INSTR

INSTRB

INTEGER

INTERSECT OPERATOR

ISO Standard Date Format Elements

LAST_DAY

LEAST

LEAST_UB

LENGTH

LENGTHB

LEVEL

LIKE OPERATOR

LIST OF EXPRESSIONS

LITERALS

LN

LOCK TABLE

LOG

LOGICAL OPERATORS

LONG DATATYPE

LOWER

LPAD

LTRIM

LUB

MAX

MIN

MINUS OPERATOR

MLSLABEL DATATYPE

MOD

MONTHS_BETWEEN

NEW_TIME

NEXT_DAY

NLSSORT

NLS_INITCAP

NLS_LOWER

NLS_UPPER

NOAUDIT (SQL Statements)

NOAUDIT (Schema Objects)

NOT IN OPERATOR

NOT OPERATOR

NULLS

NUMBER

NUMBER DATATYPE

NUMBER FUNCTIONS

NVL

Number Format Elements

Number Format Models

OPERATORS

OR OPERATOR

OTHER OPERATORS

Other Functions

POWER

PRECEDENCE

PSEUDOCOLUMNS

Punctuation and Text in Date Format Models

RAW AND LONG RAW DATATYPES

RAWTOHEX

RECOVER

RENAME

REPLACE

RESERVED WORDS (SQL)

REVOKE (Object Privileges)

REVOKE (System Privileges and Roles)

ROLLBACK

ROUND (DATE)

ROUND (NUMBER)

ROUND and TRUNC

ROWID

ROWID DATATYPE

ROWIDTOCHAR

ROWNUM

RPAD

RR Date Format Element

RTRIM

SAVEPOINT

SELECT

SET OPERATORS

SET ROLE

SET TRANSACTION

SIGN

SIN

SINGLE ROW FUNCTIONS

SINH

SOUNDEX

SQL FUNCTIONS

SQRT

STDDEV

STORAGE

SUBSTR

SUBSTRB

SUM

SYSDATE

Supplying the Correct Format

TAN

TANH

TEXT

TO_CHAR (date conversion)

TO_CHAR (label conversion)

TO_CHAR (number conversion)

TO_DATE

TO_LABEL

TO_MULTI_BYTE

TO_NUMBER

TO_SINGLE_BYTE

TRANSLATE

TRUNC (DATE)

TRUNC (NUMBER)

TRUNCATE

UID

UNION ALL OPERATOR

UNION OPERATOR

UPDATE

UPPER

USER

USERENV

VARCHAR DATATYPE

VARCHAR2 DATATYPE

VARIANCE

VSIZE