`

.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 得到的结果:
KEYWORD LENGTH
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 0
分享到:
评论

相关推荐

    Oracle关键字(保留字)大全

    ### Oracle关键字(保留字)详解 #### 概述 在Oracle数据库系统中,关键字或保留字是用来执行特定功能和操作的预定义标识符。这些关键字对于编写有效的SQL语句至关重要,因为它们帮助开发者构建出清晰、逻辑严谨的...

    数据库关键字保留字大全

    数据库关键字保留字大全 数据库关键字保留字大全是数据库管理员和开发者最常用的参考手册。这里收录了多种数据库管理系统中的保留字,包括DB2、Oracle、MySQL、SQL Server等。这些保留字是数据库管理系统中不可或缺...

    mybatis中使用oracle关键字出错的解决方法

    mybatis中使用oracle关键字出错的解决方法 MyBatis是一种非常流行的持久层框架,它提供了大量的便捷功能,帮助开发者快速高效地开发应用程序。然而,在使用MyBatis时,可能会遇到一些问题,例如使用Oracle关键字时...

    Oracle关键字用法整合

    ### Oracle关键字用法整合 #### 1. CONCAT **功能说明**:`CONCAT`用于连接两个或多个字符串。在Oracle中,可以使用`||`作为替代方式。 **示例**: ```sql SELECT CONCAT('%','') FROM dual; ``` 在示例中,由于`...

    MySQL 5.7中的关键字与保留字详解

    在MySQL 5.7中,了解关键字和保留字对于编写有效的SQL语句至关重要。这些关键字是SQL语言中具有特殊含义的单词,它们用于定义数据库结构、查询数据、更新记录等操作。保留字则是那些不能直接作为数据库对象名称(如...

    韩顺平.oracle9i.表查询.笔记

    - `SELECT`语句用于获取数据,可以查询所有列或指定列,`DISTINCT`关键字去除重复行。 - `WHERE`子句用于设定查询条件,`IS NULL`和`IS NOT NULL`分别用于查询空值和非空值。 7. **其他操作**: - `DESCRIBE`或`...

    Oracle AS关键字 提示错误

    2. 使用明确的别名,避免使用单个字符作为别名,以防与保留字冲突。 3. 在可能的情况下,使用标准SQL语法,以提高代码的移植性。 4. 当遇到兼容性问题时,查阅数据库的官方文档以获取正确的语法和用法。 总的来说,...

    达梦和oracle的差异说明

    列表中包括了像`ABORT`、`ABSTRACT`、`ACCESSED`等关键字以及带星号标识的保留字,例如`*ABSOLUTE`、`*ADD`等。 通过以上分析可以看出,尽管达梦数据库旨在兼容Oracle的部分功能,但在实际应用中仍需注意两者之间的...

    Oracle.Passcertification.1z0-808.pdf

    1. 关键字和保留字:在Java编程中,会用到很多关键字和保留字,如public, private, static等,用于定义类、方法或控制访问权限。 2. 代码理解与阅读:题库会涉及到对给定代码段的分析理解,来预测程序的输出结果或者...

    2011Oracle笔记(李兴华视屏教程笔记)

    标题“2011Oracle笔记(李兴华视屏教程笔记)”揭示了文档的用途,它是作为2011年李兴华Oracle教学视频课程的学习笔记。这种笔记通常包括了课程中的重点概念、Oracle数据库基础知识、实际操作案例以及配合视频教程的...

    PLSQL配置文件(关键字变色)

    关键字变色是这些设置的一部分,它有助于快速识别和区分不同的语法元素,如数据类型、保留字、函数名等。下面我们将深入探讨这个主题: 1. **配置文件**:在PLSQL Developer中,个人设置保存在用户目录下的`.plsql...

    oracle 学习笔记

    Oracle数据库是一类关系型数据库管理系统(RDBMS),由美国Oracle公司开发。Oracle数据库系统以其高度的可靠性、安全性、开放性和可移植性而著称,广泛应用于金融、电信、交通、制造等领域的业务系统中。在学习...

    ORACLE疑难错误解析.pdf

    这个错误通常与SELECT语句的结构有关,可能是因为确实遗漏了FROM关键字,位置错误,拼写错误,SELECT语句的列表之间缺少逗号,或者使用了单引号而不是双引号来定义别名,或者使用了Oracle保留字。例如,缺少FROM的...

    oracle调优,乱码解决等汇总

    保留字是SQL和PL/SQL中预定义的具有特殊含义的关键字,不能用作表名、列名或其他数据库对象的名称。了解保留字有助于避免命名冲突。 9. **查询Oracle编码集**: 可以使用`SELECT * FROM NLS_DATABASE_PARAMETERS ...

    oracle数据库开发规范.doc

    - **关键字与保留字**: 不得使用Oracle数据库中的关键字和保留字作为对象名,以防出现意外的语法错误。 **2. 空格禁用** - **禁止空格**: 严禁使用包含空格的名称来命名字段和表,以避免语法错误或不必要的麻烦...

    oracle数据库期末考试试题及答案.doc

    **题目**: 在 Oracle 中创建用户时,若未提及 DEFAULT TABLESPACE关键字,则 Oracle 就将( )表空间分配给用户作为默认表空间。 - A.HR - B.SCOTT - C.SYSTEM - D.SYS **答案**: C.SYSTEM **解析**: 当...

    128741

    在Oracle数据库中,保留字和关键字是编程和SQL查询中至关重要的元素。保留字是数据库系统特有的一组词汇,它们在语法上有特殊含义,不能用作标识符(如表名、列名),因为它们已经被系统占用以执行特定的操作。例如...

Global site tag (gtag.js) - Google Analytics