oracle9i关键字一览
来源:互联网 发布:mac os官方壁纸 编辑:程序博客网 时间:2024/05/21 10:40
以9i版本为例,一般保留关键字不能用做对象名,详细信息查看v$reserved_words视图.
执行select * from v$reserved_words;
结果如下:
Connected to Oracle9i Enterprise Edition Release 9.2.0.1.0
Connected as SYS
SQL>
KEYWORD LENGTH
---------------------------------------------------------------- ----------
1
2
4
6
& 1
| 1
: 1
, 1
- 1
= 1
> 1
[ 1
< 1
( 1
. 1
+ 1
] 1
) 1
! 1
/ 1
KEYWORD LENGTH
---------------------------------------------------------------- ----------
* 1
^ 1
@ 1
ABORT 5
ACCESS 6
ACCESSED 8
ACCOUNT 7
ACTIVATE 8
ADD 3
ADMIN 5
ADMINISTER 10
ADMINISTRATOR 13
ADVISE 6
AFTER 5
ALGORITHM 9
ALIAS 5
ALL 3
ALL_ROWS 8
ALLOCATE 8
ALLOW 5
ALTER 5
KEYWORD LENGTH
---------------------------------------------------------------- ----------
ALWAYS 6
ANALYZE 7
ANCILLARY 9
AND 3
ANY 3
APPLY 5
ARCHIVE 7
ARCHIVELOG 10
ARRAY 5
AS 2
ASC 3
ASSOCIATE 9
AT 2
ATTRIBUTE 9
ATTRIBUTES 10
AUDIT 5
AUTHENTICATED 13
AUTHID 6
AUTHORIZATION 13
AUTO 4
AUTOALLOCATE 12
KEYWORD LENGTH
---------------------------------------------------------------- ----------
AUTOEXTEND 10
AUTOMATIC 9
AVAILABILITY 12
BACKUP 6
BECOME 6
BEFORE 6
BEGIN 5
BEHALF 6
BETWEEN 7
BFILE 5
BINDING 7
BITMAP 6
BITS 4
BLOB 4
BLOCK 5
BLOCKSIZE 9
BLOCK_RANGE 11
BODY 4
BOUND 5
BOTH 4
BROADCAST 9
KEYWORD LENGTH
---------------------------------------------------------------- ----------
BUFFER_POOL 11
BUILD 5
BULK 4
BY 2
BYTE 4
CACHE 5
CACHE_INSTANCES 15
CALL 4
CANCEL 6
CASCADE 7
CASE 4
CAST 4
CATEGORY 8
CERTIFICATE 11
CFILE 5
CHAINED 7
CHANGE 6
CHAR 4
CHAR_CS 7
CHARACTER 9
CHECK 5
KEYWORD LENGTH
---------------------------------------------------------------- ----------
CHECKPOINT 10
CHILD 5
CHOOSE 6
CHUNK 5
CLASS 5
CLEAR 5
CLOB 4
CLONE 5
CLOSE 5
CLOSE_CACHED_OPEN_CURSORS 25
CLUSTER 7
COALESCE 8
COLLECT 7
COLUMN 6
COLUMNS 7
COLUMN_VALUE 12
COMMENT 7
COMMIT 6
COMMITTED 9
COMPATIBILITY 13
COMPILE 7
KEYWORD LENGTH
---------------------------------------------------------------- ----------
COMPLETE 8
COMPOSITE_LIMIT 15
COMPRESS 8
COMPUTE 7
CONFORMING 10
CONNECT 7
CONNECT_TIME 12
CONSIDER 8
CONSISTENT 10
CONSTRAINT 10
CONSTRAINTS 11
CONTAINER 9
CONTENTS 8
CONTEXT 7
CONTINUE 8
CONTROLFILE 11
CONVERT 7
CORRUPTION 10
COST 4
CPU_PER_CALL 12
CPU_PER_SESSION 15
KEYWORD LENGTH
---------------------------------------------------------------- ----------
CREATE 6
CREATE_STORED_OUTLINES 22
CROSS 5
CUBE 4
CURRENT 7
CURRENT_DATE 12
CURRENT_SCHEMA 14
CURRENT_TIME 12
CURRENT_TIMESTAMP 17
CURRENT_USER 12
CURSOR 6
CURSOR_SPECIFIC_SEGMENT 23
CYCLE 5
DANGLING 8
DATA 4
DATABASE 8
DATAFILE 8
DATAFILES 9
DATAOBJNO 9
DATE 4
DATE_MODE 9
KEYWORD LENGTH
---------------------------------------------------------------- ----------
DAY 3
DBA 3
DBTIMEZONE 10
DDL 3
DEALLOCATE 10
DEBUG 5
DEC 3
DECIMAL 7
DECLARE 7
DEFAULT 7
DEFERRABLE 10
DEFERRED 8
DEFINED 7
DEFINER 7
DEGREE 6
DELAY 5
DELETE 6
DEMAND 6
DENSE_RANK 10
ROWDEPENDENCIES 15
DEREF 5
KEYWORD LENGTH
---------------------------------------------------------------- ----------
DESC 4
DETACHED 8
DETERMINES 10
DICTIONARY 10
DIMENSION 9
DIRECTORY 9
DISABLE 7
DISASSOCIATE 12
DISCONNECT 10
DISK 4
DISKGROUP 9
DISKS 5
DISMOUNT 8
DISPATCHERS 11
DISTINCT 8
DISTINGUISHED 13
DISTRIBUTED 11
DML 3
DOUBLE 6
DROP 4
DUMP 4
KEYWORD LENGTH
---------------------------------------------------------------- ----------
DYNAMIC 7
EACH 4
ELEMENT 7
ELSE 4
ENABLE 6
ENCRYPTED 9
ENCRYPTION 10
END 3
ENFORCE 7
ENTRY 5
ERROR_ON_OVERLAP_TIME 21
ESCAPE 6
ESTIMATE 8
EVENTS 6
EXCEPT 6
EXCEPTIONS 10
EXCHANGE 8
EXCLUDING 9
EXCLUSIVE 9
EXECUTE 7
EXEMPT 6
KEYWORD LENGTH
---------------------------------------------------------------- ----------
EXISTS 6
EXPIRE 6
EXPLAIN 7
EXPLOSION 9
EXTEND 6
EXTENDS 7
EXTENT 6
EXTENTS 7
EXTERNAL 8
EXTERNALLY 10
EXTRACT 7
FAILED_LOGIN_ATTEMPTS 21
FAILGROUP 9
FALSE 5
FAST 4
FILE 4
FILTER 6
FINAL 5
FINISH 6
FIRST 5
FIRST_ROWS 10
KEYWORD LENGTH
---------------------------------------------------------------- ----------
FLAGGER 7
FLASHBACK 9
FLOAT 5
FLOB 4
FLUSH 5
FOLLOWING 9
FOR 3
FORCE 5
FOREIGN 7
FREELIST 8
FREELISTS 9
FREEPOOLS 9
FRESH 5
FROM 4
FULL 4
FUNCTION 8
FUNCTIONS 9
GENERATED 9
GLOBAL 6
GLOBALLY 8
GLOBAL_NAME 11
KEYWORD LENGTH
---------------------------------------------------------------- ----------
GLOBAL_TOPIC_ENABLED 20
GRANT 5
GROUP 5
GROUPING 8
GROUPS 6
GUARANTEED 10
GUARD 5
HASH 4
HASHKEYS 8
HAVING 6
HEADER 6
HEAP 4
HIERARCHY 9
HOUR 4
ID 2
IDENTIFIED 10
IDENTIFIER 10
IDGENERATORS 12
IDLE_TIME 9
IF 2
IMMEDIATE 9
KEYWORD LENGTH
---------------------------------------------------------------- ----------
IN 2
INCLUDING 9
INCREMENT 9
INCREMENTAL 11
INDEX 5
INDEXED 7
INDEXES 7
INDEXTYPE 9
INDEXTYPES 10
INDICATOR 9
INITIAL 7
INITIALIZED 11
INITIALLY 9
INITRANS 8
INNER 5
INSERT 6
INSTANCE 8
INSTANCES 9
INSTANTIABLE 12
INSTANTLY 9
INSTEAD 7
KEYWORD LENGTH
---------------------------------------------------------------- ----------
INT 3
INTEGER 7
INTEGRITY 9
INTERMEDIATE 12
INTERNAL_USE 12
INTERNAL_CONVERT 16
INTERSECT 9
INTERVAL 8
INTO 4
INVALIDATE 10
IN_MEMORY_METADATA 18
IS 2
ISOLATION 9
ISOLATION_LEVEL 15
JAVA 4
JOIN 4
KEEP 4
KERBEROS 8
KEY 3
KEYFILE 7
KEYS 4
KEYWORD LENGTH
---------------------------------------------------------------- ----------
KEYSIZE 7
REKEY 5
KILL 4
<< 2
LAST 4
LATERAL 7
LAYER 5
LDAP_REGISTRATION 17
LDAP_REGISTRATION_ENABLED 25
LDAP_REG_SYNC_INTERVAL 22
LEADING 7
LEFT 4
LESS 4
LEVEL 5
LEVELS 6
LIBRARY 7
LIKE 4
LIKE2 5
LIKE4 5
LIKEC 5
LIMIT 5
KEYWORD LENGTH
---------------------------------------------------------------- ----------
LINK 4
LIST 4
LOB 3
LOCAL 5
LOCALTIME 9
LOCALTIMESTAMP 14
LOCATION 8
LOCATOR 7
LOCK 4
LOCKED 6
LOG 3
LOGFILE 7
LOGGING 7
LOGICAL 7
LOGICAL_READS_PER_CALL 22
LOGICAL_READS_PER_SESSION 25
LOGOFF 6
LOGON 5
LONG 4
MANAGE 6
MANAGED 7
KEYWORD LENGTH
---------------------------------------------------------------- ----------
MANAGEMENT 10
MANUAL 6
MAPPING 7
MASTER 6
MATERIALIZED 12
MATCHED 7
MAX 3
MAXARCHLOGS 11
MAXDATAFILES 12
MAXEXTENTS 10
MAXIMIZE 8
MAXINSTANCES 12
MAXLOGFILES 11
MAXLOGHISTORY 13
MAXLOGMEMBERS 13
MAXSIZE 7
MAXTRANS 8
MAXVALUE 8
METHOD 6
MIN 3
MEMBER 6
KEYWORD LENGTH
---------------------------------------------------------------- ----------
MEMORY 6
MERGE 5
MIGRATE 7
MINIMIZE 8
MINIMUM 7
MINEXTENTS 10
MINUS 5
MINUTE 6
MINVALUE 8
MIRROR 6
MLSLABEL 8
MODE 4
MODIFY 6
MONITORING 10
MONTH 5
MOUNT 5
MOVE 4
MOVEMENT 8
MTS_DISPATCHERS 15
MULTISET 8
NAME 4
KEYWORD LENGTH
---------------------------------------------------------------- ----------
NAMED 5
NATIONAL 8
NATURAL 7
NCHAR 5
NCHAR_CS 8
NCLOB 5
NEEDED 6
NESTED 6
NESTED_TABLE_ID 15
NETWORK 7
NEVER 5
NEW 3
NEXT 4
NLS_CALENDAR 12
NLS_CHARACTERSET 16
NLS_COMP 8
NLS_NCHAR_CONV_EXCP 19
NLS_CURRENCY 12
NLS_DATE_FORMAT 15
NLS_DATE_LANGUAGE 17
NLS_ISO_CURRENCY 16
KEYWORD LENGTH
---------------------------------------------------------------- ----------
NLS_LANG 8
NLS_LANGUAGE 12
NLS_LENGTH_SEMANTICS 20
NLS_NUMERIC_CHARACTERS 22
NLS_SORT 8
NLS_SPECIAL_CHARS 17
NLS_TERRITORY 13
NO 2
NOARCHIVELOG 12
NOAUDIT 7
NOCACHE 7
NOCOMPRESS 10
NOCYCLE 7
NOROWDEPENDENCIES 17
NODELAY 7
NOFORCE 7
NOLOGGING 9
NOMAPPING 9
NOMAXVALUE 10
NOMINIMIZE 10
NOMINVALUE 10
KEYWORD LENGTH
---------------------------------------------------------------- ----------
NOMONITORING 12
NONE 4
NOORDER 7
NOOVERRIDE 10
NOPARALLEL 10
NORELY 6
NOREPAIR 8
NORESETLOGS 11
NOREVERSE 9
NORMAL 6
NOSEGMENT 9
NOSTRICT 8
NOSTRIPE 8
NOSORT 6
NOSWITCH 8
NOT 3
NOTHING 7
NOVALIDATE 10
NOWAIT 6
NULL 4
NULLS 5
KEYWORD LENGTH
---------------------------------------------------------------- ----------
NUMBER 6
NUMERIC 7
NVARCHAR2 9
OBJECT 6
OBJNO 5
OBJNO_REUSE 11
OF 2
OFF 3
OFFLINE 7
OID 3
OIDINDEX 8
OLD 3
ON 2
ONLINE 6
ONLY 4
OPAQUE 6
OPCODE 6
OPEN 4
OPERATOR 8
OPTIMAL 7
OPTIMIZER_GOAL 14
KEYWORD LENGTH
---------------------------------------------------------------- ----------
OPTION 6
OR 2
ORDER 5
ORGANIZATION 12
OUTER 5
OUTLINE 7
OVER 4
OVERFLOW 8
OVERLAPS 8
OWN 3
PACKAGE 7
PACKAGES 8
PARALLEL 8
PARAMETERS 10
PARENT 6
PARITY 6
PARTIALLY 9
PARTITION 9
PARTITIONS 10
PARTITION_HASH 14
PARTITION_LIST 14
KEYWORD LENGTH
---------------------------------------------------------------- ----------
PARTITION_RANGE 15
PASSWORD 8
PASSWORD_GRACE_TIME 19
PASSWORD_LIFE_TIME 18
PASSWORD_LOCK_TIME 18
PASSWORD_REUSE_MAX 18
PASSWORD_REUSE_TIME 19
PASSWORD_VERIFY_FUNCTION 24
PCTFREE 7
PCTINCREASE 11
PCTTHRESHOLD 12
PCTUSED 7
PCTVERSION 10
PERCENT 7
PERFORMANCE 11
PERMANENT 9
PFILE 5
PHYSICAL 8
PLAN 4
PLSQL_DEBUG 11
POLICY 6
KEYWORD LENGTH
---------------------------------------------------------------- ----------
POST_TRANSACTION 16
PREBUILT 8
PRECEDING 9
PRECISION 9
PREPARE 7
PRESERVE 8
PRIMARY 7
PRIOR 5
PRIVATE 7
PRIVATE_SGA 11
PRIVILEGE 9
PRIVILEGES 10
PROCEDURE 9
PROFILE 7
PROTECTED 9
PROTECTION 10
PUBLIC 6
PURGE 5
PX_GRANULE 10
QUERY 5
QUEUE 5
KEYWORD LENGTH
---------------------------------------------------------------- ----------
QUIESCE 7
QUOTA 5
RANDOM 6
RANGE 5
RAPIDLY 7
RAW 3
RBA 3
READ 4
READS 5
REAL 4
REBALANCE 9
REBUILD 7
RECORDS_PER_BLOCK 17
RECOVER 7
RECOVERABLE 11
RECOVERY 8
RECYCLE 7
REDUCED 7
REF 3
REFERENCES 10
REFERENCING 11
KEYWORD LENGTH
---------------------------------------------------------------- ----------
REFRESH 7
REGISTER 8
REJECT 6
RELATIONAL 10
RELY 4
RENAME 6
REPAIR 6
REPLACE 7
RESET 5
RESETLOGS 9
RESIZE 6
RESOLVE 7
RESOLVER 8
RESOURCE 8
RESTRICT 8
RESTRICTED 10
RESUMABLE 9
RESUME 6
RETENTION 9
RETURN 6
RETURNING 9
KEYWORD LENGTH
---------------------------------------------------------------- ----------
REUSE 5
REVERSE 7
REVOKE 6
REWRITE 7
RIGHT 5
ROLE 4
ROLES 5
ROLLBACK 8
ROLLUP 6
ROW 3
ROWID 5
ROWNUM 6
ROWS 4
RULE 4
SAMPLE 6
SAVEPOINT 9
SB4 3
SCAN 4
SCAN_INSTANCES 14
SCHEMA 6
SCN 3
KEYWORD LENGTH
---------------------------------------------------------------- ----------
SCOPE 5
SD_ALL 6
SD_INHIBIT 10
SD_SHOW 7
SECOND 6
SECURITY 8
SEGMENT 7
SEG_BLOCK 9
SEG_FILE 8
SELECT 6
SELECTIVITY 11
SEQUENCE 8
SEQUENCED 9
SERIALIZABLE 12
SERVERERROR 11
SESSION 7
SESSION_CACHED_CURSORS 22
SESSIONS_PER_USER 17
SESSIONTIMEZONE 15
SESSIONTZNAME 13
SET 3
KEYWORD LENGTH
---------------------------------------------------------------- ----------
SETS 4
SETTINGS 8
SHARE 5
SHARED 6
SHARED_POOL 11
SHRINK 6
SHUTDOWN 8
SIBLINGS 8
SID 3
SINGLE 6
SINGLETASK 10
SIMPLE 6
SIZE 4
SKIP 4
SKIP_UNUSABLE_INDEXES 21
SMALLINT 8
SNAPSHOT 8
SOME 4
SORT 4
SOURCE 6
SPACE 5
KEYWORD LENGTH
---------------------------------------------------------------- ----------
SPECIFICATION 13
SPFILE 6
SPLIT 5
SQL_TRACE 9
STANDBY 7
START 5
STARTUP 7
STATEMENT_ID 12
STATISTICS 10
STATIC 6
STOP 4
STORAGE 7
STORE 5
STRIPE 6
STRICT 6
STRUCTURE 9
SUBPARTITION 12
SUBPARTITIONS 13
SUBPARTITION_REL 16
SUBSTITUTABLE 13
SUCCESSFUL 10
KEYWORD LENGTH
---------------------------------------------------------------- ----------
SUMMARY 7
SUSPEND 7
SUPPLEMENTAL 12
SWITCH 6
SWITCHOVER 10
SYS_OP_BITVEC 13
SYS_OP_COL_PRESENT 18
SYS_OP_ENFORCE_NOT_NULL$ 24
SYS_OP_MINE_VALUE 17
SYS_OP_NOEXPAND 15
SYS_OP_NTCIMG$ 14
SYNONYM 7
SYSDATE 7
SYSDBA 6
SYSOPER 7
SYSTEM 6
SYSTIMESTAMP 12
TABLE 5
TABLES 6
TABLESPACE 10
TABLESPACE_NO 13
KEYWORD LENGTH
---------------------------------------------------------------- ----------
TABNO 5
TEMPFILE 8
TEMPLATE 8
TEMPORARY 9
TEST 4
THAN 4
THE 3
THEN 4
THREAD 6
THROUGH 7
TIMESTAMP 9
TIME 4
TIMEOUT 7
TIMEZONE_ABBR 13
TIMEZONE_HOUR 13
TIMEZONE_MINUTE 15
TIMEZONE_REGION 15
TIME_ZONE 9
TO 2
TOPLEVEL 8
TRACE 5
KEYWORD LENGTH
---------------------------------------------------------------- ----------
TRACING 7
TRAILING 8
TRANSACTION 11
TRANSITIONAL 12
TREAT 5
TRIGGER 7
TRIGGERS 8
TRUE 4
TRUNCATE 8
TX 2
TYPE 4
TYPES 5
TZ_OFFSET 9
UB2 3
UBA 3
UID 3
UNARCHIVED 10
UNBOUND 7
UNBOUNDED 9
UNDER 5
UNDO 4
KEYWORD LENGTH
---------------------------------------------------------------- ----------
UNDROP 6
UNIFORM 7
UNION 5
UNIQUE 6
UNLIMITED 9
UNLOCK 6
UNPACKED 8
UNPROTECTED 11
UNQUIESCE 9
UNRECOVERABLE 13
UNTIL 5
UNUSABLE 8
UNUSED 6
UPD_INDEXES 11
UPD_JOININDEX 13
UPDATABLE 9
UPDATE 6
UPGRADE 7
UROWID 6
USAGE 5
USE 3
KEYWORD LENGTH
---------------------------------------------------------------- ----------
USE_PRIVATE_OUTLINES 20
USE_STORED_OUTLINES 19
USER 4
USER_DEFINED 12
USING 5
VALIDATE 8
VALIDATION 10
VALUE 5
VALUES 6
VARCHAR 7
VARCHAR2 8
VARRAY 6
VARYING 7
VERSION 7
VIEW 4
WAIT 4
WHEN 4
WHENEVER 8
WHERE 5
WITH 4
WITHIN 6
KEYWORD LENGTH
---------------------------------------------------------------- ----------
WITHOUT 7
WORK 4
WRITE 5
XMLATTRIBUTES 13
XMLCOLATTVAL 12
XMLELEMENT 10
XMLFOREST 9
XMLTYPE 7
XMLSCHEMA 9
XID 3
YEAR 4
ZONE 4
809 rows selected
- oracle9i关键字一览
- 的保留关键字一览
- SQLServer的保留关键字一览
- oracle9I
- SQL Server 的保留关键字一览
- SQL Server 的保留关键字一览
- SQL Server 的保留关键字一览
- oracle9i卸载(Winxp+oracle9i)
- 安装oracle9i
- 正版oracle9i
- oracle9i数据类型
- 卸载oracle9i
- 安装ORACLE9I
- oracle9i配置
- Oracle9i 下载
- 安装oracle9i
- 卸载Oracle9i
- oracle9i安装
- 深入浅出MFC文档/视图架构之文档(1)
- 深入浅出MFC文档/视图架构之文档(2)
- 丢掉IT工作后14件可以做的事情
- auto_ptr作用和用法
- 深入浅出MFC文档/视图架构之文档模板(1)
- oracle9i关键字一览
- 深入浅出MFC文档/视图架构之文档模板(2)
- 技术是福是祸
- 深入浅出MFC文档/视图架构之文档模板(3)
- 浮点数的内存结构
- 软件工程与工业工程
- 深入浅出MFC文档/视图架构之文档模板(4)
- 让web应用实现无刷新数据交互-基于iframe实现
- 深入浅出MFC文档/视图架构之框架(1)