- 浏览: 233758 次
- 性别:
- 来自: 济南
文章分类
- 全部博客 (143)
- linux (12)
- oracle (8)
- jdk (1)
- CentOS (10)
- 虚拟机 (1)
- Json (1)
- iBatis (3)
- spring (1)
- ExtJs (8)
- HTML (25)
- CSS (20)
- JS (49)
- Struts2 (3)
- Photoshop (1)
- web前端 (11)
- java (4)
- Knockout Js (3)
- 杂( ⊙o⊙ )? (1)
- Jquery (6)
- PhoneGap (3)
- jQuery Mobile (4)
- 移动开发 (3)
- android (5)
- VirsualSVN Server (1)
- NodeJs (5)
- UI&插件 (2)
- 数据库 (4)
- GitHub (1)
- 邮件 (3)
- MongoDB (2)
最新评论
-
xiajun612:
这样安装后,服务还是启动不了
Win8(.1) 安装VirtualSVN Server发生service visualSVN Server failed to start解决办法 -
原水小子:
pqiu 写道谢谢,成了,感谢您
客气,好东西就得分享
navicat for mysql 9.0.15注册码 -
pqiu:
谢谢,成了,感谢您
navicat for mysql 9.0.15注册码 -
原水小子:
jeffreyQiu 写道原水小子 写道敢问两位兄台尊姓大名? ...
安装升级IE9后一直自动弹出微软页面 解决办法 -
jeffreyQiu:
原水小子 写道敢问两位兄台尊姓大名?jeffreyQiu 写道 ...
安装升级IE9后一直自动弹出微软页面 解决办法
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 得到的结果:
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中TO_DATE格式
2012-12-28 15:52 676TO_DATE格式(以时间:2007-11-02 13: ... -
PL/SQL连接远程数据库
2012-10-22 14:28 839在oracle安装目录下 D:\softset\OracleX ... -
Linux下oracle安装完毕 连接PL/SQL
2012-09-06 17:13 967安装完毕测试:sqlplus /nologconn /as s ... -
Linux下Oracle数据库system用户解锁和密码恢复。
2012-09-06 17:08 1940system用户解锁和密码恢复。 1.首先用sys用户以sy ... -
centos主机名bogon解决办法
2012-09-06 17:06 1281centos主机名bogon解决办法 bogon ... -
在CentOS下安装Oracle10g(转)
2012-09-05 14:32 927在CentOS下安装Oracle10g 1. 前言 ... -
oracle 由OUI-10035和OUI-10033错误引发的关于oraInventory目录位置的思考
2012-08-31 10:23 1438由OUI-10035和OUI-10033错误引发的关于oraI ...
相关推荐
### Oracle关键字(保留字)详解 #### 概述 在Oracle数据库系统中,关键字或保留字是用来执行特定功能和操作的预定义标识符。这些关键字对于编写有效的SQL语句至关重要,因为它们帮助开发者构建出清晰、逻辑严谨的...
数据库关键字保留字大全 数据库关键字保留字大全是数据库管理员和开发者最常用的参考手册。这里收录了多种数据库管理系统中的保留字,包括DB2、Oracle、MySQL、SQL Server等。这些保留字是数据库管理系统中不可或缺...
mybatis中使用oracle关键字出错的解决方法 MyBatis是一种非常流行的持久层框架,它提供了大量的便捷功能,帮助开发者快速高效地开发应用程序。然而,在使用MyBatis时,可能会遇到一些问题,例如使用Oracle关键字时...
### Oracle关键字用法整合 #### 1. CONCAT **功能说明**:`CONCAT`用于连接两个或多个字符串。在Oracle中,可以使用`||`作为替代方式。 **示例**: ```sql SELECT CONCAT('%','') FROM dual; ``` 在示例中,由于`...
在MySQL 5.7中,了解关键字和保留字对于编写有效的SQL语句至关重要。这些关键字是SQL语言中具有特殊含义的单词,它们用于定义数据库结构、查询数据、更新记录等操作。保留字则是那些不能直接作为数据库对象名称(如...
- `SELECT`语句用于获取数据,可以查询所有列或指定列,`DISTINCT`关键字去除重复行。 - `WHERE`子句用于设定查询条件,`IS NULL`和`IS NOT NULL`分别用于查询空值和非空值。 7. **其他操作**: - `DESCRIBE`或`...
2. 使用明确的别名,避免使用单个字符作为别名,以防与保留字冲突。 3. 在可能的情况下,使用标准SQL语法,以提高代码的移植性。 4. 当遇到兼容性问题时,查阅数据库的官方文档以获取正确的语法和用法。 总的来说,...
列表中包括了像`ABORT`、`ABSTRACT`、`ACCESSED`等关键字以及带星号标识的保留字,例如`*ABSOLUTE`、`*ADD`等。 通过以上分析可以看出,尽管达梦数据库旨在兼容Oracle的部分功能,但在实际应用中仍需注意两者之间的...
1. 关键字和保留字:在Java编程中,会用到很多关键字和保留字,如public, private, static等,用于定义类、方法或控制访问权限。 2. 代码理解与阅读:题库会涉及到对给定代码段的分析理解,来预测程序的输出结果或者...
标题“2011Oracle笔记(李兴华视屏教程笔记)”揭示了文档的用途,它是作为2011年李兴华Oracle教学视频课程的学习笔记。这种笔记通常包括了课程中的重点概念、Oracle数据库基础知识、实际操作案例以及配合视频教程的...
关键字变色是这些设置的一部分,它有助于快速识别和区分不同的语法元素,如数据类型、保留字、函数名等。下面我们将深入探讨这个主题: 1. **配置文件**:在PLSQL Developer中,个人设置保存在用户目录下的`.plsql...
Oracle数据库是一类关系型数据库管理系统(RDBMS),由美国Oracle公司开发。Oracle数据库系统以其高度的可靠性、安全性、开放性和可移植性而著称,广泛应用于金融、电信、交通、制造等领域的业务系统中。在学习...
这个错误通常与SELECT语句的结构有关,可能是因为确实遗漏了FROM关键字,位置错误,拼写错误,SELECT语句的列表之间缺少逗号,或者使用了单引号而不是双引号来定义别名,或者使用了Oracle保留字。例如,缺少FROM的...
保留字是SQL和PL/SQL中预定义的具有特殊含义的关键字,不能用作表名、列名或其他数据库对象的名称。了解保留字有助于避免命名冲突。 9. **查询Oracle编码集**: 可以使用`SELECT * FROM NLS_DATABASE_PARAMETERS ...
- **关键字与保留字**: 不得使用Oracle数据库中的关键字和保留字作为对象名,以防出现意外的语法错误。 **2. 空格禁用** - **禁止空格**: 严禁使用包含空格的名称来命名字段和表,以避免语法错误或不必要的麻烦...
**题目**: 在 Oracle 中创建用户时,若未提及 DEFAULT TABLESPACE关键字,则 Oracle 就将( )表空间分配给用户作为默认表空间。 - A.HR - B.SCOTT - C.SYSTEM - D.SYS **答案**: C.SYSTEM **解析**: 当...
在Oracle数据库中,保留字和关键字是编程和SQL查询中至关重要的元素。保留字是数据库系统特有的一组词汇,它们在语法上有特殊含义,不能用作标识符(如表名、列名),因为它们已经被系统占用以执行特定的操作。例如...