.Oracle 关键字(保留字) 大全

rdfszazvvo

Oracle 关键字(保留字) 大全
其实这个东西可以在oracle 上输入一个sql语句就可以得到：select * from v$reserved_words order by keyword asc;   //order 后边不是必须的，那只是个排序，使结果不至于杂乱无章，如果用的是PL/SQL的话的SQL window的话，在获得结果后，可以点击    按钮，使得查询结果不分页，然后可以 右击结果区空白处--->Export results--->Html file(推荐这个，其他格式也行)，这样就不用每次想看，都得打开oracle 和 PL/SQL 临时获得了。
差点忘了，必须是DBA账户才可以，DataBase Administrator 。
如果你只是想了解 一下理论知识，或者身边没有oracle这个环境，但是就是想知道，下边是我运行oracle 10 得到的结果：
KEYWORDLENGTH1!12&13(14)15*16+17,18-19.110/111:112<113<<214=115>116@117A118ABORT519ACCESS620ACCESSED821ACCOUNT722ACTIVATE823ADD324ADMIN525ADMINISTER1026ADMINISTRATOR1327ADVISE628ADVISOR729AFTER530ALGORITHM931ALIAS532ALL333ALLOCATE834ALLOW535ALL_ROWS836ALTER537ALWAYS638ANALYZE739ANCILLARY940AND341AND_EQUAL942ANTIJOIN843ANY344APPEND645APPLY546ARCHIVE747ARCHIVELOG1048ARRAY549AS250ASC351ASSOCIATE952AT253ATTRIBUTE954ATTRIBUTES1055AUDIT556AUTHENTICATED1357AUTHENTICATION1458AUTHID659AUTHORIZATION1360AUTO461AUTOALLOCATE1262AUTOEXTEND1063AUTOMATIC964AVAILABILITY1265BACKUP666BECOME667BEFORE668BEGIN569BEHALF670BETWEEN771BFILE572BIGFILE773BINARY_DOUBLE1374BINARY_DOUBLE_INFINITY2275BINARY_DOUBLE_NAN1776BINARY_FLOAT1277BINARY_FLOAT_INFINITY2178BINARY_FLOAT_NAN1679BINDING780BITMAP681BITS482BLOB483BLOCK584BLOCKS685BLOCKSIZE986BLOCK_RANGE1187BODY488BOTH489BOUND590BROADCAST991BUFFER692BUFFER_CACHE1293BUFFER_POOL1194BUILD595BULK496BY297BYPASS_RECURSIVE_CHECK2298BYPASS_UJVC1199BYTE4100CACHE5101CACHE_CB8102CACHE_INSTANCES15103CACHE_TEMP_TABLE16104CALL4105CANCEL6106CARDINALITY11107CASCADE7108CASE4109CAST4110CATEGORY8111CERTIFICATE11112CFILE5113CHAINED7114CHANGE6115CHAR4116CHARACTER9117CHAR_CS7118CHECK5119CHECKPOINT10120CHILD5121CHOOSE6122CHUNK5123CIV_GB6124CLASS5125CLEAR5126CLOB4127CLONE5128CLOSE5129CLOSE_CACHED_OPEN_CURSORS25130CLUSTER7131CLUSTERING_FACTOR17132COALESCE8133COARSE6134COLLECT7135COLLECTIONS_GET_REFS20136COLUMN6137COLUMNS7138COLUMN_STATS12139COLUMN_VALUE12140COMMENT7141COMMIT6142COMMITTED9143COMPACT7144COMPATIBILITY13145COMPILE7146COMPLETE8147COMPOSITE_LIMIT15148COMPRESS8149COMPUTE7150CONFORMING10151CONNECT7152CONNECT_BY_ISCYCLE18153CONNECT_BY_ISLEAF17154CONNECT_BY_ROOT15155CONNECT_TIME12156CONSIDER8157CONSISTENT10158CONSTRAINT10159CONSTRAINTS11160CONTAINER9161CONTENT7162CONTENTS8163CONTEXT7164CONTINUE8165CONTROLFILE11166CONVERT7167CORRUPTION10168COST4169CPU_COSTING11170CPU_PER_CALL12171CPU_PER_SESSION15172CREATE6173CREATE_STORED_OUTLINES22174CROSS5175CUBE4176CUBE_GB7177CURRENT7178CURRENT_DATE12179CURRENT_SCHEMA14180CURRENT_TIME12181CURRENT_TIMESTAMP17182CURRENT_USER12183CURSOR6184CURSOR_SHARING_EXACT20185CURSOR_SPECIFIC_SEGMENT23186CYCLE5187DANGLING8188DATA4189DATABASE8190DATAFILE8191DATAFILES9192DATAOBJNO9193DATE4194DATE_MODE9195DAY3196DBA3197DBA_RECYCLEBIN14198DBTIMEZONE10199DDL3200DEALLOCATE10201DEBUG5202DEC3203DECIMAL7204DECLARE7205DECREMENT9206DEFAULT7207DEFERRABLE10208DEFERRED8209DEFINED7210DEFINER7211DEGREE6212DELAY5213DELETE6214DEMAND6215DENSE_RANK10216DEREF5217DEREF_NO_REWRITE16218DESC4219DETACHED8220DETERMINES10221DICTIONARY10222DIMENSION9223DIRECTORY9224DISABLE7225DISASSOCIATE12226DISCONNECT10227DISK4228DISKGROUP9229DISKS5230DISMOUNT8231DISTINCT8232DISTINGUISHED13233DISTRIBUTED11234DML3235DML_UPDATE10236DOCUMENT8237DOMAIN_INDEX_NO_SORT20238DOMAIN_INDEX_SORT17239DOUBLE6240DOWNGRADE9241DRIVING_SITE12242DROP4243DUMP4244DYNAMIC7245DYNAMIC_SAMPLING16246DYNAMIC_SAMPLING_EST_CDN24247EACH4248ELEMENT7249ELSE4250EMPTY5251ENABLE6252ENCRYPTED9253ENCRYPTION10254END3255ENFORCE7256ENFORCED8257ENTRY5258ERROR5259ERROR_ON_OVERLAP_TIME21260ESCAPE6261ESTIMATE8262EVENTS6263EXCEPT6264EXCEPTIONS10265EXCHANGE8266EXCLUDING9267EXCLUSIVE9268EXECUTE7269EXEMPT6270EXISTS6271EXPAND_GSET_TO_UNION20272EXPIRE6273EXPLAIN7274EXPLOSION9275EXPORT6276EXPR_CORR_CHECK15277EXTEND6278EXTENDS7279EXTENT6280EXTENTS7281EXTERNAL8282EXTERNALLY10283EXTRACT7284FACT4285FAILED6286FAILED_LOGIN_ATTEMPTS21287FAILGROUP9288FALSE5289FAST4290FBTSCAN7291FIC_CIV7292FIC_PIV7293FILE4294FILTER6295FINAL5296FINE4297FINISH6298FIRST5299FIRST_ROWS10300FLAGGER7301FLASHBACK9302FLOAT5303FLOB4304FLUSH5305FOLLOWING9306FOR3307FORCE5308FORCE_XML_QUERY_REWRITE23309FOREIGN7310FREELIST8311FREELISTS9312FREEPOOLS9313FRESH5314FROM4315FULL4316FUNCTION8317FUNCTIONS9318GATHER_PLAN_STATISTICS22319GBY_CONC_ROLLUP15320GENERATED9321GLOBAL6322GLOBALLY8323GLOBAL_NAME11324GLOBAL_TOPIC_ENABLED20325GRANT5326GROUP5327GROUPING8328GROUPS6329GROUP_BY8330GUARANTEE9331GUARANTEED10332GUARD5333HASH4334HASHKEYS8335HASH_AJ7336HASH_SJ7337HAVING6338HEADER6339HEAP4340HIERARCHY9341HIGH4342HINTSET_BEGIN13343HINTSET_END11344HOUR4345HWM_BROKERED12346ID2347IDENTIFIED10348IDENTIFIER10349IDENTITY8350IDGENERATORS12351IDLE_TIME9352IF2353IGNORE6354IGNORE_ON_CLAUSE16355IGNORE_OPTIM_EMBEDDED_HINTS27356IGNORE_WHERE_CLAUSE19357IMMEDIATE9358IMPORT6359IN2360INCLUDE_VERSION15361INCLUDING9362INCREMENT9363INCREMENTAL11364INDEX5365INDEXED7366INDEXES7367INDEXTYPE9368INDEXTYPES10369INDEX_ASC9370INDEX_COMBINE13371INDEX_DESC10372INDEX_FFS9373INDEX_FILTER12374INDEX_JOIN10375INDEX_ROWS10376INDEX_RRS9377INDEX_SCAN10378INDEX_SKIP_SCAN15379INDEX_SS8380INDEX_SS_ASC12381INDEX_SS_DESC13382INDEX_STATS11383INDICATOR9384INFINITE8385INFORMATIONAL13386INITIAL7387INITIALIZED11388INITIALLY9389INITRANS8390INLINE6391INNER5392INSERT6393INSTANCE8394INSTANCES9395INSTANTIABLE12396INSTANTLY9397INSTEAD7398INT3399INTEGER7400INTEGRITY9401INTERMEDIATE12402INTERNAL_CONVERT16403INTERNAL_USE12404INTERPRETED11405INTERSECT9406INTERVAL8407INTO4408INVALIDATE10409IN_MEMORY_METADATA18410IS2411ISOLATION9412ISOLATION_LEVEL15413ITERATE7414ITERATION_NUMBER16415JAVA4416JOB3417JOIN4418KEEP4419KERBEROS8420KEY3421KEYFILE7422KEYS4423KEYSIZE7424KEY_LENGTH10425KILL4426LAST4427LATERAL7428LAYER5429LDAP_REGISTRATION17430LDAP_REGISTRATION_ENABLED25431LDAP_REG_SYNC_INTERVAL22432LEADING7433LEFT4434LENGTH6435LESS4436LEVEL5437LEVELS6438LIBRARY7439LIKE4440LIKE25441LIKE45442LIKEC5443LIKE_EXPAND11444LIMIT5445LINK4446LIST4447LOB3448LOCAL5449LOCALTIME9450LOCALTIMESTAMP14451LOCAL_INDEXES13452LOCATION8453LOCATOR7454LOCK4455LOCKED6456LOG3457LOGFILE7458LOGGING7459LOGICAL7460LOGICAL_READS_PER_CALL22461LOGICAL_READS_PER_SESSION25462LOGOFF6463LOGON5464LONG4465MAIN4466MANAGE6467MANAGED7468MANAGEMENT10469MANUAL6470MAPPING7471MASTER6472MATCHED7473MATERIALIZE11474MATERIALIZED12475MAX3476MAXARCHLOGS11477MAXDATAFILES12478MAXEXTENTS10479MAXIMIZE8480MAXINSTANCES12481MAXLOGFILES11482MAXLOGHISTORY13483MAXLOGMEMBERS13484MAXSIZE7485MAXTRANS8486MAXVALUE8487MEASURES8488MEMBER6489MEMORY6490MERGE5491MERGE_AJ8492MERGE_CONST_ON14493MERGE_SJ8494METHOD6495MIGRATE7496MIN3497MINEXTENTS10498MINIMIZE8499MINIMUM7500MINUS5501MINUTE6502MINVALUE8503MIRROR6504MLSLABEL8505MODE4506MODEL5507MODEL_DONTVERIFY_UNIQUENESS27508MODEL_MIN_ANALYSIS18509MODEL_NO_ANALYSIS17510MODEL_PBY9511MODEL_PUSH_REF14512MODIFY6513MONITORING10514MONTH5515MOUNT5516MOVE4517MOVEMENT8518MULTISET8519MV_MERGE8520NAME4521NAMED5522NAN3523NATIONAL8524NATIVE6525NATURAL7526NAV3527NCHAR5528NCHAR_CS8529NCLOB5530NEEDED6531NESTED6532NESTED_TABLE_FAST_INSERT24533NESTED_TABLE_GET_REFS21534NESTED_TABLE_ID15535NESTED_TABLE_SET_REFS21536NESTED_TABLE_SET_SETID22537NETWORK7538NEVER5539NEW3540NEXT4541NLS_CALENDAR12542NLS_CHARACTERSET16543NLS_COMP8544NLS_CURRENCY12545NLS_DATE_FORMAT15546NLS_DATE_LANGUAGE17547NLS_ISO_CURRENCY16548NLS_LANG8549NLS_LANGUAGE12550NLS_LENGTH_SEMANTICS20551NLS_NCHAR_CONV_EXCP19552NLS_NUMERIC_CHARACTERS22553NLS_SORT8554NLS_SPECIAL_CHARS17555NLS_TERRITORY13556NL_AJ5557NL_SJ5558NO2559NOAPPEND8560NOARCHIVELOG12561NOAUDIT7562NOCACHE7563NOCOMPRESS10564NOCPU_COSTING13565NOCYCLE7566NODELAY7567NOFORCE7568NOGUARANTEE11569NOLOGGING9570NOMAPPING9571NOMAXVALUE10572NOMINIMIZE10573NOMINVALUE10574NOMONITORING12575NONE4576NOORDER7577NOOVERRIDE10578NOPARALLEL10579NOPARALLEL_INDEX16580NORELY6581NOREPAIR8582NORESETLOGS11583NOREVERSE9584NOREWRITE9585NORMAL6586NOROWDEPENDENCIES17587NOSEGMENT9588NOSORT6589NOSTRICT8590NOSWITCH8591NOT3592NOTHING7593NOVALIDATE10594NOWAIT6595NO_ACCESS9596NO_BASETABLE_MULTIMV_REWRITE28597NO_BUFFER9598NO_CPU_COSTING14599NO_EXPAND9600NO_EXPAND_GSET_TO_UNION23601NO_FACT7602NO_FILTERING12603NO_INDEX8604NO_INDEX_FFS12605NO_INDEX_SS11606NO_MERGE8607NO_MODEL_PUSH_REF17608NO_MONITORING13609NO_MULTIMV_REWRITE18610NO_ORDER_ROLLUPS16611NO_PARALLEL11612NO_PARALLEL_INDEX17613NO_PARTIAL_COMMIT17614NO_PRUNE_GSETS14615NO_PUSH_PRED12616NO_PUSH_SUBQ12617NO_QKN_BUFF11618NO_QUERY_TRANSFORMATION23619NO_REF_CASCADE14620NO_REWRITE10621NO_SEMIJOIN11622NO_SET_TO_JOIN14623NO_STAR_TRANSFORMATION22624NO_STATS_GSETS14625NO_SWAP_JOIN_INPUTS19626NO_TRIGGER10627NO_UNNEST9628NO_USE_HASH11629NO_USE_MERGE12630NO_USE_NL9631NO_XML_QUERY_REWRITE20632NULL4633NULLS5634NUMBER6635NUMERIC7636NVARCHAR29637OBJECT6638OBJNO5639OBJNO_REUSE11640OF2641OFF3642OFFLINE7643OID3644OIDINDEX8645OLD3646ON2647ONLINE6648ONLY4649OPAQUE6650OPAQUE_TRANSFORM16651OPAQUE_XCANONICAL17652OPCODE6653OPEN4654OPERATOR8655OPTIMAL7656OPTIMIZER_FEATURES_ENABLE25657OPTIMIZER_GOAL14658OPTION6659OPT_ESTIMATE12660OR2661ORA_ROWSCN10662ORDER5663ORDERED7664ORDERED_PREDICATES18665ORGANIZATION12666OR_EXPAND9667OUTER5668OUTLINE7669OUT_OF_LINE11670OVER4671OVERFLOW8672OVERFLOW_NOMOVE15673OVERLAPS8674OWN3675PACKAGE7676PACKAGES8677PARALLEL8678PARALLEL_INDEX14679PARAMETERS10680PARENT6681PARITY6682PARTIALLY9683PARTITION9684PARTITIONS10685PARTITION_HASH14686PARTITION_LIST14687PARTITION_RANGE15688PASSWORD8689PASSWORD_GRACE_TIME19690PASSWORD_LIFE_TIME18691PASSWORD_LOCK_TIME18692PASSWORD_REUSE_MAX18693PASSWORD_REUSE_TIME19694PASSWORD_VERIFY_FUNCTION24695PCTFREE7696PCTINCREASE11697PCTTHRESHOLD12698PCTUSED7699PCTVERSION10700PERCENT7701PERFORMANCE11702PERMANENT9703PFILE5704PHYSICAL8705PIV_GB6706PIV_SSF7707PLAN4708PLSQL_CODE_TYPE15709PLSQL_DEBUG11710PLSQL_OPTIMIZE_LEVEL20711PLSQL_WARNINGS14712POLICY6713POST_TRANSACTION16714POWER5715PQ_DISTRIBUTE13716PQ_MAP6717PQ_NOMAP8718PREBUILT8719PRECEDING9720PRECISION9721PREPARE7722PRESENT7723PRESERVE8724PRIMARY7725PRIOR5726PRIVATE7727PRIVATE_SGA11728PRIVILEGE9729PRIVILEGES10730PROCEDURE9731PROFILE7732PROGRAM7733PROJECT7734PROTECTED9735PROTECTION10736PUBLIC6737PURGE5738PUSH_PRED9739PUSH_SUBQ9740PX_GRANULE10741QB_NAME7742QUERY5743QUERY_BLOCK11744QUEUE5745QUEUE_CURR10746QUEUE_ROWP10747QUIESCE7748QUOTA5749RANDOM6750RANGE5751RAPIDLY7752RAW3753RBA3754READ4755READS5756REAL4757REBALANCE9758REBUILD7759RECORDS_PER_BLOCK17760RECOVER7761RECOVERABLE11762RECOVERY8763RECYCLE7764RECYCLEBIN10765REDUCED7766REDUNDANCY10767REF3768REFERENCE9769REFERENCED10770REFERENCES10771REFERENCING11772REFRESH7773REF_CASCADE_CURSOR18774REGEXP_LIKE11775REGISTER8776REJECT6777REKEY5778RELATIONAL10779RELY4780REMOTE_MAPPED13781RENAME6782REPAIR6783REPLACE7784REQUIRED8785RESET5786RESETLOGS9787RESIZE6788RESOLVE7789RESOLVER8790RESOURCE8791RESTORE_AS_INTERVALS20792RESTRICT8793RESTRICTED10794RESTRICT_ALL_REF_CONS21795RESUMABLE9796RESUME6797RETENTION9798RETURN6799RETURNING9800REUSE5801REVERSE7802REVOKE6803REWRITE7804REWRITE_OR_ERROR16805RIGHT5806ROLE4807ROLES5808ROLLBACK8809ROLLUP6810ROW3811ROWDEPENDENCIES15812ROWID5813ROWNUM6814ROWS4815ROW_LENGTH10816RULE4817RULES5818SAMPLE6819SAVEPOINT9820SAVE_AS_INTERVALS17821SB43822SCALE5823SCALE_ROWS10824SCAN4825SCAN_INSTANCES14826SCHEDULER9827SCHEMA6828SCN3829SCN_ASCENDING13830SCOPE5831SD_ALL6832SD_INHIBIT10833SD_SHOW7834SECOND6835SECURITY8836SEED4837SEGMENT7838SEG_BLOCK9839SEG_FILE8840SELECT6841SELECTIVITY11842SEMIJOIN8843SEMIJOIN_DRIVER15844SEQUENCE8845SEQUENCED9846SEQUENTIAL10847SERIALIZABLE12848SERVERERROR11849SESSION7850SESSIONS_PER_USER17851SESSIONTIMEZONE15852SESSIONTZNAME13853SESSION_CACHED_CURSORS22854SET3855SETS4856SETTINGS8857SET_TO_JOIN11858SEVERE6859SHARE5860SHARED6861SHARED_POOL11862SHRINK6863SHUTDOWN8864SIBLINGS8865SID3866SIMPLE6867SINGLE6868SINGLETASK10869SIZE4870SKIP4871SKIP_EXT_OPTIMIZER18872SKIP_UNQ_UNUSABLE_IDX21873SKIP_UNUSABLE_INDEXES21874SMALLFILE9875SMALLINT8876SNAPSHOT8877SOME4878SORT4879SOURCE6880SPACE5881SPECIFICATION13882SPFILE6883SPLIT5884SPREADSHEET11885SQL3886SQLLDR6887SQL_TRACE9888STANDBY7889STAR4890START5891STARTUP7892STAR_TRANSFORMATION19893STATEMENT_ID12894STATIC6895STATISTICS10896STOP4897STORAGE7898STORE5899STREAMS7900STRICT6901STRIP5902STRUCTURE9903SUBMULTISET11904SUBPARTITION12905SUBPARTITIONS13906SUBPARTITION_REL16907SUBSTITUTABLE13908SUCCESSFUL10909SUMMARY7910SUPPLEMENTAL12911SUSPEND7912SWAP_JOIN_INPUTS16913SWITCH6914SWITCHOVER10915SYNONYM7916SYSAUX6917SYSDATE7918SYSDBA6919SYSOPER7920SYSTEM6921SYSTIMESTAMP12922SYS_DL_CURSOR13923SYS_FBT_INSDEL14924SYS_OP_BITVEC13925SYS_OP_CAST11926SYS_OP_COL_PRESENT18927SYS_OP_ENFORCE_NOT_NULL$24928SYS_OP_MINE_VALUE17929SYS_OP_NOEXPAND15930SYS_OP_NTCIMG$14931SYS_PARALLEL_TXN16932SYS_RID_ORDER13933TABLE5934TABLES6935TABLESPACE10936TABLESPACE_NO13937TABLE_STATS11938TABNO5939TEMPFILE8940TEMPLATE8941TEMPORARY9942TEST4943THAN4944THE3945THEN4946THREAD6947THROUGH7948TIME4949TIMEOUT7950TIMESTAMP9951TIMEZONE_ABBR13952TIMEZONE_HOUR13953TIMEZONE_MINUTE15954TIMEZONE_REGION15955TIME_ZONE9956TIV_GB6957TIV_SSF7958TO2959TOPLEVEL8960TRACE5961TRACING7962TRACKING8963TRAILING8964TRANSACTION11965TRANSITIONAL12966TREAT5967TRIGGER7968TRIGGERS8969TRUE4970TRUNCATE8971TRUSTED7972TUNING6973TX2974TYPE4975TYPES5976TZ_OFFSET9977UB23978UBA3979UID3980UNARCHIVED10981UNBOUND7982UNBOUNDED9983UNDER5984UNDO4985UNDROP6986UNIFORM7987UNION5988UNIQUE6989UNLIMITED9990UNLOCK6991UNNEST6992UNPACKED8993UNPROTECTED11994UNQUIESCE9995UNRECOVERABLE13996UNTIL5997UNUSABLE8998UNUSED6999UPDATABLE91000UPDATE61001UPDATED71002UPD_INDEXES111003UPD_JOININDEX131004UPGRADE71005UPSERT61006UROWID61007USAGE51008USE31009USER41010USER_DEFINED121011USER_RECYCLEBIN151012USE_ANTI81013USE_CONCAT101014USE_HASH81015USE_MERGE91016USE_NL61017USE_NL_WITH_INDEX171018USE_PRIVATE_OUTLINES201019USE_SEMI81020USE_STORED_OUTLINES191021USE_TTT_FOR_GSETS171022USE_WEAK_NAME_RESL181023USING51024VALIDATE81025VALIDATION101026VALUE51027VALUES61028VARCHAR71029VARCHAR281030VARRAY61031VARYING71032VECTOR_READ111033VECTOR_READ_TRACE171034VERSION71035VERSIONS81036VIEW41037WAIT41038WELLFORMED101039WHEN41040WHENEVER81041WHERE51042WHITESPACE101043WITH41044WITHIN61045WITHOUT71046WORK41047WRITE51048XID31049XMLATTRIBUTES131050XMLCOLATTVAL121051XMLELEMENT101052XMLFOREST91053XMLPARSE81054XMLSCHEMA91055XMLTYPE71056X_DYN_PRUNE111057YEAR41058ZONE41059[11060]11061^11062|110630