










       EW1    W0


         W1                W0





                   !=  ࠢ 4-3
                   $  ᫮ ଠ 4-36
                   % ᨬ
                      ᮯ⠢  ࠧ 4-9 - 4-10
                   (+)   譥 ꥤ 4-8,6-14
                   *  4-8,5-129
                   */  4-2
                   +-  4-2
                   24 ᮢ ଠ 3-15
                    ࠢ 4-3
                   <=  ࠢ 4-3
                   <>  ࠢ 4-3
                   >=  ࠢ 4-3
                   !!  4-2
                   ^=  ࠢ 4-3
                   _ ᨬ
                      ᮯ⠢  ࠧ 4-9 - 4-10


E                   A                   F

                   A.D.  ଠ   4-36
                   A..  ଠ   4-37
                   ABS
                       ᫮ 㭪 4-12
                   AD  ଠ   4-36
                   ADD 
                        ALTER TABLE 5-18
                   ADD_MONTHS
                       㭪  ࠡ  ⠬ 4-26
                   ALL [PRIVILEGES] - 
                        GRANT 5-104
                        REVOKE 5-121
                   ALL -  ࠢ
                       । 4-3
                       ਬ 4-3
                   ALL - 
                        AUDIT 5-22,5-24
                       㯯 㭪権 4-20
                        NOAUDIT 5-113,5-144
                        SELECT 4-8,5-128 - 5-129

                                   -- 316 --



                   ALTER CLUSTER - 
                       । 5-7 - 5-8
                       ⪮ ᠭ 5-2
                       ᨭ⠪ 5-7,-2

               ࠢ筮 㪮⢮   SQL     2



                   ALTER DATABASE - 
                       । 5-9 - 5-11
                       ⪮ ᠭ 5-2
                       ᨭ⠪ 5-9,-2
                   ALTER INDEX - 
                       । 5-12
                       ⪮ ᠭ 5-2
                       ᨭ⠪ 5-12,-2
                   ALTER - ਢ  ꥪ 5-105
                   ALTER ROLLBACK SEGMENT - 
                       । 5-13
                       ⪮ ᠭ 5-2
                       ᨭ⠪ 5-13,-2
                   ALTER SEQUENCE - 
                       । 5-14 - 5-15
                       ਬ 5-15
                       ⪮ ᠭ 5-2
                       ᨭ⠪ 5-14,-2
                   ALTER SESSION - 
                       । 5-16
                       ⪮ ᠭ 5-2
                       ᨭ⠪ 5-16,-2
                   ALTER TABLE - 
                       ᯥ䨪 ⨯  3-9
                       । 5-17 - 5-18
                       䨪 ⮫殢 1-5
                       ⪮ ᠭ 5-2
                       ᨭ⠪ 5-17,-2
                   ALTER TABLESPACE - 
                       । 5-19 - 5-20
                       ਬ  5-20
                       ⪮ ᠭ 5-3
                       ᨭ⠪ 5-19,-3
                   ALTER USER - 
                       । 5-21
                       ਬ  5-21
                       ⪮ ᠭ 5-3
                       ᨭ⠪ 5-21,-3
                   AM  ଠ   4-37
                   AND -   ᫮ 4-42
                   AND - ᪠ 
                       । 4-5
                        ࠧ WHERE 6-6
                       ⠡ ⨭ 4-5
                   ANSI
                       ਪ᪨ 樮  ⠭-
                       ⮢ 1-14,2-2
                         " 롮ન" 5-110
                   ANY -  ࠢ

                                   -- 317 --



                       । 4-3
                       ਬ 4-3
                   ARCHIVELOG -   CREATE DATABASE 5-49

               ࠢ筮 㪮⢮   SQL     3



                   AS - ࠧ
                        CREATE TABLE 5-67
                        CREATE VIEW 5-74
                   ASC - 
                         CREATE INDEX 5-52
                        ࠧ ORDER BY 6-11
                   ASCII 1-1
                        3-9
                       ᫥⥫쭮 ஢ 3-20 - 3-21
                       ᨬ쭠 㭪 4-19
                       㭪 4-19
                   AT - ࠧ
                       . ⠪ " CREATE DATABASE"
                       । 2-6
                         SELECT ஥ SQL 5-133
                         UPDATE ஥ SQL 5-142
                         FETCH 5-131
                   AUDIT - 
                       롮ઠ १⮢    5-22
                        䥪   5-113
                       ⢮ ॣ㥬 ᮡ⨩ 5-25
                       ⪮ ᠭ 5-3
                       ॣ 㯠  ࠬ 5-76
                       । 5-22 - 5-25
                       ਬ 5-23,5-25
                       ᨭ⠪ 5-22,5-24,-3
                   AVG - 㯯 㭪 4-20


E                   B                   F

                   B -  ᫮ ଠ 4-36
                   .. -  ଠ   4-36
                   Backup (१ࢭ ஢)  ⠡ 5-17
                    -  ଠ   4-36
                   BETWEEN -  ࠢ
                       । 4-4
                        ᫮ 4-43
                   BY ACCESS -  ॣ樨 㯠 5-24
                   BY SESSION -  ॣ樨 㯠 5-24


E                   C                   F

                   CACHE -   CREATE SEQUENCE 5-59,5-61
                   CATALOG -  ᫮ 
                        COMMENT 5-28
                    -  ଠ   4-36
                   CEIL - ᫮ 㭪 4-12
                   Char

                                   -- 318 --



                        ଠ 4-34
                       ࠧ 4-9
                       ࠢ ࠢ 3-20
                       ⨯  3-23
                   CHAR -  3-23

               ࠢ筮 㪮⢮   SQL     4



                   CHAR - ⨯  3-10,3-17
                       ᨬ쭮 ᫮ ᨬ 3-10
                       ᠭ 3-9
                   CHARACTER - ⨯  3-23
                   CHARTOROWID - 㭪 ८ࠧ 4-23
                   CHECK
                       ࠭祭  ⮫ 5-35
                       ࠭祭, ਬ 5-40
                         CREATE VIEW 5-74
                   CHR - ᨬ쭠 㭪 4-14
                   CLOSE cursor - 
                       ⪮ ᠭ 5-3
                       । 5-26
                       ਬ 5-26
                       ᨭ⠪  ஥ SQL 5-26,B-3
                   CLUSTER - ࠧ  CREATE TABLE 5-42
                   CLUSTER -   CREATE INDEX 5-52
                   COL -  ᫮ 
                        COMMENT 5-28
                   COLUMNS -  ᫮ 
                        COMMENT 5-28
                   COMMENT -  5-28
                       ⪮ ᠭ 5-3
                       । 5-28
                       ᨭ⠪ 5-28,-3
                   COMMENTS - ⮫
                         ᫮  5-28
                   COMMIT - 
                       襭 ࠭樨 5-123,5-127,5-136
                       ⪮ ᠭ 5-3
                       । 5-29 - 5-31
                       ᢮ ஢ 5-131, 5-140
                       ਬ 5-30 - 5-31
                       १ ࠡ 5-29
                       ᨭ⠪ 5-29,-3
                       ᨭ⠪  ஥ SQL 5-31,B-3
                   CONNECT BY 1-2
                   CONNECT BY - ࠧ   CREATE DATABASE
                          LINK 5-51
                         SELECT 5-129 - 5-130,6-9
                        ⨯ LONG 3-16
                       ࠭祭  㤠 ⠡ 6-21
                       । 6-9
                   CONNECT   GRANT 5-101
                   CONNECT - ਢ   REVOKE 5-119
                   CONNECT - 
                       ⪮ ᠭ 5-3
                       ⢥ 5-32

                                   -- 319 --



                       אַ 祭 5-34
                       । 5-32 - 5-34
                       ਬ 5-34
                       אַ 祭 5-33
                       ᨭ⠪  ஥ SQL 5-32,B-4
                       ࠧ AT 5-133
                   CONTINUE - ⢨   WHENEVER 5-146

               ࠢ筮 㪮⢮   SQL     5


                   CONVERT - 㭪  ।⢥ প 樮-
                              몮 2-4
                   COUNT -  4-8
                   COUNT - 㯯 㭪 4-21
                   CREATE CLUSTER - 
                       ⪮ ᠭ 5-3
                       । 5-42 - 5-46
                       ਬ 5-46
                       ᨭ⠪ 5-42,-4
                       ᯥ䨪 ⨯  3-9
                   CREATE DATABASE LINK - 
                       ⪮ ᠭ 5-3
                       । 5-50 - 5-51
                       ਬ 5-51
                       ᨭ⠪ 5-50,-4
                   CREATE DATABASE - 
                       ⪮ ᠭ 5-3
                       । 5-47 - 5-49
                       ਬ 5-49
                       ᨭ⠪ 5-47,-4
                   CREATE INDEX - 
                       ⪮ ᠭ 5-3
                       । 5-52 - 5-56
                       ਬ 5-56
                       ᨭ⠪ 5-52,-4
                   CREATE ROLLBACK SEGMENT - 
                       ⪮ ᠭ 5-3
                       । 5-57
                       ਬ 5-57
                       ᨭ⠪ 5-57,-4
                   CREATE SEQUENCE - 
                       ⪮ ᠭ 5-3
                       । 5-58 - 5-63
                       ਬ 5-62
                       ᨭ⠪ 5-58,-5
                   CREATE SYNONYM - 
                       ⪮ ᠭ 5-3
                       । 5-64 - 5-65
                       ਬ 5-65
                       ᨭ⠪ 5-64,-5
                   CREATE TABLE - 
                       ⪮ ᠭ 5-3
                       । 5-66 - 5-71
                       ਬ 5-65
                       ᨭ⠪ 5-64,-5
                       ᯥ䨪 ⨯  3-9
                   CREATE TABLESPACE - 

                                   -- 320 --



                       ⪮ ᠭ 5-3
                       । 5-72 - 5-73
                       ਬ 5-73
                       ᨭ⠪ 5-72,-5
                   CREATE VIEW - 
                       ⪮ ᠭ 5-3
                        -5
                       । 5-74 - 5-77
                       ਬ 5-76
                       ᨭ⠪ 5-74

               ࠢ筮 㪮⢮   SQL     6


                   CURRENT OF - ࠧ
                        ࠧ WHERE 6-7 - 6-8
                        ࠧ WHERE  UPDATE 5-143
                       ᯮ짮   DELETE 5-82
                   CURRVAL
                       㬥  樨 ᫥⥫쭮⥩ 5-62
                       ᯮ짮  ࠦ 4-40
                       ᯮ짮     NEXTVAL 5-63
                       ࠭祭  ᯮ짮 5-62
                       ᥢ⮫ 3-26
                   CYCLE -    CREATE SEQUENCE 5-59


E                   D                   F

                   D  ଠ   4-37
                   DDL ( ᠭ ) 5-2
                   DML ( 㫨஢ 묨) 5-2
                   DATAFILE
                         CREATE TABLESPACE 5-72
                         CREATE DATABASE 5-48
                   DATE - ⨯  3-15
                       ᪠ 3-16
                   DATE -  ᫮ ଠ 4-36
                   DAY -  ଠ  4-37
                   DB2
                        SQL 2-2
                       ⨯  3-17
                   DBA 1-3
                        ਢ 5-102
                   DBA - ਢ  
                         GRANT 5-101
                         REVOKE 5-119
                         AUDIT 5-22
                   DBlink . " "
                   dbname 2-6
                   DD -  ଠ  4-37
                   DDD -  ଠ  4-37
                   DECIMAL - ⨯  3-17
                   DECLARE cursor - 
                       ᯮ짮   ஬ SELECT 5-134
                       ⪮ ᠭ 5-4
                       । 5-78
                       ।⢮  FETCH 5-98

                                   -- 321 --



                       ᨭ⠪  ஥ SQL 5-78,B-5
                   DECLARE DATABASE - 
                       ⪮ ᠭ 5-4
                       । 5-79
                       ᨭ⠪  ஥ SQL 5-79,B-5
                   DECLARE STATEMENT - 
                        ॡ 5-80
                       ⥪ 5-80
                       ⪮ ᠭ 5-4
                       । 5-80
                       ਬ 5-80
                       ᨭ⠪  ஥ SQL 5-80,B-5

               ࠢ筮 㪮⢮   SQL     7


                   DECODE - 㭪 4-30
                   DEFAULT 1-3
                         5-56
                       ⮫  ࠭祭 REFERENCE 5-39
                       ⠡筮 ࠭⢮ 5-73
                       ⠡筮 ࠭⢮  ᥣ⮢ ⪠ 5-57
                       㬮砭  ᫥⥫쭮⥩ 5-60
                       㬮砭  ⠡ ࠭ 5-72
                       ࠧ  ᠭ ⮫ 5-27
                   DEFAULT - 
                        AUDIT 5-24
                        NOAUDIT 5-114
                   DEFAULT STORAGE - ࠧ
                        CREATE TABLESPACE 5-72
                   DELETE - ਢ ꥪ 5-105
                   DELETE - 
                       ᯮ짮   5-75
                       ⪮ ᠭ 5-4
                       । 5-81 - 5-83
                       ਬ 5-81
                       ਬ  ஥ SQL 5-83
                       ᨭ⠪ 5-81 - 5-82,-5 - -6
                       ᨭ⠪  ஥ SQL 5-82,B-6
                   DESC - 
                         CREATE INDEX 5-52
                        ࠧ ORDER BY 6-11
                   DESCRIBE - 
                       ᯮ짮  ஬ PREPARE 5-84
                       ⪮ ᠭ 5-4
                       ᠭ 5-84
                       ਬ 5-84
                       ᨭ⠪  ஥ SQL 5-84,B-6
                   DICTIONARY -    -2
                   DISTINCT - ࠧ
                        CREATE VIEW 5-76
                        ࠧ ORDER BY 6-12
                   DISTINCT -  4-8
                   DISTINCT - 
                        㯯 㭪 4-20
                         SELECT 5-128 - 5-129
                        SELECT 5-131
                   DROP CLUSTER - 

                                   -- 322 --



                       । 5-85
                       ਬ 5-85
                       ᨭ⠪ 5-85,-6
                   DROP DATABASE LINK - 
                       । 5-86
                       ਬ 5-86
                       ᨭ⠪ 5-86,-6
                   DROP INDEX - 
                       । 5-87
                       ਬ 5-87
                       ᨭ⠪ 5-87,-6
                   DROP ROLLBACK SEGMENT - 
                       । 5-88
                       ਬ 5-88
                       ᨭ⠪ 5-88,-6

               ࠢ筮 㪮⢮   SQL     8


                   DROP SEQUENCE - 
                       । 5-89
                       ਬ 5-89
                       ᨭ⠪ 5-89,-6
                   DROP -  5-4
                   DROP SYNONYM - 
                       । 5-90
                       ਬ 5-90
                       ᨭ⠪5-90,-6
                   DROP TABLE - 
                       । 5-91
                       ਬ 5-91
                       ᨭ⠪ 5-91,-6
                   DROP TABLESPACE - 
                       । 5-92
                       ਬ 5-92
                       ᨭ⠪ 5-92,-6
                   DROP VIEW - 
                       ⢨⥫   ᨭ 5-93
                       ਬ 5-93
                       ਬ 5-93
                       ᨭ⠪ 5-93,-6
                   DUAL - ⠡, । -7
                   DUMMY - ⮫ ⠡ DUAL F-7
                   DUMP - 㭪 4-30
                   DY -  ଠ  4-37

E                   E                   F

                   E -  ଠ   4-36
                   EBCDIC - ᫥⥫쭮 ஢ 3-22
                        3-9
                   EMB - . "஥ SQL"
                   ENTRYID
                        USERENV 4-33
                   EXCLUSIVE - 
                        CREATE DATABASE 5-49
                   EXECUTE IMMEDIATE - 
                       ⪮ ᠭ 5-4

                                   -- 323 --



                       । 5-95
                       ਬ 5-95
                       ᨭ⠪ B-7
                       ᨭ⠪  ஥ SQL 5-95
                   EXECUTE - 
                       ⪮ ᠭ
                       । 5-94
                       ਬ 5-94
                       ᨭ⠪ -6
                       ᨭ⠪  ஥ SQL 5-94
                   EXISTS -  ࠢ
                       । 4-4
                        ᫮ 4-43
                   EXPLAIN PLAN - 
                       ⪮ ᠭ 5-4
                       । 5-96 - 5-97
                       ਬ 5-97
                       ᨭ⠪ 5-96,-7

               ࠢ筮 㪮⢮   SQL     9



E                   F                   F           

                   F7DEC - ᨬ  4-24
                   FALSE - १ ᫮ 4-42
                   FETCH - 
                       ᯮ짮 ᫥  OPEN 5-115
                       ᯮ짮 ࠧ CURRENT OF 5-143
                        訡 " 롮ન" 5-99
                       ⪮ ᠭ 5-4
                       । 5-98 - 5-99
                       ਬ 5-99
                       ᨭ⠪  ஥ SQL 5-98,B-7
                   FLOAT - ⨯  3-17
                   FLOOR - ᫮ 㭪 4-12
                   FOR - ࠧ
                         EXECUTE 5-94
                       । 5-100
                       ਬ 5-100
                       ᨭ⠪  ஥ SQL 5-100,B-7
                   FOR UPDATE - ࠧ
                        DECLARE CURSOR 5-78
                        SELECT 5-131
                   FOR UPDATE OF - ࠧ
                        SELECT 5-129
                        SELECT   5-134
                   FOREIGN - ࠭祭  ⮫ 5-35
                   FROM
                       ࠧ 6-2
                       ࠧ, ᠭ 6-2
                       ࠧ, ਬ 6-3
                   FROM - ࠧ
                        CREATE DATABASE LINK 5-50
                        REVOKE 5-121
                        SELECT 5-130
                   FROM DUAL - ࠧ -7

                                   -- 324 --



E                   G                   F

                   GOTO
                       ⢨  WHENEVER 5-146
                   GRANT - 
                       ⪮ ᠭ 5-4
                       ᯥ祭 㯠    5-101
                       । 5-101 - 5-106
                       ਬ 5-102 - 5-103,5-106
                       ᨭ⠪ 5-101,5-103 - 5-104,-7
                   GRAPHIC - ⨯  3-17
                   GREATEST - 㭪 4-31
                   GROUP BY - ࠧ
                         CREATE VIEW 5-76
                         SELECT 5-129,5-131
                       㯯 㭪樨 4-20
                        ⨯ LONG 3-16
                       । 6-3









































                                   -- 325 --



               ࠢ筮 㪮⢮   SQL     10



E                   H                   F

                   HAVING - ࠧ
                         SELECT 5-129,5-131
                       । 6-3
                   HEXTORAW - 㭪 ८ࠧ 4-24
                   HH -  ଠ  4-37
                   HH12 -  ଠ  4-37
                   HH24 -  ଠ  4-37
                   HOLD_CURSOR -   ४ ORACLE 5-26
                   Host 1-4
                   Host - ६
                        ஥ SQL INSERT 5-109
                         EXECUTE 5-94
                         OPEN 5-115
                        ᯨ᪥ INTO 5-133
                        ࠧ WHERE  UPDATE 5-143
                   Host - ६, । 2-6
                   Host_string 2-6

E                   I                   F

                   IN -  ࠢ
                       । 4-3
                       ਬ 4-3
                   INCLUDING CONTENTS -   DROP
                       TABLESPACE 5-192
                   INCLUDING TABLES -   DROP
                       CLUSTER 5-85
                   INCREMENT BY -   CREATE
                       SEQUENCE 5-58
                   INDEX - ਢ  ꥪ 5-105
                   INITCAP - ᨬ쭠 㭪 4-15
                   INITIAL -  ࠧ STORAGE 5-137
                   INITRANS -   CREATE TABLE 5-69
                   INSERT - ਢ ꥪ 5-105
                   INSERT -  3-16
                       ᯮ짮   5-75
                       ⪮ ᠭ 5-4
                       室 ਢ 5-107
                       । 5-107 - 5-110
                       ਬ 5-108
                       ਬ  ஥ SQL 5-110
                       ᨭ⠪ 5-107,5-109,-7 - -8
                       ᨭ⠪  ஥ SQL 5-109,B-8
                   INSTR - ᨬ쭠 㭪 4-19
                   INTEGER - । 3-13
                   INTEGER - ⨯  3-17
                   INTERSECT - ⢥  4-6
                        ࠧ ORDER BY 6-11
                        ࠬ SELECT 5-131
                   INTO - ࠧ
                         FETCH 5-98
                         SELECT 5-133

                                   -- 326 --



                   IS [NOT] NULL -  ࠢ, । 4-4
                   ISO - 㭠த ࣠   ⠭⨧樨
                          2-2
               ࠢ筮 㪮⢮   SQL     11



E                   J                   F

                   J -  ଠ  4-37

E                   K                   F

                   K - ᫮  () 3-13

E                   L                   F

                   LAST_DAY - 㭪 ࠡ  ⠬ 4-27
                   LEAST - 㭪 4-32
                   LENGTH - ᨬ쭠 㭪 4-19
                   LEVEL 1-4
                       ᥢ⮫ 3-27
                   LEVEL - ᥢ⮫   SELECT 5-130,
                        6-10
                   LIKE
                        ࠢ 4-9
                        4-4
                   LIKE -  ࠢ, । 4-4
                   LOCK TABLE - 
                       ⪮ ᠭ 5-4
                       । 5-111 - 5-112
                       ਬ 5-112
                       ᨭ⠪ 5-111,-8
                   LOGFILE -   CREATE DATABASE 5-48
                   Logging off - . "RELEASE - "
                   Logging on - . "CONNECT - "
                   LONG -  3-23
                   LONG - ⨯  1-4,3-16 - 3-17,3-23
                        ࠢ  LONG RAW 3-17
                       ᨬ쭮 ᫮ ᨬ 3-16
                       ࠭祭 3-16
                   LONG RAW -  3-23
                   LONG RAW - ⨯  1-4,3-17,3-23
                       ᠭ 3-17
                   LONG VARCHAR -  3-23
                   LONG VARCHAR - ⨯  3-17
                   LONG VARGRAPHIC - ⨯  3-17
                   LOWER - ᨬ쭠 㭪 4-15
                   LPAD - ᨬ쭠 㭪 4-15
                   LTRIM - ᨬ쭠 㭪 4-16

E                                      F

                    - ᫮  () 3-13
                   MAX - 㯯 㭪 4-21
                   MAXDATAFILES -   CREATE DATABASE 5-48
                   MAXEXTENTS -  ࠧ STORAGE 5-138
                   MAXINSTANCES -   CREATE DATABASE 5-48

                                   -- 327 --



                   MAXLOGFILES -   CREATE DATABASE 5-48
                   MAXTRANS -   CREATE TABLE 5-69
                   MAXVALUE -   CREATE SEQUENCE 5-58
                   MI -  ଠ   4-37
                   MI -  ᫮ ଠ 4-36

               ࠢ筮 㪮⢮   SQL     12


                   MIN - 㯯 㭪 4-21
                   MINEXTENTS -  ࠧ STORAGE 5-138
                   MINUS - ⢥ 
                        ࠧ ORDER BY 6-11
                        ࠬ SELECT 5-131
                   MINVALUE -   CREATE SEQUENCE 5-58
                   MM - ଠ  4-36
                   MOD - ᫮ 㭪 4-12
                   MON -  ଠ   4-37
                   MONTH -  ଠ   4-37
                   MONTHS_BETWEEN - 㭪 ࠡ  ⠬ 4-27

E                   N                   F

                   NEW_TIME - 㭪  ࠡ  ⠬ 4-27
                   NEXT -  ࠧ STORAGE 5-137
                   NEXT_DAY - 㭪  ࠡ  ⠬ 4-28
                   NEXTVAL
                       㬥  ᫥⥫쭮⥩ 5-61
                       ᯮ짮  ࠦ 4-40
                       ᯮ짮     CURRVAL 5-63
                       ᥢ⮫ 3-26
                       ࠭祭  ᯮ짮 5-62
                   9 -  ᫮ ଠ
                   NLSSORT
                       ᨬ쭠 㭪 4-20
                       㭪 2-4
                   NOARCHIVELOG -   CREATE DATABASE 5-49
                   NOAUDIT - 
                       ⪮ ᠭ 5-4
                       । 5-113 - 5-114
                       ਬ 5-113 - 5-114
                       ᨭ⠪ 5-113 - 5-114,-8
                   NOAUDIT - 樨  . "AUDIT - "
                   NOSORT
                         CREATE INDEX 5-53
                       㬥襭 ६  ᮧ  5-55
                   [NOT]BETWEEN -  ࠢ, । 4-4
                   [NOT]EXISTS -  ࠢ, । 4-4
                   NOT EXISTS - ⥬   AUDIT 5-22
                   NOT FOUND - ᫮  WHENEVER 5-146
                   [NOT] IN -  ࠢ
                       । 4-3
                       ਬ 4-4
                   [NOT] LIKE -  ࠢ, । 4-4
                   NOT - ᪠ 
                        ࠧ WHERE 6-6
                       । 4-5
                   NOT NULL - ࠭祭  ⮫ 5-35

                                   -- 328 --



                   NOT NULL - ࠧ  ALTER TABLE 5-18
                   NOT NULL -   INSERT 5-107
                   NOWAIT
                         LOCK TABLE 5-111
                         SELECT 5-129






















































                                   -- 329 --



               ࠢ筮 㪮⢮   SQL     13


                   Null 1-5
                         5-55
                        ᫮ 4-43
                       ࠭祭, ਬ 5-37
                       । 3-25
                   NULL - ࠧ  ALTER TABLE 5-18
                   NULL -   INSERT 5-107
                   Null - 祭
                        ࠧ ORDER BY 6-11
                        COMMENT 5-28
                       । 3-25
                   NUMBER - ⨯  1-5,3-17
                       ᨬ쭮 祭 3-11
                       ᠭ 3-11
                   NVL - 㭪 3-25,4-32

E                   O                   F

                   OFFLINE -   CREATE TABLESPACE 5-72
                   ON -   REVOKE 5-121
                   ONLINE -   CREATE TABLESPACE 5-72
                   OPEN cursor - 
                       ⪮ ᠭ 5-4
                       । 5-115 - 5-116
                       ᨭ⠪  ஥ SQL 5-115,B-8
                   OPEN - , ਬ 5-116
                   OPEN_LINKS - ࠬ 䠩 INIT.ORA 5-51
                   OR - ᪠ 
                        ࠧ WHERE 6-6
                       । 4-5
                       ⠡ ⨭ 4-6
                   ORACLE, ४  ஥ SQL 2-5
                   ORACLE, ।  5-34
                   ORDER BY - ﭨ  冷 뤠 ப 1-6
                   ORDER BY - ࠧ
                         SELECT 5-129,5-131
                        ⨯ LONG 3-16
                       ᯮ짮  ROWNUM 3-26
                       । 6-11

E                   P                   F

                   P.M. -  ଠ  4-37
                   PCTFREE - 
                        CREATE INDEX 5-54
                         CREATE TABLE 5-67
                       ஢  樥 PCTUSED 5-70
                   PCTINCREASE -  ࠧ STORAGE 5-138
                   PCTUSED - 
                        CREATE TABLE 5-68
                       ஢  樥 PCTFREE 5-70
                   PM -  ଠ  4-37
                   POWER - ᫮ 㭪 4-13
                   PR -  ᫮ ଠ 4-36


                                   -- 330 --



               ࠢ筮 㪮⢮   SQL     14


                   PREPARE - 
                       ᯮ짮 ᮢ⭮  ஬ SELECT 5-134
                       ⪮ ᠭ 5-4
                       । 5-117
                         ஥ SQL 5-117
                       ਬ 5-117
                       ᨭ⠪ ஥  -8
                   PRIMARY
                       ࠭祭  ⮫ 5-35
                       ࠭祭, ਬ 5-38
                   PRIOR -  4-8
                         CREATE DATABASE LINK 5-51
                       । 4-8
                        ࠧ CONNECT BY  SELECT 5-130,6-9
                   Public (騩) 1-5
                       ࠧ DROP DATABASE LINK 5-86
                         DROP DATABASE LINK 5-86
                         DROP ROLLBACK SEGMENT 5-88
                        GRANT 5-104
                         CREATE ROLLBACK SEGMENT 5-57
                         CREATE SYNONYM 5-64
                         REVOKE 5-121
                       ।⠢ ᮢ  饥 짮 5-103
                       ᥣ ⪠ 5-57
                   PUBLIC - 
                        CREATE DATABASE LINK 5-50
                        REVOKE 5-121

E                   Q                   F

                   Q -  ଠ  4-36

E                   R                   F

                   RAW -  3-23
                   RAW - ⨯  1-6,3-17,3-23
                       ᠭ 3-17
                   RAWTOHEX - 㭪 ८ࠧ 4-24
                   RDBMS 1-6
                   READ ONLY
                       ॠ 5-135
                       ࠭ 5-135
                       DML - , 饭  ⮬ ० 5-135
                       SET TRANSACTION 5-135
                   REFERENCE
                       ࠭祭  ⮫ 譥  5-35
                   REFERENCES
                       ਢ 5-105
                       ਬ 5-40
                   REFERENCES - ࠧ
                       ࠭祭  ⮫ 1-12
                   REFERENCES - ਢ 5-104
                   RELEASE
                         COMMIT 5-31


                                   -- 331 --



                       ROLLBACK, ஥ SQL 5-125
                   RELEASE -  5-31
                        ROLLBACK 5-31

               ࠢ筮 㪮⢮   SQL     15


                   RELEASE_CURSOR - 
                        ४ ORACLE 5-26
                   RENAME - 
                       ⪮ ᠭ 5-4
                       । 5-118
                       ਬ 5-118
                       ᨭ⠪ -8
                       ᨭ⠪  ஥ SQL 5-118
                   REPLACE - 㭪 2-4
                   RESOURCE - ਢ  
                         GRANT 5-101
                         REVOKE 5-119
                         AUDIT 5-22
                   RESOURCE - ਢ  ⠡筮 ࠭⢠
                         GRANT 5-103
                         REVOKE 5-120
                       ⬥ ਢ 5-103
                       ।⠢ 5-103
                   REUSE
                         CREATE DATABASE 5-48
                       ࠬ 䠩 ⠡筮 ࠭⢠ 5-19
                       ᯥ䨪 䠩   5-10
                   REVOKE - 
                       ⪮ ᠭ 5-5
                       । 5-119 - 5-122
                       ਬ 5-119 - 5-120,5-122
                       ᨭ⠪ 5-11 - 5-121
                   ROLLBACK - 
                       襭 ࠭樨 5-123, 5-127
                       ⪮ ᠭ 5-5
                       । 5-123 - 5-125
                       ᢮ ஢ 5-131, 5-140
                       ਬ 5-124
                       ᨭ⠪ 5-123,5-125,-8
                       ᨭ⠪  ஥ SQL 5-125,B-8
                   ROUND
                       㭪  ࠡ  ⠬ 4-29
                       ᫮ 㭪 4-13
                   ROWID
                       ᯮ  ... 3-18
                        3-18
                       ᠭ 3-18
                       ᥢ⮫ 3-26
                       ⨯  3-23
                   ROWID - ⨯  1-6
                   ROWIDTOCHAR - 㭪 ८ࠧ 4-25
                   ROWNUM - ᥢ⮫ 3-26,4-40
                   RPAD - ᨬ쭠 㭪 4-17
                   RTRIM - ᨬ쭠 㭪 4-17
                   RX - ஢ 5-111


                                   -- 332 --



E                   S                   F

                   SAVEPOINT - 
                       ⪮ ᠭ 5-5
                       । 5-126 - 5-127
                       ᨭ⠪ 5-126,-9
                       ᨭ⠪  ஥ SQL 5-126




















































                                   -- 333 --



               ࠢ筮 㪮⢮   SQL     16


                   SAVEPOINT - , ਬ 5-127
                   SCC -  ଠ   4-36
                   SELECT -  ORDER BY 5-129
                   SELECT - ࠧ
                         INSERT 5-107
                         UPDATE 5-140 - 5-141
                       ਬ  ᥢ⮫栬 -7
                   SELECT - ᯨ᪨, ᯮ짮  LONG 3-16
                   SELECT - ਢ ꥪ 5-105
                   SELECT - 
                       ⪮ ᠭ 5-5
                       । 5-128 - 5-134
                       ਬ 5-132
                       ਬ  ஥ SQL 5-134
                       ᨭ⠪ 5-128,5-133,-9
                       ᨭ⠪  ஥ SQL 5-133,B-9
                       ࠧ 6-1
                   SESSIONID -  USERENV 4-33
                   SET - ࠧ  UPDATE 3-16,5-140
                   SET TRANSACTION - 
                       ⪮ ᠭ 5-5
                       । 5-135 - 5-136
                       ਬ 5-136
                       ᨭ⠪ 5-135,-9
                   SIGN - ᫮ 㭪 4-13
                   SIZE
                       ᯥ䨪 䠩   5-10
                       ࠬ 䠩  ⠡筮 ࠭⢠ 5-19
                   SIZE - ࠧ  CREATE CLUSTER 5-44
                   SMALLINT - ⨯  5-53
                   SOUNDEX - ᨬ쭠 㭪 4-17
                   SP - 䨪 ଠ  4-38
                   SPTH - 䨪 ଠ   4-38
                   SQL 1-7
                       ஥ 2-5
                        2-2
                       ᪨ ᮣ襭 ORACLE 2-7
                       । 2-1
                       ⨬ ᮢ 2-3
                       প 樮 몮 2-4
                       २⢠ 2-3
                       ⠭⨧ 2-2
                       㭨஢  2-4
                          짮⥫ 2-3
                   /* */ (਩   SQL) 5-2,5-6
                   SQL - ⠭ ANSI 1-14
                   SQL*Net 1-7
                       ᯮ짮 5-50,6-20 - 6-21
                       ப, 뢠   2-6
                   SQL/DS
                        SQL 2-2
                       ⨯  3-17
                   SQLCODE
                       not found 5-83,5-99,5-134,5-143
                   SQLERROR - ᫮  WHENEVER 5-146

                                   -- 334 --



                   SQLROWS
                        UPDATE 5-143
                        DELETE 5-83

               ࠢ筮 㪮⢮   SQL     17


                   sqlwarn(5) 5-83
                   SQLWARNING - ᫮  WHENEVER 5-146
                   SQRT - ᫮ 㭪 4-14
                   SRX - ஢ 5-111
                   SS -  ଠ  4-37
                   SSSS -  ଠ  4-37
                   STDDEV - 㭪 (।筮 ⪫) 4-22
                   START WITH - ࠧ
                        CREATE DATABASE LINK 5-51
                       । 6-9
                        CREATE SEQUENCE 5-58
                        SELECT 5-129 - 5-130,6-10
                   STDDEV - ᫮ 㭪 4-22
                   STOP - ⢨  WHENEVER 5-146
                   SUBSTR - ᨬ쭠 㭪 4-18
                   SUM - 㯯 㭪 4-22
                   SYEAR -  ଠ  4-36
                   SYSCATALOG -  ᫮ 
                        COMMENT 5-28
                   SYSCOLUMNS -  ᫮ 
                        COMMENT 5-28
                   SYSDATE - 㭪 3-15
                   SYSTEM - 㬠稢 ⠡筮 ࠭⢮ 5-73
                   SYYYY -  ଠ  4-36

E                   T                   F

                   TERMINAL -  USERENV 4-33
                   TH - 䨪 ଠ  4-38
                   THSP - 䨪 ଠ  4-38
                   TO_CHAR - 㭪 ८ࠧ 4-25
                       ਬ 4-34
                   TO_CHAR - 㭪 3-16
                        ଠ 4-34
                   TO_DATE - 㭪 ८ࠧ 4-26
                   TO_DATE - 㭪 3-15
                        ଠ 4-34
                   TO_NUMBER
                       㭪 ८ࠧ 4-26
                       । 4-35
                   TRUE - १ ᫮ 4-42
                   TRUNC - 㭪   4-29
                         - ᫮ 㭪 4-14


E                   U                   F

                   UID - ᥢ⮫ 4-32
                   UNION - ⢥  4-6
                        ࠧ ORDER BY 6-11
                       c ࠬ SELECT 5-131

                                   -- 335 --



                   UNIQUE - ࠭祭  ⮫ 5-35
                   UPDATE - ਢ ꥪ 5-105
                   UPDATE - ਢ 5-104
                   UPDATE -  5-141

               ࠢ筮 㪮⢮   SQL     18


                       ᯮ짮  ஬ 5-75
                       ᯮ짮 ᫥⥫ ஢ 5-63
                       ⪮ ᠭ 5-5
                       । 5-139 - 5-144
                        5-140
                       ਬ 5-140
                       ਬ  ஥ SQL 5-144
                       ᨭ⠪ 5-139,5-142,-9
                       ᨭ⠪  ஥ SQL 5-142,B-10
                       ࠧ SET 3-16
                   UPPER - ᨬ쭠 㭪 4-18
                   US7ASCII - ᨬ  4-24
                   USER
                           5-101
                       ᪮쪮 ਢ    ⮬ 
                         ꥪ 5-121
                       ᥢ⮫ 4-33
                   USING - ࠧ  OPENcursor 5-115

E                   V                   F

                   V -  ᫮ ଠ 4-36
                   VALIDATE INDEX - ࠢ 5-145
                   VALIDATE INDEX - 
                       ⪮ ᠭ 5-5
                       । 5-145
                       ਬ 5-145
                       ᨭ⠪ 5-145,-10
                   VALUE -   INSERT 5-107
                   VALUES - ࠧ  INSERT 5-109
                   VARCHAR -  3-23
                   VARCHAR - ⨯  3-10,3-17
                       ᠭ 3-9
                   VARGRAPHIC - ⨯  3-17
                   VARIANCE - 㯯 㭪 4-22
                   VSIZE - 㭪 4-33

E                   W                   F

                   W -  ଠ  4-37
                   WE8DEC - ᨬ  4-24
                   WE8HP - ᨬ  4-24
                   WEIBMPC - ᨬ  4-24
                   WHENEVER - ࠧ
                        AUDIT 5-22
                        NOAUDIT 5-113
                   WHENEVER - 
                       ⪮ ᠭ 5-5
                       । 5-146 - 5-147
                       ਬ 5-147

                                   -- 336 --



                       ᨭ⠪  ஥ SQL 5-146,B-10
                   WHERE
                       । ࠧ 6-5
                       ࠧ  DELETE 5-81
                       ࠧ ஥ SQL 6-7
                       ࠧ  UPDATE 5-140

               ࠢ筮 㪮⢮   SQL     19


                   WHERE - ࠧ
                         ⨯ LONG 3-16
                       ⢨   DELETE  UPDATE 6-8
                       sqlwarn(5) 5-143
                   WITH CHECK -   CREATE VIEW 5-74
                   WITH CHECK -   ஢ 1-7
                   WITH GRANT OPTION - ࠧ  GRANT 5-104
                   WORK
                       祢 ᫮ 5-31,5-125
                       . "᪠  ࠡ"
                       ROLLBACK -  5-123
                   WW -  ଠ   4-37

E                   Y                   F

                   Y -  ଠ   4-36
                   Y,YYY -  ଠ   4-36
                   YEAR -  ଠ   4-36
                   YY -  ଠ   4-36
                   YYY -  ଠ   4-36
                   YYYY -  ଠ   4-36

E                   Z                   F

                   0 -  ᫮ ଠ 4-36
 
               ࠢ筮 㪮⢮   SQL     20






















                                   -- 337 --





E                                      F

                   ॢ
                         -7
                   ਩ 襭
                       ⮬᪨ ⪠ 5-31
                    ப 3-18
                   ⨢ ⢮
                       । ஬ OPEN cursor 5-115
                    1-1
                       ⠡ 5-140,6-2
                   㬥 1-1
                       । 4-11
                   䬥᪠  4-2
                   娢஢ 䠩 ୠ ୮ 믮
                   5-9

E                                      F

                    
                       /२ 䠩 5-19
                        䠩 5-47
                        裡 6-20
                        1-1
                       । 1-2
                       ᮧ 5-47 - 5-49
                       ᮧ 裡  쭮  㤠 5-50
                       ਭ 5-9
                       祭 ᫠ ஢, 䠩  -
                           䠩 ୠ ୮ 믮 5-47
                       ࠭祭      㤠
                          5-51
                       ⪫祭, ஥ SQL 5-125
                       ⨥/⨥ 5-9
                       ⬥ ਥ 5-28
                       ⬥ ⠡筮 ࠭⢠ 5-92
                       ।⠢ 㯠 5-101
                       ਢ, ⬥ 5-119 - 5-121
                       ।  5-137
                       ᯥ䨪 1-3
                       㤠  5-87
                       㤠  5-85
                       㤠 ஢ 5-93
                       㤠 ᥣ⮢ ⪠ 5-88
                       㤠 ᨭ 5-90
                       㤠 ⠡ 5-91
                       㤠,    6-20
                       㤠, ॣ 6-21
                       㤠, 祭 5-33
                    1-1
                      ROWID 3-18
                    ࠧ
                       ﭨ PCTINCREASE 5-138




                                   -- 338 --



               ࠢ筮 㪮⢮   SQL     21


                   ஢ 1-4
                         5-112
                       ᪫⥫쭠 5-111
                       ᪮쪮 5-112
                       ᢮ ஢ 5-31
                       ᢮   ROLLBACK 5-123
                       ᢮   COMMIT 5-123
                       ਬ 5-112
                       ⨯ 5-111
                   ஢
                       ᪫⥫ 5-140
                       ⠡ 5-111
                   ஢ share row exclusive 5-111
                   ஢ share update 1-7

E                                      F

                   , ࠭ 3-15
                   㠫 ⮫ 1-8
                   譨  1-3
                        祭 null 1-12
                       ᪮쪮 1-11
                       । 1-11
                       ஥஢ ⠡ 1-3
                       ⠢ 1-11
                   譥 ꥤ 1-5,6-15
                       । 6-14
                   譨 ⮫ - 뫪  ७  6-19
                   ७ , । 6-19
                   騩 冷 6-11
                   ⠭   䠩 ୮ -
                        5-9
                   ६
                       24 - ᮢ ଠ 3-15
                        3-15
                        4-27
                       ஢  ࠢ  3-15
                       㬮砭 3-15
                   ६  4-27
                   ६ ᥣ 1-7
                   ⠢ ਥ    5-28
                   ⠢ ப  ⠡ 5-70
                   ஥ SQL
                       । 2-5,5-2
                       UPDATE -  -10
                       CLOSE cursor -  5-26,B-3
                       COMMIT -  5-31,B-3
                       CONNECT -  5-32 - 5-34,B-4
                       DECLARE CURSOR -  5-78,B-5
                       DECLARE DATABASE -  5-79,B-5
                       DECLARE STATEMENT -  5-80,B-5
                       DELETE -  5-82 - 5-83,B-6
                       DESCRIBE -  5-84,B-6
                       EXECUTE IMMEDIATE -  5-95,B-7


                                   -- 339 --



                       EXECUTE -  5-94,B-6
                       FETCH -  5-98 - 5-99,B-7
                       FOR - ࠧ 5-100,-7

               ࠢ筮 㪮⢮   SQL     22


                       INSERT -  5-109 - 5-110,B-8
                       OPEN cursor -  5-115 - 5-116,B-8
                       PREPARE -  5-117,B-8
                       ROLLBACK -  5-125,B-8
                       SELECT -  5-133 - 5-134,B-9
                          ନ 2-6
                       UPDATE -  5-142 - 5-144
                          ᯮ짮 ६ 3-8
                       WHENEVRE -  5-146 - 5-147,B-10
                       WHERE - ࠧ 6-7
                   롮ઠ ப  ⠡, ஥ SQL 5-133
                   믮  ८ࠧ  3-20
                   ࠦ
                        ᯮ 4-39
                       ᯮ짮  ᫮ 4-42
                       । 4-39
                       ।, ᨭ⠪ 4-40
                       ਬ 4-39
                       ᫮, ।騩  4-2


E                                      F

                    1-4
                   , ࠭ 3-15
                   ᪨ ᨬ, ࠭ 3-17
                   㯯 㭪 1-4,4-20
                   㯯 㭪樨  祭 null 3-25

E                                      F

                    - ࠢ ଠ⮬ 뤠 4-34
                   
                        ⨯ 3-23
                       ࠫ 3-8
                        ଠ 4-34,4-36
                       ࠢ ࠢ 3-20
                       ⨯  1-3,3-23
                       㬮砭 3-15
                       ଠ 4-36
                    ࠦ 3-19
                    , ࠭  ROW  LONG ROW 3-17
                   ⢨⥫쭮 ᫮ 3-14
                   ⮢ ந
                       । 6-14
                   ਯ,  5-84
                    樨 3-11
                       ⥫ 3-11
                   ᪨ SQL 5-116
                    ப  ⠡ 5-70
                    ⠡   5-45

                                   -- 340 --



                    䠩 ୠ ୮ 믮
                        ALTER DATABASE 5-9
                   㬥⮢, ࠭ 3-16
                     ப
                       १  1-8

               ࠢ筮 㪮⢮   SQL     23


                    設, । 3-27
                   ॢ  1-7
                        CREATE DATABASE LINK 5-51
                   㡫騥   ᯮ짮 権
                       UNION, INTERSECT, MINUS 4-6
                   㡫騥 祭  譥  1-12


E                                      F

                   ୠ ୮ 믮
                        䠩    5-9
                       祭 ⢠ 䠩 ஬ CREATE
                          DATABASE 5-47

E                                      F

                   襭 ࠭樨
                       ஬ COMMIT 5-29
                       ஬ ROLLBACK 5-125
                     
                        ALTER DATABASE 5-9
                    1-6
                       ᨭ ப 1-6
                    1-5
                       ७: । 6-19
                         5-74
                         CREATE TABLE 5-67
                         INSERT 5-107
                       ॢ 5-51
                        ஢ 5-112
                       ᯮ짮 ROWID 3-18
                       ५஢ 5-139,6-19
                       ஢ ⮫ 6-19
                       ࠭祭  ᮢ १
                            5-51
                       । 6-16 - 6-17
                       ࠧ襭 ஢  5-11
                       ᯥ஢ 浪 뤠 १ 6-11
                       㤠 5-34
                       SELECT 5-128
                    -  ᫮ ଠ 4-36
                   १ࢨ஢ ᫮ 1-6
                   १ࢨ஢ ᫮
                       । 3-5
                        ⨯  3-17
                    १  1-7
                   祭, ᯮ짮  ࠦ 4-39
                   祭 権 4-2

                                   -- 341 --



E                                      F

                    ⢨  AUDIT 5-114
                    ଠ 뤠
                        ଠ 4-34
                   
                        裡 6-20
                        ࠭祭 楫⭮ 5-36



















































                                   -- 342 --



               ࠢ筮 㪮⢮   SQL     24


                    ࠢ  ꥪ⮢   3-3
                    1-4
                       ७ ଠ 5-53
                       ᯮ짮  樥 LIKE 4-10
                        5-45,5-55
                       ஫ 楫⭮ 5-145
                       ᨬ쭮 ᫮ ⮫殢   5-53
                       ᪮쪮   ⠡ 5-53
                        DROP TABLE 5-91
                       । 1-8
                       ।  5-137
                       ᮣ襭   5-54
                       ᮮࠦ ⭮⥫쭮 ந⥫쭮 5-54
                       ᯮᮡ 祭 㭨쭮 1-8
                       ⮫ 5-53
                       㤠    5-87
                       㤠  㤠 ⠡ 5-91
                       㭨 5-54
                    ⮫, । 5-52
                      ⨯ LONG 3-16
                    ६   FETCH 5-99
                   ᪫⥫쭠 ஢ 1-3,5-111

E                                      F

                    짮⥫  ⠡筮 ࠭⢥ 5-103
                   ஢   ᫥⥫ ஢ 5-61
                   ७ 1-6
                    1-1
                        ⠡   5-45
                         ।  5-8
                        1-1
                       , । 5-45
                       , । 5-43
                       ࠭祭 5-44
                       । 1-8
                         CREATE TABLE 5-70
                       ६饭  㣮 ⠡筮 ࠭⢮ 5-8
                       冷 ᫥ ⮫殢 5-44
                       ।  5-137
                       ᮧ 3-17
                       ᮧ  5-52
                       ⮫ 1-1
                       ⮫, । 5-43
                       ⠡ 5-66
                       㤠    5-85
                       㤠 ⠡ 5-85
                       㤠 ⠡   5-8
                       SIZE 5-44
                    1-4
                       譨  1-11
                        㭨 5-59
                       ᭮  1-10
                       㭨  1-12


                                   -- 343 --



                     5-43
                   祢 ᫮, । 3-7
                   ⥭ 1-2

               ࠢ筮 㪮⢮   SQL     25


                   ⥭樨  4-3
                    1-2
                    ப 1-2
                   ਩
                       㤠    5-28
                       SQL, । 5-6
                   ⥪ ( )
                        DECLARE STATEMENT 5-80
                        ஥ SQL WHENEVER 5-146
                   ५஢  1-2,5-129
                       । 6-18
                   ५஢ 䨪, । 5-140
                   ५஢  5-139,6-19
                   ⥦ 1-7
                       ᨭ  ப 1-6
                   
                         FETCH 5-98
                       믮 , OPEN 5-115
                        ᫥ FETCH 5-99
                       ࠧ  5-78

E                                      F

                   ᪨ ᮣ襭 SQL ORACLE 2-7
                    1-4
                   -㧫, । 3-27
                   ࠫ, । 3-8
                    ᥣ ⪠ 5-57
                   ᪠ ᨬ  1-9
                   ᪮ ࠦ 1-4
                        ࠧ WHERE 6-6
                   ᪠  ࠡ
                       । 5-127
                       . ⠪ "ࠡ⪠ ࠭権"
                   ᪠ , । 4-5
                       ᯮ짮  ᫮ 4-42
                   쭠  㤠  , ᮧ 
                        裡 5-50

E                                      F

                   ᪨ ଠ⮢ 3-15
                   ᨢ
                         FETCH 5-99
                         INSERT ஥ SQL 5-109
                         SELECT ஥ SQL 5-134
                         UPDATE ஥ SQL 5-143
                       ࠭ 3-16
                   ⠡ 3-11
                       ᯮ짮 3-11
                       ⥫ 3-11

                                   -- 344 --



                     1-2
                       ᯮ짮 ᨭ 5-64
                       ᪠  짮⥫ 5-50
                       ⬥ 5-86
                       ਬ 5-51
                       ᮧ 5-50 - 5-51

               ࠢ筮 㪮⢮   SQL     26


                       㤠 祭 5-34
                       ࠧ FROM 6-2
                       public 5-50
                   ⢥  1-7
                   ⢥ ᫮ 1-7
                   
                       ⭮襭 魮⥩ 1-2
                       ५樮 1-1
                    ଠ 1-3
                        ४⭮ ଠ 4-35
                       । 4-34
                   ஢   5-9

E                                      F

                   筠 , 뤠 ᥫ 4-36
                   ᨬ  1-3
                         1-9
                       ᪠ 1-9
                       ⭮⥫쭮 ப 1-6
                         ᨭ 5-64
                       䨧᪠ 1-9
                   ஢ ⮫   6-19
                   ଠ 室  ORACLE 5-29
                   ଠ
                        ⭮襭 魮⥩ 1-2

E                                      F

                    1-8
                        ப 5-107
                       , ᮧ ᨭ 5-64
                         DML 5-75
                       ᯮ짮 5-75
                         5-93
                        ᪮  5-75
                        ᯮ 5-75
                        ᮮ⢥ ⠡ 㤠 5-91
                        DELETE 5-76
                        DROP TABLE 5-91
                        INSERT 5-76
                        UPDATE 5-76
                       ᠭ 1-7
                       । 5-74
                       ⬥  㣮 짮⥫ 5-93
                       ࠬ NOAUDIT 5-104,5-114,5-121
                       २ 5-118
                       ।⠢ 㯠 5-104

                                   -- 345 --



                       ਬ ᮧ 5-76
                       ਬ 㤠 5-93
                       ॣ 㯠 5-24
                       楫 - ᨬ  1-9
                       㤠    5-93
                   , ࠭ । 3-16
                   騩 ᨭ, । 5-64

               ࠢ筮 㪮⢮   SQL     27


                   ꥤ 1-4
                       譥 6-15
                         5-43
                       ⮥ 6-13 - 6-14
                   ꥤ, ⮫ 1-4
                   ꥪ   1-3
                       । 3-2
                       ࠢ  3-3
                       १ ⬥  ਢ 5-119
                   ꥪ -     3-2
                   ꥪ  ,  3-2
                     5-78
                   ࠭祭 1-2
                         CREATE TABLE 5-71
                       譨 /뫪 5-35
                        ⮫ 1-2,5-36
                        ⠡ 5-36,5-66
                         㤠, ALTER TABLE 5-17
                       ᯮ짮   ALTER TABLE 5-37
                       ᯮ짮   CREATE TABLE 5-37
                       ஢ 5-67
                       ࠭祭 WITH CHECK OPTION 5-74
                       । ⮫ 5-35 - 5-41,-3
                       । ⠡ 5-35 - 5-41
                       ਬ 5-37
                       ⨯ ࠭祭 5-36
                       㬠稢  5-36,5-74
                        ࠭祭 1-14
                       CHECK 5-35
                       NOT NULL 5-35
                       PRIMARY -  5-35
                       UNIQUE -  5-35
                   ࠭祭  ⮫ 1-2
                        ᭮  1-10
                       ࠭祭   祭 5-35
                       । 1-14,5-35 - 5-41,-3
                       ᨭ⠪ 5-35
                   ࠭祭 楫⭮ 1-4
                       ⭮⥫쭠 楫⭮ 1-13
                   ࠭祭 楫⭮  ஥஢
                       ⠡ 1-2
                   ࠭祭  ।  6-21
                   㣫 ᫥ ॢ襭 ᨬ㬠 ⠡ 3-11
                   㣫 ᫮  3-11
                   㣫 ᫮ , 믮塞 १
                        㪠 ⠡ 3-11
                    1-2

                                   -- 346 --



                        믮  ஥ SQL 5-95
                       ࠧ   EXECUTE IMMEDIATE 5-95
                       FETCH 5-98
                       READ ONLY - ࠭ 5-135
                    5-91
                       롮ન  ⠡ 5-128
                       ஥஢ ⠡ 1-3,1-5
                   樮 ⥬ 1-5



















































                                   -- 347 --



               ࠢ筮 㪮⢮   SQL     28



                    1-5
                       䬥᪠ 4-2
                       ⠭ 4-2
                        4-2
                       ᯮ짮  ࠦ 4-39
                       ⥭ 1-2
                       ᪠ 4-3,4-5
                       ⢥ 4-6
                       । 4-2
                       ࠢ, ४⨥ 4-2
                       ᨬ쭠 4-3
                       ᫮ 4-2
                       ᬥ蠭 4-8
                       㬭 4-2
                       NOT IN 4-4
                    ⠭ 4-2
                     4-2
                    ᫮ 4-2
                    㬭 4-2
                   ⨬ ᮢ SQL 2-3
                   ᭮  1-5
                       ⮬᪮ ஢  
                         ᫥⥫ ஢ 5-58
                        ⭮襭 魮⥩ 1-2
                       室 1-10
                       । 1-10
                       ᯥ஢ ࠭祭 5-38
                       ⠡  ࠭祭 REFERENCE 5-38
                   ᭮ : ࠢ ᮧ 1-10
                   ⪠  (rollback)
                       ﭨ  ॣ 㯠 5-23
                         ࠭ 5-126
                       ⭮       ࠭ 5-123
                   ⪫祭 (ᮥ)   
                       襭 ࠭樨 5-127
                         樨 RELEASE  COMMIT 5-31
                         樨 RELEASE  ROLLBACK
                          5-125
                   ⨥   ஬ ALTER DATABASE 5-9
                   ⫨ 祭   5-43
                   ⬥ 䠩 ୠ ୮ 믮
                       ALTER DATABASE 5-9
                   ⭮⥫쭠 楫⭮ 1-6
                       । 1-13
                       १  1-7,5-75
                   ⭮⥫쭮 楫⭮ ࠢ 1-6
                   ⭮襭 1-6
                       ᨭ  ⠡ 1-3
                   ⭮襭
                        ⭮襭 魮⥩ 1-2
                   ⥫ ⠡, । 3-11

E                                      F


                                   -- 348 --



                   
                       饭 ᫥ DELETE 5-81
                       饭 ᫥ ⬥ ⠡ 5-91
                       饭 ᫥ ⬥  5-87
                       業 ᯮ짮  ⠡ 1-6






















































                                   -- 349 --



               ࠢ筮 㪮⢮   SQL     29


                   
                         5-12
                         CREATE ROLLBACK SEGMENT 5-57
                       ।  ᥣ⮢ ⪠ 5-57
                       ALTER ROLLBACK SEGMENT 5-13
                       ALTER TABLE 5-17
                       ALTER TABLESPACE 5-19
                    ।  ⠡ 5-66
                   ࠫ쭮       ⮩ 
                          ⠡ 5-135
                   ஫ 1-5
                         ALTER USER 5-21
                         5-101 - 5-102
                       ᯥ஢   GRANT 5-101
                       㪠  ६ ᮥ  ORACLE 5-32
                   २    ୠ ୮
                       믮 5-9
                   ४⨥ ଠ쭮 浪 믮
                       権 4-2
                   ६, । 3-8
                   ६  ଠ஢  4-37
                   ६    5-44
                   ६  ப 3-10
                   ୮ 砫 祭 ᫥⥫ -
                       ஢ 5-14
                    譨 ஡  ଠ-
                       ஢  4-37
                   প 樮 몮
                       NLSSORT - 㭪 4-20
                       প 2-4
                    1-7
                       . "५஢ "
                       . ""
                       १  , ࠭祭 5-51
                       SELECT 5-132
                    ப    5-53
                   뢠 , ࠢ 뤠祩 4-34
                    1-3
                        祭  ⠡ 5-139
                       ᨭ  ⮫ 1-4
                   , ।⠢ 짮⥫ 5-102
                   짮⥫, ।⠢ ࠢ 5-102
                   짮⥫  1-8
                           5-101
                       㪠   裡  ORACLE 5-32
                   冷
                       樨 ᫥⥫쭮 5-59
                         CREATE SEQUENCE 5-59
                       ⮫殢 1-4
                       ⮫殢   5-53
                   ᫥⥫쭮 1-6
                         SELECT 5-132
                        5-62
                       ᨬ  ⠡ 5-60


                                   -- 350 --



                       ⬥ 5-59
                       ⥫ 蠣 5-58
                       ࠬ NOAUDIT 5-104,5-114,5-121

               ࠢ筮 㪮⢮   SQL     30


                         5-89
                       ந⥫쭮 5-60
                       ய ஢ 5-61
                       ॣ 㯠 5-24
                       ᮧ 5-58 - 5-63
                       㬮砭 5-60
                       ᯮ/ 5-60
                   ᫥⥫쭮 ஢ 1-2
                       頥 㭪樥 NLSSORT 4-20
                       祭, 頥 㭪樥 ASCII 4-19
                       । 3-20
                       ASCII 3-20
                       EBCDIC 3-22
                   ᫥⥫ 
                       ஢ 5-59
                        5-58
                       ⠭/⬥ CACHE 5-14
                       ⠭/⬥ ORDER 5-14
                       蠣  5-14,5-58
                       ᯮ/ 5-60
                       MAXVALUE 5-58
                       MAXVALUE,MINVALUE 5-14
                       MINVALUE 5-58
                   ८ࠧ  3-19
                   䨪  ଠ  4-37
                   ਢ 1-5
                       । 㣮 짮⥫ 5-105
                       ⨯  ⠡ 5-104,5-121
                       CONNECT 5-101
                       DBA 5-102
                       RESOURCE 5-101
                   ਢ, ।⠢塞  ⠡ 5-106
                   ᮥ (祭) 1-2
                   ஧筮 ᯮ 
                       १ ᨭ 5-64
                   ⮥ ꥤ 6-13
                   ᥢ⮫ 1-5
                       ᯮ짮   SELECT F-7
                       । 3-26
                       UID 4-32
                       USER 4-33
                   ᥢ⮫ 5-61
                   㭪  ଠ஢  4-37

E                                      F

                    ᪨ ஢
                        EXECUTE IMMEDIATE 5-95
                        PREPARE 5-117
                   塞 ஢ 1-7
                   塞 ஢  5-111ࠧ  㯠 

                                   -- 351 --



                   ⠡ 5-111
                   ஢   5-9
                   ।    5-8
                   । , । 6-20

               ࠢ筮 㪮⢮   SQL     31


                   । 
                       ᯮ짮  ⨯ LONG 3-17
                       ࠭祭 6-21
                    㯠 1-1
                    ஢ ⠡ 5-111
                    ,  
                         ஡ 4-37
                    ᮢ⨬  ᨥ 5,  
                            " 롮ન" 5-110
                   ⥫᪠ 設, । 3-27
                   ⥫᪨  1-5

E                                      F

                    , १ࢨ㥬  
                       PCTFREE 5-68
                   
                       ᮧ  쭮  㤠 
                           5-50
                         5-50
                       ⬥  裡 5-86
                   裡 ,   6-20
                    1-6
                    ⪠ 1-6
                          ⠡筮 ࠭⢮ 5-88
                       ᮣᮢ ⥭, ॠ 5-136
                       ᮧ 5-57
                       ਬ ᮧ 5-88
                       READ ONLY - ࠭ 5-136
                    1-4
                   ()
                       ࠫ 3-8
                        4-3
                       ࠢ ࠢ 3-20
                       㭪樨  ࠡ 4-14
                    - ࠧ  ࠢ  蠡 4-10
                     3-10
                    
                       ⨬ 3-9
                       প 樮 몮 4-24
                       㭪 CONVERT 4-23
                    1-7
                       ᯮ짮 ᮢ⭮    5-51
                         5-90
                        ⬥ 5-90
                        ⬥ ᨭ, ᮧ 㣨
                           짮⥫ﬨ 5-90
                        ᯮ㥬 ⠡ 㤠 5-91
                       २ 5-118
                       ਬ 5-65,5-90

                                   -- 352 --



                       ॣ 㯠  ... 5-24,5-114
                       ᮧ  ⠡   5-64
                       㤠    5-90
                       DROP TABLE -  5-91
                       DROP VIEW -  5-93
                       PUBLIC 5-64

               ࠢ筮 㪮⢮   SQL     32


                   ⠪ 1-7
                   ⥬ ࠢ ५樮  ,
                       । 1-6
                     ࠦ 4-41
                      1-3
                       ॢ -7
                       ﭨ  CREATE TABLE 5-70
                       ⠢ ਥ 5-28
                        । ࠭祭 5-36
                       ଠ  ᫥⥫쭮 5-60
                       ᯮ짮  ⨯ LONG 3-16
                       । -1
                       ⠡ ॣ樨 㯠 5-22
                    
                       ⨥   ஢ 5-75
                       ᭨ ᫮ 1-7
                   蠭 樨 4-8
                   ᮢ 
                       १ ࠭祭 楫⭮ 1-13
                    窨 ࠭ 5-126
                   饭  訡
                        WHENEVER 5-146
                   ஢
                        믮 CREATE INDEX 5-53
                   ⠢
                       譨  1-11
                       ᭮  1-10
                   䨪 䠩
                        ࠧ ADD DATAFILE  ALTER
                          TABLESPACE 5-19
                        ࠧ ADD LOGFILE  ALTER
                          DATABASE 5-9
                        ࠧ DATAFILE  CREATE
                          TABLESPACE 5-48,5-72
                        ࠧ LOGFILE  CREATE DATABASE 5-48
                       । 5-9,5-19,5-47,5-72
                       ᨭ⠪ 5-9,5-19,5-47,5-72,-7
                   ᮪ ᢮ , ᠭ 5-68
                   ࠢ  ࠧ殬, । 4-9
                   ࠢ, 樨 4-3
                   ࠢ, ࠢ 3-20
                   設⢮ 権 1-5
                       । 4-2
                   ⮫ 1-2
                        5-128
                       ,  ஢ 5-76
                       롮ઠ  ⠡ 5-128
                        ਥ 5-28

                                   -- 353 --



                         । ⠡ 5-18
                          䨪 5-17
                       ஢ 1-4
                          5-75
                       , ᯥ஢   CREATE
                         TABLE 5-67
                       , । 5-53
                       ஢ 5-53
                       ஢ , 騥  ⠡-
                            짮⥫ 5-129

               ࠢ筮 㪮⢮   SQL     33


                       ਩, ࠭騩  ᫮  5-28
                       ⢮ ⮫殢   5-53
                       ᨬ쭮 ᫮  ⠡ 5-70
                       २ 5-118
                       २   5-75
                         ⠡ 5-107
                       冷 1-4
                       ।⠢ ࠢ 㯠 5-105
                       ஥஢ ⠡ 1-3 - 1-4
                       ᥢ⮫ 3-26
                       筠 த 1-5
                       㬮砭  ⠢ 5-107
                   ⮫: ࠭祭  ⮫殢 5-36
                   ⮫: ࠭祭  ⠡ 5-36
                   ࠭ 1-5
                   ⮪ 1-6
                       ⠢ ப   ᮧ ⠡ 5-66
                       ᪠ த 1-6
                         ⠡   5-107
                        ப    ஥-
                           SQL INSERT 5-109
                       㡫஢ 1-5
                       । 1-5
                       冷 1-6
                       㤠  ⠡ 5-81
                       㤠  믮  DROP TABLE 5-91
                       FETCH 5-98
                   ப
                        १ ROWID 3-18
                       ஢ १ ROWID 3-18
                   ப  . ROWID
                   ப ᪫⥫ ஢ 5-111
                   ப ᫥⥫   ROWID 3-18
                   ப ࠧ塞 ஢ 5-111
                   䨪  ଠ஢  4-38
                   魮 1-3
                        ⭮襭 魮⥩ 1-2
                        "⭮襭 - 魮" 1-3
                   楯 ப, । 5-68

E                                      F




                                   -- 354 --



                    1-7
                        5-129,6-2
                       ஢ 5-111
                       ⠢ ப   ࠡ  CREATE
                         TABLE 5-66
                       롮ઠ ப  ⮫殢 5-128
                        ਥ 5-28
                        ਥ   ⠡    ᫮
                          5-28
                         ।  ⮫殢 5-18
                        ப 5-107
                        ப      ஥  SQL
                          INSERT 5-109
                          5-42
                        祭  5-139

               ࠢ筮 㪮⢮   SQL     34


                       , ᮧ ᨭ 5-64
                       , ஢ 6-2
                        ⢮ 2-3
                       ਧ 5-66
                       ⢮ ⮫殢 ⨯ LONG 3-16
                        ⭮襭 魮⥩ 1-2
                       ⬥ ⠡筮 ࠭⢠ 5-92
                       ࠬ NOAUDIT 5-114
                       २ 5-118
                       ࠢ ᮧ 1-3
                       ।⠢ 㯠 5-104
                       ।⠢ ਢ 5-106
                       २⢠ 1-3
                       २⢠ 襣 ஥஢ 1-2
                       ਢ 㯠, ⬥ 5-119 - 5-121
                       ਬ ⬥ 5-91
                       ਬ ⠡ 1-15
                       ஢ઠ 楫⭮  5-135
                       ࠧ 㯠 5-111
                       ।  5-66
                       ॣ 㯠 5-24
                       ᮧ 3-17
                       ᮧ  5-52
                       ᯥ஢ ⠡筮 ࠭⢠ 5-66
                       ⮫ 1-2
                        1-3
                       㤠    5-91
                       㤠 ப 5-81
                       㤠 ⠡ 㣮 짮⥫ 5-91
                       㯮冷祭 5-129
                     5-140
                    ⮫ 1-7
                    ࠭祭 楫⭮ 1-7,5-66
                        ᭮  1-10
                       । 1-14,5-35 = 5-41,-9
                       ਬ 5-41
                       ᨭ⠪ 5-35
                    ⨭ 4-5 - 4-6
                   筮 ࠭⢮ 1-7

                                   -- 355 --



                        㬮砭 짮⥫ 5-21
                         ।  5-19
                        砫/砭 backup
                       /२ 䠩   5-19
                         CREATE TABLE 5-69
                         CREATE ROLLBACK SEGMENT 5-57
                       ⬥ 5-73
                       ॢ  online/offline 5-19
                       ।⠢ 짮⥫ ࠢ ࠡ 
                          ⠡筮 ࠭⢥ 5-103
                       ਬ ᮧ 5-73
                       ਬ ⬥ 5-92
                       ᮧ ᥣ⮢ ⪠ 5-57
                       㤠 ᥣ⮢ ⪠ 5-88
                       㬠稢 ६ ᥣ 
                         짮⥫ 5-21
                  , ५樮 1-1

               ࠢ筮 㪮⢮   SQL     35


                    
                       ࠦ 4-39
                       ⪮ ᠭ 3-23
                       । 1-3
                       ࠢ ࠢ 3-20
                       ८ࠧ 3-9
                       ᬥ訢 3-19
                       ᯥ஢   ⮫ 5-27
                       ⠡ ८ࠧ 3-19
                       ᫮ 4-42
                       CHAR 1-1
                       DATE 1-3
                       SQL/DS  DB2 3-17
                   窠 ࠭ 1-6
                       ᢮  믮
                            COMMIT 5-29
                       ⪠ 5-123
                       ਬ  ਫ 5-126
                       ROLLBACK -  5-123
                       ROLLBACK - ஥ SQL
                   窨 ࠭
                        5-126
                       ᨬ쭮 ᫮ ⨢ 5-126
                       ࠬ 䠩 INIT.ORA 5-126
                   窠 -  ᫮ ଠ 4-36
                   筮 3-11
                       ᯮ짮 3-11
                   ࠭ 1-7
                       襭 ஬ COMMIT 5-29
                       襭 ஬ ROLLBACK 5-123
                        । ᮥ 5-29
                        ࠡ 5-29
                       砭 ࠭樨 READ ONLY 5-135
                       । 5-29,5-123,5-127
                       । 祪 ࠭ 5-126
                       ⪠ 5-123
                       ᮣᮢ ⥭ 5-135

                                   -- 356 --



                       READ ONLY 5-135
                       READ ONLY - ॠ 5-135
                   ࠭樨    5-12
                   ࠭権 ࠡ⪠
                        COMMIT 5-31
                        ROLLBACK 5-123 - 5-125
                        SET TRANSACTION 5-135 - 5-136

E                                      F

                   뢠騩 冷 6-11
                     1-6
                      1-6
                        १ ᨭ 5-64
                        쭠, ᮧ   裡 5-50
                       饭   6-20
                        5-79
                       ॣ   6-21
                     6-20








































                                   -- 357 --



               ࠢ筮 㪮⢮   SQL     36


                    ⠡
                       䨪 6-20
                       뫪  6-21
                    ⠡   5-8
                    1-4
                   ࠢ 室묨 १⠬ 4-34
                   ࠢ 㯮
                          5-22
                   ࠢ騩 䠩   CREATE DATABASE 5-48
                   ᫮
                        ᯮ 4-42
                       ⢥ 4-42
                       । 1-2,4-42,6-6
                       ਬ 4-42
                       ᨭ⠪᪮ ᠭ 4-42
                   ᫮ ᪠  ࠧ WHERE 6-7
                   ᫮ ࠧ 6-6
                   稢 ६ ᥣ  짮⥫
                         5-21
                   稢 ⠡筮 ࠭⢮  짮-
                       ⥫ 5-21
                     1-8
                       । 1-12
                   쭮 ப, 砥   -
                        1-8

E                                      F

                   
                        ⠡筮 ࠭⢠ 5-72
                       ⠭ ᫠ 䠩    -
                          CREATE DATABASE 5-47
                     ROWID 3-18
                   ᪨  1-5
                   ᪠ ᨬ  1-9
                   ᪠  ⠡  ஢ 5-43
                   ଠ , 㬠稢 3-15
                   ଠ஢ 
                       ⨯  4-36
                       ᫮ ⨯ 4-36
                   ࠧ 1-1
                   ࠧ STORAGE
                       । 5-137 - 5-138
                       ਬ 5-138
                       ᨭ⠪ 5-137,-9
                   㭪 1-4
                       ᯮ짮  ࠦ 4-39
                       ᠭ 4-11
                   㭪樨
                       㯯 4-20
                       ᯮ짮  ⨯ LONG 3-16
                       ८ࠧ 4-23
                       ᨬ 4-14
                       ᫮ 4-12
                   㭪樨 ८ࠧ 4-23

                                   -- 358 --



               ࠢ筮 㪮⢮   SQL     37



E                                      F

                   ᫮ ()
                       ࠦ  ।騬 4-2
                       ࠫ 3-8
                        ଠ 4-34,4-36
                       ࠢ ࠢ 3-20
                       ଠ 4-36
                       㭪樨 4-12
                   ᫮ ९, ଠ 4-35
                   ᫠  饩 窮, ࠭ 3-11
                   ᫠  䨪஢ 窮, ࠭ 3-11

E                                      F

                   , ⠭   CREATE
                        DATABASE 5-47
                   ᯮ, ।⠢ 3-12
                   ⥭ 1-3
                   ⥭
                       ᨬ쭮 ᫮ 5-138
                       쭮 ᫮ 5-138
                       砫 5-137
                       ᫥ ࢮ 5-137 - 5-138
                       ࠧ ᫥饣 5-138
                       㬠稢 祭 5-137
                       INITIAL size 5-137
                       MAXEXTENTS limit 5-138
                       MINEXTENTS 5-138
                       NEXT size 5-137
                    ᠭ ⮫
                       । 5-27,-3
                       ᨭ⠪ 5-27
                       ᨭ⠪   CREATE TABLE 5-66
                   
                        ଠ  4-36
                        ᫮ ଠ 4-36

E                                      F

                   ᪨  3-16

E                                      F

                    COMMIT  ROLLBACK 5-125
                   , 楤 2-3
                        USERENV 4-33

 






                                   -- 359 --
