用oracle建表,必须注意Oracle 关键字(保留字)

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 得到的结果:
 

   KEYWORDLENGTH
1 ! 1
2 & 1
3 ( 1
4 ) 1
5 * 1
6 + 1
7 , 1
8 - 1
9 . 1
10 / 1
11 : 1
12 < 1
13 << 2
14 = 1
15 > 1
16 @ 1
17 A 1
18 ABORT 5
19 ACCESS 6
20 ACCESSED 8
21 ACCOUNT 7
22 ACTIVATE 8
23 ADD 3
24 ADMIN 5
25 ADMINISTER 10
26 ADMINISTRATOR 13
27 ADVISE 6
28 ADVISOR 7
29 AFTER 5
30 ALGORITHM 9
31 ALIAS 5
32 ALL 3
33 ALLOCATE 8
34 ALLOW 5
35 ALL_ROWS 8
36 ALTER 5
37 ALWAYS 6
38 ANALYZE 7
39 ANCILLARY 9
40 AND 3
41 AND_EQUAL 9
42 ANTIJOIN 8
43 ANY 3
44 APPEND 6
45 APPLY 5
46 ARCHIVE 7
47 ARCHIVELOG 10
48 ARRAY 5
49 AS 2
50 ASC 3
51 ASSOCIATE 9
52 AT 2
53 ATTRIBUTE 9
54 ATTRIBUTES 10
55 AUDIT 5
56 AUTHENTICATED 13
57 AUTHENTICATION 14
58 AUTHID 6
59 AUTHORIZATION 13
60 AUTO 4
61 AUTOALLOCATE 12
62 AUTOEXTEND 10
63 AUTOMATIC 9
64 AVAILABILITY 12
65 BACKUP 6
66 BECOME 6
67 BEFORE 6
68 BEGIN 5
69 BEHALF 6
70 BETWEEN 7
71 BFILE 5
72 BIGFILE 7
73 BINARY_DOUBLE 13
74 BINARY_DOUBLE_INFINITY 22
75 BINARY_DOUBLE_NAN 17
76 BINARY_FLOAT 12
77 BINARY_FLOAT_INFINITY 21
78 BINARY_FLOAT_NAN 16
79 BINDING 7
80 BITMAP 6
81 BITS 4
82 BLOB 4
83 BLOCK 5
84 BLOCKS 6
85 BLOCKSIZE 9
86 BLOCK_RANGE 11
87 BODY 4
88 BOTH 4
89 BOUND 5
90 BROADCAST 9
91 BUFFER 6
92 BUFFER_CACHE 12
93 BUFFER_POOL 11
94 BUILD 5
95 BULK 4
96 BY 2
97 BYPASS_RECURSIVE_CHECK 22
98 BYPASS_UJVC 11
99 BYTE 4
100 CACHE 5
101 CACHE_CB 8
102 CACHE_INSTANCES 15
103 CACHE_TEMP_TABLE 16
104 CALL 4
105 CANCEL 6
106 CARDINALITY 11
107 CASCADE 7
108 CASE 4
109 CAST 4
110 CATEGORY 8
111 CERTIFICATE 11
112 CFILE 5
113 CHAINED 7
114 CHANGE 6
115 CHAR 4
116 CHARACTER 9
117 CHAR_CS 7
118 CHECK 5
119 CHECKPOINT 10
120 CHILD 5
121 CHOOSE 6
122 CHUNK 5
123 CIV_GB 6
124 CLASS 5
125 CLEAR 5
126 CLOB 4
127 CLONE 5
128 CLOSE 5
129 CLOSE_CACHED_OPEN_CURSORS 25
130 CLUSTER 7
131 CLUSTERING_FACTOR 17
132 COALESCE 8
133 COARSE 6
134 COLLECT 7
135 COLLECTIONS_GET_REFS 20
136 COLUMN 6
137 COLUMNS 7
138 COLUMN_STATS 12
139 COLUMN_VALUE 12
140 COMMENT 7
141 COMMIT 6
142 COMMITTED 9
143 COMPACT 7
144 COMPATIBILITY 13
145 COMPILE 7
146 COMPLETE 8
147 COMPOSITE_LIMIT 15
148 COMPRESS 8
149 COMPUTE 7
150 CONFORMING 10
151 CONNECT 7
152 CONNECT_BY_ISCYCLE 18
153 CONNECT_BY_ISLEAF 17
154 CONNECT_BY_ROOT 15
155 CONNECT_TIME 12
156 CONSIDER 8
157 CONSISTENT 10
158 CONSTRAINT 10
159 CONSTRAINTS 11
160 CONTAINER 9
161 CONTENT 7
162 CONTENTS 8
163 CONTEXT 7
164 CONTINUE 8
165 CONTROLFILE 11
166 CONVERT 7
167 CORRUPTION 10
168 COST 4
169 CPU_COSTING 11
170 CPU_PER_CALL 12
171 CPU_PER_SESSION 15
172 CREATE 6
173 CREATE_STORED_OUTLINES 22
174 CROSS 5
175 CUBE 4
176 CUBE_GB 7
177 CURRENT 7
178 CURRENT_DATE 12
179 CURRENT_SCHEMA 14
180 CURRENT_TIME 12
181 CURRENT_TIMESTAMP 17
182 CURRENT_USER 12
183 CURSOR 6
184 CURSOR_SHARING_EXACT 20
185 CURSOR_SPECIFIC_SEGMENT 23
186 CYCLE 5
187 DANGLING 8
188 DATA 4
189 DATABASE 8
190 DATAFILE 8
191 DATAFILES 9
192 DATAOBJNO 9
193 DATE 4
194 DATE_MODE 9
195 DAY 3
196 DBA 3
197 DBA_RECYCLEBIN 14
198 DBTIMEZONE 10
199 DDL 3
200 DEALLOCATE 10
201 DEBUG 5
202 DEC 3
203 DECIMAL 7
204 DECLARE 7
205 DECREMENT 9
206 DEFAULT 7
207 DEFERRABLE 10
208 DEFERRED 8
209 DEFINED 7
210 DEFINER 7
211 DEGREE 6
212 DELAY 5
213 DELETE 6
214 DEMAND 6
215 DENSE_RANK 10
216 DEREF 5
217 DEREF_NO_REWRITE 16
218 DESC 4
219 DETACHED 8
220 DETERMINES 10
221 DICTIONARY 10
222 DIMENSION 9
223 DIRECTORY 9
224 DISABLE 7
225 DISASSOCIATE 12
226 DISCONNECT 10
227 DISK 4
228 DISKGROUP 9
229 DISKS 5
230 DISMOUNT 8
231 DISTINCT 8
232 DISTINGUISHED 13
233 DISTRIBUTED 11
234 DML 3
235 DML_UPDATE 10
236 DOCUMENT 8
237 DOMAIN_INDEX_NO_SORT 20
238 DOMAIN_INDEX_SORT 17
239 DOUBLE 6
240 DOWNGRADE 9
241 DRIVING_SITE 12
242 DROP 4
243 DUMP 4
244 DYNAMIC 7
245 DYNAMIC_SAMPLING 16
246 DYNAMIC_SAMPLING_EST_CDN 24
247 EACH 4
248 ELEMENT 7
249 ELSE 4
250 EMPTY 5
251 ENABLE 6
252 ENCRYPTED 9
253 ENCRYPTION 10
254 END 3
255 ENFORCE 7
256 ENFORCED 8
257 ENTRY 5
258 ERROR 5
259 ERROR_ON_OVERLAP_TIME 21
260 ESCAPE 6
261 ESTIMATE 8
262 EVENTS 6
263 EXCEPT 6
264 EXCEPTIONS 10
265 EXCHANGE 8
266 EXCLUDING 9
267 EXCLUSIVE 9
268 EXECUTE 7
269 EXEMPT 6
270 EXISTS 6
271 EXPAND_GSET_TO_UNION 20
272 EXPIRE 6
273 EXPLAIN 7
274 EXPLOSION 9
275 EXPORT 6
276 EXPR_CORR_CHECK 15
277 EXTEND 6
278 EXTENDS 7
279 EXTENT 6
280 EXTENTS 7
281 EXTERNAL 8
282 EXTERNALLY 10
283 EXTRACT 7
284 FACT 4
285 FAILED 6
286 FAILED_LOGIN_ATTEMPTS 21
287 FAILGROUP 9
288 FALSE 5
289 FAST 4
290 FBTSCAN 7
291 FIC_CIV 7
292 FIC_PIV 7
293 FILE 4
294 FILTER 6
295 FINAL 5
296 FINE 4
297 FINISH 6
298 FIRST 5
299 FIRST_ROWS 10
300 FLAGGER 7
301 FLASHBACK 9
302 FLOAT 5
303 FLOB 4
304 FLUSH 5
305 FOLLOWING 9
306 FOR 3
307 FORCE 5
308 FORCE_XML_QUERY_REWRITE 23
309 FOREIGN 7
310 FREELIST 8
311 FREELISTS 9
312 FREEPOOLS 9
313 FRESH 5
314 FROM 4
315 FULL 4
316 FUNCTION 8
317 FUNCTIONS 9
318 GATHER_PLAN_STATISTICS 22
319 GBY_CONC_ROLLUP 15
320 GENERATED 9
321 GLOBAL 6
322 GLOBALLY 8
323 GLOBAL_NAME 11
324 GLOBAL_TOPIC_ENABLED 20
325 GRANT 5
326 GROUP 5
327 GROUPING 8
328 GROUPS 6
329 GROUP_BY 8
330 GUARANTEE 9
331 GUARANTEED 10
332 GUARD 5
333 HASH 4
334 HASHKEYS 8
335 HASH_AJ 7
336 HASH_SJ 7
337 HAVING 6
338 HEADER 6
339 HEAP 4
340 HIERARCHY 9
341 HIGH 4
342 HINTSET_BEGIN 13
343 HINTSET_END 11
344 HOUR 4
345 HWM_BROKERED 12
346 ID 2
347 IDENTIFIED 10
348 IDENTIFIER 10
349 IDENTITY 8
350 IDGENERATORS 12
351 IDLE_TIME 9
352 IF 2
353 IGNORE 6
354 IGNORE_ON_CLAUSE 16
355 IGNORE_OPTIM_EMBEDDED_HINTS 27
356 IGNORE_WHERE_CLAUSE 19
357 IMMEDIATE 9
358 IMPORT 6
359 IN 2
360 INCLUDE_VERSION 15
361 INCLUDING 9
362 INCREMENT 9
363 INCREMENTAL 11
364 INDEX 5
365 INDEXED 7
366 INDEXES 7
367 INDEXTYPE 9
368 INDEXTYPES 10
369 INDEX_ASC 9
370 INDEX_COMBINE 13
371 INDEX_DESC 10
372 INDEX_FFS 9
373 INDEX_FILTER 12
374 INDEX_JOIN 10
375 INDEX_ROWS 10
376 INDEX_RRS 9
377 INDEX_SCAN 10
378 INDEX_SKIP_SCAN 15
379 INDEX_SS 8
380 INDEX_SS_ASC 12
381 INDEX_SS_DESC 13
382 INDEX_STATS 11
383 INDICATOR 9
384 INFINITE 8
385 INFORMATIONAL 13
386 INITIAL 7
387 INITIALIZED 11
388 INITIALLY 9
389 INITRANS 8
390 INLINE 6
391 INNER 5
392 INSERT 6
393 INSTANCE 8
394 INSTANCES 9
395 INSTANTIABLE 12
396 INSTANTLY 9
397 INSTEAD 7
398 INT 3
399 INTEGER 7
400 INTEGRITY 9
401 INTERMEDIATE 12
402 INTERNAL_CONVERT 16
403 INTERNAL_USE 12
404 INTERPRETED 11
405 INTERSECT 9
406 INTERVAL 8
407 INTO 4
408 INVALIDATE 10
409 IN_MEMORY_METADATA 18
410 IS 2
411 ISOLATION 9
412 ISOLATION_LEVEL 15
413 ITERATE 7
414 ITERATION_NUMBER 16
415 JAVA 4
416 JOB 3
417 JOIN 4
418 KEEP 4
419 KERBEROS 8
420 KEY 3
421 KEYFILE 7
422 KEYS 4
423 KEYSIZE 7
424 KEY_LENGTH 10
425 KILL 4
426 LAST 4
427 LATERAL 7
428 LAYER 5
429 LDAP_REGISTRATION 17
430 LDAP_REGISTRATION_ENABLED 25
431 LDAP_REG_SYNC_INTERVAL 22
432 LEADING 7
433 LEFT 4
434 LENGTH 6
435 LESS 4
436 LEVEL 5
437 LEVELS 6
438 LIBRARY 7
439 LIKE 4
440 LIKE2 5
441 LIKE4 5
442 LIKEC 5
443 LIKE_EXPAND 11
444 LIMIT 5
445 LINK 4
446 LIST 4
447 LOB 3
448 LOCAL 5
449 LOCALTIME 9
450 LOCALTIMESTAMP 14
451 LOCAL_INDEXES 13
452 LOCATION 8
453 LOCATOR 7
454 LOCK 4
455 LOCKED 6
456 LOG 3
457 LOGFILE 7
458 LOGGING 7
459 LOGICAL 7
460 LOGICAL_READS_PER_CALL 22
461 LOGICAL_READS_PER_SESSION 25
462 LOGOFF 6
463 LOGON 5
464 LONG 4
465 MAIN 4
466 MANAGE 6
467 MANAGED 7
468 MANAGEMENT 10
469 MANUAL 6
470 MAPPING 7
471 MASTER 6
472 MATCHED 7
473 MATERIALIZE 11
474 MATERIALIZED 12
475 MAX 3
476 MAXARCHLOGS 11
477 MAXDATAFILES 12
478 MAXEXTENTS 10
479 MAXIMIZE 8
480 MAXINSTANCES 12
481 MAXLOGFILES 11
482 MAXLOGHISTORY 13
483 MAXLOGMEMBERS 13
484 MAXSIZE 7
485 MAXTRANS 8
486 MAXVALUE 8
487 MEASURES 8
488 MEMBER 6
489 MEMORY 6
490 MERGE 5
491 MERGE_AJ 8
492 MERGE_CONST_ON 14
493 MERGE_SJ 8
494 METHOD 6
495 MIGRATE 7
496 MIN 3
497 MINEXTENTS 10
498 MINIMIZE 8
499 MINIMUM 7
500 MINUS 5
501 MINUTE 6
502 MINVALUE 8
503 MIRROR 6
504 MLSLABEL 8
505 MODE 4
506 MODEL 5
507 MODEL_DONTVERIFY_UNIQUENESS 27
508 MODEL_MIN_ANALYSIS 18
509 MODEL_NO_ANALYSIS 17
510 MODEL_PBY 9
511 MODEL_PUSH_REF 14
512 MODIFY 6
513 MONITORING 10
514 MONTH 5
515 MOUNT 5
516 MOVE 4
517 MOVEMENT 8
518 MULTISET 8
519 MV_MERGE 8
520 NAME 4
521 NAMED 5
522 NAN 3
523 NATIONAL 8
524 NATIVE 6
525 NATURAL 7
526 NAV 3
527 NCHAR 5
528 NCHAR_CS 8
529 NCLOB 5
530 NEEDED 6
531 NESTED 6
532 NESTED_TABLE_FAST_INSERT 24
533 NESTED_TABLE_GET_REFS 21
534 NESTED_TABLE_ID 15
535 NESTED_TABLE_SET_REFS 21
536 NESTED_TABLE_SET_SETID 22
537 NETWORK 7
538 NEVER 5
539 NEW 3
540 NEXT 4
541 NLS_CALENDAR 12
542 NLS_CHARACTERSET 16
543 NLS_COMP 8
544 NLS_CURRENCY 12
545 NLS_DATE_FORMAT 15
546 NLS_DATE_LANGUAGE 17
547 NLS_ISO_CURRENCY 16
548 NLS_LANG 8
549 NLS_LANGUAGE 12
550 NLS_LENGTH_SEMANTICS 20
551 NLS_NCHAR_CONV_EXCP 19
552 NLS_NUMERIC_CHARACTERS 22
553 NLS_SORT 8
554 NLS_SPECIAL_CHARS 17
555 NLS_TERRITORY 13
556 NL_AJ 5
557 NL_SJ 5
558 NO 2
559 NOAPPEND 8
560 NOARCHIVELOG 12
561 NOAUDIT 7
562 NOCACHE 7
563 NOCOMPRESS 10
564 NOCPU_COSTING 13
565 NOCYCLE 7
566 NODELAY 7
567 NOFORCE 7
568 NOGUARANTEE 11
569 NOLOGGING 9
570 NOMAPPING 9
571 NOMAXVALUE 10
572 NOMINIMIZE 10
573 NOMINVALUE 10
574 NOMONITORING 12
575 NONE 4
576 NOORDER 7
577 NOOVERRIDE 10
578 NOPARALLEL 10
579 NOPARALLEL_INDEX 16
580 NORELY 6
581 NOREPAIR 8
582 NORESETLOGS 11
583 NOREVERSE 9
584 NOREWRITE 9
585 NORMAL 6
586 NOROWDEPENDENCIES 17
587 NOSEGMENT 9
588 NOSORT 6
589 NOSTRICT 8
590 NOSWITCH 8
591 NOT 3
592 NOTHING 7
593 NOVALIDATE 10
594 NOWAIT 6
595 NO_ACCESS 9
596 NO_BASETABLE_MULTIMV_REWRITE 28
597 NO_BUFFER 9
598 NO_CPU_COSTING 14
599 NO_EXPAND 9
600 NO_EXPAND_GSET_TO_UNION 23
601 NO_FACT 7
602 NO_FILTERING 12
603 NO_INDEX 8
604 NO_INDEX_FFS 12
605 NO_INDEX_SS 11
606 NO_MERGE 8
607 NO_MODEL_PUSH_REF 17
608 NO_MONITORING 13
609 NO_MULTIMV_REWRITE 18
610 NO_ORDER_ROLLUPS 16
611 NO_PARALLEL 11
612 NO_PARALLEL_INDEX 17
613 NO_PARTIAL_COMMIT 17
614 NO_PRUNE_GSETS 14
615 NO_PUSH_PRED 12
616 NO_PUSH_SUBQ 12
617 NO_QKN_BUFF 11
618 NO_QUERY_TRANSFORMATION 23
619 NO_REF_CASCADE 14
620 NO_REWRITE 10
621 NO_SEMIJOIN 11
622 NO_SET_TO_JOIN 14
623 NO_STAR_TRANSFORMATION 22
624 NO_STATS_GSETS 14
625 NO_SWAP_JOIN_INPUTS 19
626 NO_TRIGGER 10
627 NO_UNNEST 9
628 NO_USE_HASH 11
629 NO_USE_MERGE 12
630 NO_USE_NL 9
631 NO_XML_QUERY_REWRITE 20
632 NULL 4
633 NULLS 5
634 NUMBER 6
635 NUMERIC 7
636 NVARCHAR2 9
637 OBJECT 6
638 OBJNO 5
639 OBJNO_REUSE 11
640 OF 2
641 OFF 3
642 OFFLINE 7
643 OID 3
644 OIDINDEX 8
645 OLD 3
646 ON 2
647 ONLINE 6
648 ONLY 4
649 OPAQUE 6
650 OPAQUE_TRANSFORM 16
651 OPAQUE_XCANONICAL 17
652 OPCODE 6
653 OPEN 4
654 OPERATOR 8
655 OPTIMAL 7
656 OPTIMIZER_FEATURES_ENABLE 25
657 OPTIMIZER_GOAL 14
658 OPTION 6
659 OPT_ESTIMATE 12
660 OR 2
661 ORA_ROWSCN 10
662 ORDER 5
663 ORDERED 7
664 ORDERED_PREDICATES 18
665 ORGANIZATION 12
666 OR_EXPAND 9
667 OUTER 5
668 OUTLINE 7
669 OUT_OF_LINE 11
670 OVER 4
671 OVERFLOW 8
672 OVERFLOW_NOMOVE 15
673 OVERLAPS 8
674 OWN 3
675 PACKAGE 7
676 PACKAGES 8
677 PARALLEL 8
678 PARALLEL_INDEX 14
679 PARAMETERS 10
680 PARENT 6
681 PARITY 6
682 PARTIALLY 9
683 PARTITION 9
684 PARTITIONS 10
685 PARTITION_HASH 14
686 PARTITION_LIST 14
687 PARTITION_RANGE 15
688 PASSWORD 8
689 PASSWORD_GRACE_TIME 19
690 PASSWORD_LIFE_TIME 18
691 PASSWORD_LOCK_TIME 18
692 PASSWORD_REUSE_MAX 18
693 PASSWORD_REUSE_TIME 19
694 PASSWORD_VERIFY_FUNCTION 24
695 PCTFREE 7
696 PCTINCREASE 11
697 PCTTHRESHOLD 12
698 PCTUSED 7
699 PCTVERSION 10
700 PERCENT 7
701 PERFORMANCE 11
702 PERMANENT 9
703 PFILE 5
704 PHYSICAL 8
705 PIV_GB 6
706 PIV_SSF 7
707 PLAN 4
708 PLSQL_CODE_TYPE 15
709 PLSQL_DEBUG 11
710 PLSQL_OPTIMIZE_LEVEL 20
711 PLSQL_WARNINGS 14
712 POLICY 6
713 POST_TRANSACTION 16
714 POWER 5
715 PQ_DISTRIBUTE 13
716 PQ_MAP 6
717 PQ_NOMAP 8
718 PREBUILT 8
719 PRECEDING 9
720 PRECISION 9
721 PREPARE 7
722 PRESENT 7
723 PRESERVE 8
724 PRIMARY 7
725 PRIOR 5
726 PRIVATE 7
727 PRIVATE_SGA 11
728 PRIVILEGE 9
729 PRIVILEGES 10
730 PROCEDURE 9
731 PROFILE 7
732 PROGRAM 7
733 PROJECT 7
734 PROTECTED 9
735 PROTECTION 10
736 PUBLIC 6
737 PURGE 5
738 PUSH_PRED 9
739 PUSH_SUBQ 9
740 PX_GRANULE 10
741 QB_NAME 7
742 QUERY 5
743 QUERY_BLOCK 11
744 QUEUE 5
745 QUEUE_CURR 10
746 QUEUE_ROWP 10
747 QUIESCE 7
748 QUOTA 5
749 RANDOM 6
750 RANGE 5
751 RAPIDLY 7
752 RAW 3
753 RBA 3
754 READ 4
755 READS 5
756 REAL 4
757 REBALANCE 9
758 REBUILD 7
759 RECORDS_PER_BLOCK 17
760 RECOVER 7
761 RECOVERABLE 11
762 RECOVERY 8
763 RECYCLE 7
764 RECYCLEBIN 10
765 REDUCED 7
766 REDUNDANCY 10
767 REF 3
768 REFERENCE 9
769 REFERENCED 10
770 REFERENCES 10
771 REFERENCING 11
772 REFRESH 7
773 REF_CASCADE_CURSOR 18
774 REGEXP_LIKE 11
775 REGISTER 8
776 REJECT 6
777 REKEY 5
778 RELATIONAL 10
779 RELY 4
780 REMOTE_MAPPED 13
781 RENAME 6
782 REPAIR 6
783 REPLACE 7
784 REQUIRED 8
785 RESET 5
786 RESETLOGS 9
787 RESIZE 6
788 RESOLVE 7
789 RESOLVER 8
790 RESOURCE 8
791 RESTORE_AS_INTERVALS 20
792 RESTRICT 8
793 RESTRICTED 10
794 RESTRICT_ALL_REF_CONS 21
795 RESUMABLE 9
796 RESUME 6
797 RETENTION 9
798 RETURN 6
799 RETURNING 9
800 REUSE 5
801 REVERSE 7
802 REVOKE 6
803 REWRITE 7
804 REWRITE_OR_ERROR 16
805 RIGHT 5
806 ROLE 4
807 ROLES 5
808 ROLLBACK 8
809 ROLLUP 6
810 ROW 3
811 ROWDEPENDENCIES 15
812 ROWID 5
813 ROWNUM 6
814 ROWS 4
815 ROW_LENGTH 10
816 RULE 4
817 RULES 5
818 SAMPLE 6
819 SAVEPOINT 9
820 SAVE_AS_INTERVALS 17
821 SB4 3
822 SCALE 5
823 SCALE_ROWS 10
824 SCAN 4
825 SCAN_INSTANCES 14
826 SCHEDULER 9
827 SCHEMA 6
828 SCN 3
829 SCN_ASCENDING 13
830 SCOPE 5
831 SD_ALL 6
832 SD_INHIBIT 10
833 SD_SHOW 7
834 SECOND 6
835 SECURITY 8
836 SEED 4
837 SEGMENT 7
838 SEG_BLOCK 9
839 SEG_FILE 8
840 SELECT 6
841 SELECTIVITY 11
842 SEMIJOIN 8
843 SEMIJOIN_DRIVER 15
844 SEQUENCE 8
845 SEQUENCED 9
846 SEQUENTIAL 10
847 SERIALIZABLE 12
848 SERVERERROR 11
849 SESSION 7
850 SESSIONS_PER_USER 17
851 SESSIONTIMEZONE 15
852 SESSIONTZNAME 13
853 SESSION_CACHED_CURSORS 22
854 SET 3
855 SETS 4
856 SETTINGS 8
857 SET_TO_JOIN 11
858 SEVERE 6
859 SHARE 5
860 SHARED 6
861 SHARED_POOL 11
862 SHRINK 6
863 SHUTDOWN 8
864 SIBLINGS 8
865 SID 3
866 SIMPLE 6
867 SINGLE 6
868 SINGLETASK 10
869 SIZE 4
870 SKIP 4
871 SKIP_EXT_OPTIMIZER 18
872 SKIP_UNQ_UNUSABLE_IDX 21
873 SKIP_UNUSABLE_INDEXES 21
874 SMALLFILE 9
875 SMALLINT 8
876 SNAPSHOT 8
877 SOME 4
878 SORT 4
879 SOURCE 6
880 SPACE 5
881 SPECIFICATION 13
882 SPFILE 6
883 SPLIT 5
884 SPREADSHEET 11
885 SQL 3
886 SQLLDR 6
887 SQL_TRACE 9
888 STANDBY 7
889 STAR 4
890 START 5
891 STARTUP 7
892 STAR_TRANSFORMATION 19
893 STATEMENT_ID 12
894 STATIC 6
895 STATISTICS 10
896 STOP 4
897 STORAGE 7
898 STORE 5
899 STREAMS 7
900 STRICT 6
901 STRIP 5
902 STRUCTURE 9
903 SUBMULTISET 11
904 SUBPARTITION 12
905 SUBPARTITIONS 13
906 SUBPARTITION_REL 16
907 SUBSTITUTABLE 13
908 SUCCESSFUL 10
909 SUMMARY 7
910 SUPPLEMENTAL 12
911 SUSPEND 7
912 SWAP_JOIN_INPUTS 16
913 SWITCH 6
914 SWITCHOVER 10
915 SYNONYM 7
916 SYSAUX 6
917 SYSDATE 7
918 SYSDBA 6
919 SYSOPER 7
920 SYSTEM 6
921 SYSTIMESTAMP 12
922 SYS_DL_CURSOR 13
923 SYS_FBT_INSDEL 14
924 SYS_OP_BITVEC 13
925 SYS_OP_CAST 11
926 SYS_OP_COL_PRESENT 18
927 SYS_OP_ENFORCE_NOT_NULL$ 24
928 SYS_OP_MINE_VALUE 17
929 SYS_OP_NOEXPAND 15
930 SYS_OP_NTCIMG$ 14
931 SYS_PARALLEL_TXN 16
932 SYS_RID_ORDER 13
933 TABLE 5
934 TABLES 6
935 TABLESPACE 10
936 TABLESPACE_NO 13
937 TABLE_STATS 11
938 TABNO 5
939 TEMPFILE 8
940 TEMPLATE 8
941 TEMPORARY 9
942 TEST 4
943 THAN 4
944 THE 3
945 THEN 4
946 THREAD 6
947 THROUGH 7
948 TIME 4
949 TIMEOUT 7
950 TIMESTAMP 9
951 TIMEZONE_ABBR 13
952 TIMEZONE_HOUR 13
953 TIMEZONE_MINUTE 15
954 TIMEZONE_REGION 15
955 TIME_ZONE 9
956 TIV_GB 6
957 TIV_SSF 7
958 TO 2
959 TOPLEVEL 8
960 TRACE 5
961 TRACING 7
962 TRACKING 8
963 TRAILING 8
964 TRANSACTION 11
965 TRANSITIONAL 12
966 TREAT 5
967 TRIGGER 7
968 TRIGGERS 8
969 TRUE 4
970 TRUNCATE 8
971 TRUSTED 7
972 TUNING 6
973 TX 2
974 TYPE 4
975 TYPES 5
976 TZ_OFFSET 9
977 UB2 3
978 UBA 3
979 UID 3
980 UNARCHIVED 10
981 UNBOUND 7
982 UNBOUNDED 9
983 UNDER 5
984 UNDO 4
985 UNDROP 6
986 UNIFORM 7
987 UNION 5
988 UNIQUE 6
989 UNLIMITED 9
990 UNLOCK 6
991 UNNEST 6
992 UNPACKED 8
993 UNPROTECTED 11
994 UNQUIESCE 9
995 UNRECOVERABLE 13
996 UNTIL 5
997 UNUSABLE 8
998 UNUSED 6
999 UPDATABLE 9
1000 UPDATE 6
1001 UPDATED 7
1002 UPD_INDEXES 11
1003 UPD_JOININDEX 13
1004 UPGRADE 7
1005 UPSERT 6
1006 UROWID 6
1007 USAGE 5
1008 USE 3
1009 USER 4
1010 USER_DEFINED 12
1011 USER_RECYCLEBIN 15
1012 USE_ANTI 8
1013 USE_CONCAT 10
1014 USE_HASH 8
1015 USE_MERGE 9
1016 USE_NL 6
1017 USE_NL_WITH_INDEX 17
1018 USE_PRIVATE_OUTLINES 20
1019 USE_SEMI 8
1020 USE_STORED_OUTLINES 19
1021 USE_TTT_FOR_GSETS 17
1022 USE_WEAK_NAME_RESL 18
1023 USING 5
1024 VALIDATE 8
1025 VALIDATION 10
1026 VALUE 5
1027 VALUES 6
1028 VARCHAR 7
1029 VARCHAR2 8
1030 VARRAY 6
1031 VARYING 7
1032 VECTOR_READ 11
1033 VECTOR_READ_TRACE 17
1034 VERSION 7
1035 VERSIONS 8
1036 VIEW 4
1037 WAIT 4
1038 WELLFORMED 10
1039 WHEN 4
1040 WHENEVER 8
1041 WHERE 5
1042 WHITESPACE 10
1043 WITH 4
1044 WITHIN 6
1045 WITHOUT 7
1046 WORK 4
1047 WRITE 5
1048 XID 3
1049 XMLATTRIBUTES 13
1050 XMLCOLATTVAL 12
1051 XMLELEMENT 10
1052 XMLFOREST 9
1053 XMLPARSE 8
1054 XMLSCHEMA 9
1055 XMLTYPE 7
1056 X_DYN_PRUNE 11
1057 YEAR 4
1058 ZONE 4
1059 [ 1
1060 ] 1
1061 ^ 1
1062 | 1
1063  

 

保留字与关键字的视图(动态视图)V$RESERVED_WORDS

 

This view gives a list of all SQL keywords. To determine whether a particular keyword is reserved in any way, check the RESERVEDRES_TYPERES_ATTR, and RES_SEMI columns.

ColumnDatatypeDescription
KEYWORD VARCHAR2(30) Name of the keyword
LENGTH NUMBER Length of the keyword
RESERVED VARCHAR2(1) A value of Y means that the keyword cannot be used as an identifier. A value of N means that it is not reserved.
RES_TYPE VARCHAR2(1) A value of Y means that the keyword cannot be used as a type name. A value of N means that it is not reserved.
RES_ATTR VARCHAR2(1) A value of Y means that the keyword cannot be used as an attribute name. A value of N means that it is not reserved.
RES_SEMI VARCHAR2(1) A value of Y means that the keyword is not allowed as an identifier in certain situations, such as in DML. A value of N means that it is not reserved.
DUPLICATE VARCHAR2(1) A value of Y means that the keyword is a duplicate of another keyword. A value of N means that it is not a duplicate.

 

 

 

保留字:

 

Begins with:Reserved Words

A

ALL, ALTER, AND, ANY, AS, ASC, AT

B

BEGIN, BETWEEN, BY

C

CASE, CHECK, CLUSTERS, CLUSTER, COLAUTH, COLUMNS, COMPRESS, CONNECT, CRASH, CREATE, CURSOR

D

DECLARE, DEFAULT, DESC, DISTINCT, DROP

E

ELSE, END, EXCEPTION, EXCLUSIVE

F

FETCH, FOR, FROM, FUNCTION

G

GOTO, GRANT, GROUP

H

HAVING

I

IDENTIFIED, IF, IN, INDEX, INDEXES, INSERT, INTERSECT, INTO, IS

L

LIKE, LOCK

M

MINUS, MODE

N

NOCOMPRESS, NOT, NOWAIT, NULL

O

OF, ON, OPTION, OR, ORDER, OVERLAPS

P

PROCEDURE, PUBLIC

R

RESOURCE, REVOKE

S

SELECT, SHARE, SIZE, SQL, START, SUBTYPE

T

TABAUTH, TABLE, THEN, TO, TYPE

U

UNION, UNIQUE, UPDATE

V

VALUES, VIEW, VIEWS

W

WHEN, WHERE, WITH

 

 

关键字:

 

Begins with:Keywords

A

A, ADD, AGENT, AGGREGATE, ARRAY, ATTRIBUTE, AUTHID, AVG

B

BFILE_BASE, BINARY, BLOB_BASE, BLOCK, BODY, BOTH, BOUND, BULK, BYTE

C

C, CALL, CALLING, CASCADE, CHAR, CHAR_BASE, CHARACTER, CHARSET, CHARSETFORM, CHARSETID, CLOB_BASE, CLOSE, COLLECT, COMMENT, COMMIT, COMMITTED, COMPILED, CONSTANT, CONSTRUCTOR, CONTEXT, CONTINUE, CONVERT, COUNT, CURRENT, CUSTOMDATUM

D

DANGLING, DATA, DATE, DATE_BASE, DAY, DEFINE, DELETE, DETERMINISTIC, DOUBLE, DURATION

E

ELEMENT, ELSIF, EMPTY, ESCAPE, EXCEPT, EXCEPTIONS, EXECUTE, EXISTS, EXIT, EXTERNAL

F

FINAL, FIXED, FLOAT, FORALL, FORCE

G

GENERAL

H

HASH, HEAP, HIDDEN, HOUR

I

IMMEDIATE, INCLUDING, INDICATOR, INDICES, INFINITE, INSTANTIABLE, INT, INTERFACE, INTERVAL, INVALIDATE, ISOLATION

J

JAVA

L

LANGUAGE, LARGE, LEADING, LENGTH, LEVEL, LIBRARY, LIKE2, LIKE4, LIKEC, LIMIT, LIMITED, LOCAL, LONG, LOOP

M

MAP, MAX, MAXLEN, MEMBER, MERGE, MIN, MINUTE, MOD, MODIFY, MONTH, MULTISET

N

NAME, NAN, NATIONAL, NATIVE, NCHAR, NEW, NOCOPY, NUMBER_BASE

O

OBJECT, OCICOLL, OCIDATE, OCIDATETIME, OCIDURATION, OCIINTERVAL, OCILOBLOCATOR, OCINUMBER, OCIRAW, OCIREF, OCIREFCURSOR, OCIROWID, OCISTRING, OCITYPE, OLD, ONLY, OPAQUE, OPEN, OPERATOR, ORACLE, ORADATA, ORGANIZATION, ORLANY, ORLVARY, OTHERS, OUT, OVERRIDING

P

PACKAGE, PARALLEL_ENABLE, PARAMETER, PARAMETERS, PARENT, PARTITION, PASCAL, PIPE, PIPELINED, PRAGMA, PRECISION, PRIOR, PRIVATE

R

RAISE, RANGE, RAW, READ, RECORD, REF, REFERENCE, RELIES_ON, REM, REMAINDER, RENAME, RESULT, RESULT_CACHE, RETURN, RETURNING, REVERSE, ROLLBACK, ROW

S

SAMPLE, SAVE, SAVEPOINT, SB1, SB2, SB4, SECOND, SEGMENT, SELF, SEPARATE, SEQUENCE, SERIALIZABLE, SET, SHORT, SIZE_T, SOME, SPARSE, SQLCODE, SQLDATA, SQLNAME, SQLSTATE, STANDARD, STATIC, STDDEV, STORED, STRING, STRUCT, STYLE, SUBMULTISET, SUBPARTITION, SUBSTITUTABLE, SUM, SYNONYM

T

TDO, THE, TIME, TIMESTAMP, TIMEZONE_ABBR, TIMEZONE_HOUR, TIMEZONE_MINUTE, TIMEZONE_REGION, TRAILING, TRANSACTION, TRANSACTIONAL, TRUSTED

U

UB1, UB2, UB4, UNDER, UNSIGNED, UNTRUSTED, USE, USING

V

VALIST, VALUE, VARIABLE, VARIANCE, VARRAY, VARYING, VOID

W

WHILE, WORK, WRAPPED, WRITE

Y

YEAR

Z

ZONE

 

 

 

posted @ 2016-07-01 13:28  dy9776  阅读(8762)  评论(0编辑  收藏  举报