Senarai Kata Simpanan

Pengenalan

Sewaktu mengisi data dalam Oracle CASE, anda tidak boleh menggunakan kata simpanan sebagai nama entiti, atribut atau bagi sebarang nama objek dalam pangkalan data. Jika tidak anda akan menghadapi masalah ketika proses pembinaan sistem kerana penjanaan kod tidak dapat dilakukan. Kata kunci pula dalam bahasa SQL membawa makna tertentu bagi Oracle RDBMS. Walau bagaimanapun ia bukanlah kata simpanan dan boleh digunakan sebagai pencam. Pada masa hadapan kata kunci ini mungkin menjadi kata simpanan.

[Isi Kandungan]
Senarai Kata Simpanan

 ACCESS      ADD         ALL      ALTER      AND
 ANY         AS          ASC      AUDIT      BETWEEN
 BY          CHAR        CHECK    CLUSTER    COLUMN
 COMMENT     COMPRESS    CONNECT  CREATE     CURRENT
 DATE        DBA         DECIMAL  DEFAULT    DELETE
 DESC        DISTINCT    DROP     ELSE       EXCLUSIVE
 EXISTS      FILE        FLOAT    FOR        FROM
 GRANT       GRAPHIC     GROUP    HAVING     IDENTIFIED
 IF          IMMEDIATE   IN       INCREMENT  INDEX
 INITIAL     INSERT      INTEGER  INTERSECT  INTO
 IS          LEVEL       LIKE     LOCK       LONG
 MAXEXTENTS  MINUS       MODE     MODIFY     NOAUDIT
 NOCOMPRESS  NOT         NOWAIT   NULL       NUMBER
 OF          OFFLINE     ON       ONLINE     OPTION
 OR          ORDER       PCTFREE  PRIOR      PRIVILEGES
 PUBLIC      RAW         RENAME   RESOURCE   REVOKE
 ROW         ROWID       ROWNUM   ROWS       SELECT
 SESSION     SET         SHARE    SIZE       SMALLINT
 START       SUCCESSFUL  SYNONYM  SYSDATE    TABLE
 THEN        TO          TRIGGER  UID        UNION
 UNIQUE      UPDATE      USER     VALIDATE   VALUE
 VARCHAR     VARGRAPHIC  VIEW     WHENEVER   WHERE
 WITH

Senarai Kata Kunci

 ARCHIVELOG    AUTHORIZATION BACKUP      BEGIN      CACHE
 CHARACTER     CLOSE         COBOL       COMMIT     CONSTRAIN
 CONTENTS      CONTINUE      CONTROLFILE CRASH      CURSOR
 CYCLE         DATABASE      DATAFILE    DEC        DECLARE
 DISMOUNT      DOUBLE        END         ESCAPE     EVENTS
 EXEC          FETCH         FOREIGN     FORTRAN    FOUND
 GO            GOTO          INCLUDING   INDICATOR  INITRANS
 INT           KEY           LANGUAGE    LINK       LOGFILE
 MAXDATAFILES  MAXINSTANCES  MAXLOGFILES MAXTRANS   MAXVALUE
 MINEXTENTS    MINVALUE      MOUNT       MODULE     NEXT
 NOARCHIEVELOG NOCACHE       NOCYCLE     NOMAXVALUE NOMINVALUE
 NOORDER       NORMAL        NOSORT      NUMERIC    ONLY
 OPEN          PASCAL        PCTINCREASE PCTUSED    PLI
 PRECISION     PRIMARY       PROCEDURE   READ       REAL
 REFERENCES    RELEASE       RESETLOGS   REUSE      ROLLBACK
 SAVEPOINT     SCHEMA        SECTION     SEGMENT    SEQUENCE
 SHARED        SOME          SORT        SPECIFIED  SQL
 SQLCODE       SQLERROR      STATEMENT   STORAGE    SWITCH
 SYSTEM        TABLES        TABLESPACE  TEMPORARY  USING
 WRITE         WORK



Copyright © 1995-1999 Fz Sdc
nsr@melayu.com
http://www.melayu.com/nsr


1