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

 

	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

 

保留字与关键字的视图（动态视图）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 RESERVED, RES_TYPE, RES_ATTR, and RES_SEMI columns.

Column	Datatype	Description
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