加入收藏 | 设为首页 | 会员中心 | 我要投稿 李大同 (https://www.lidatong.com.cn/)- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置: 首页 > 百科 > 正文

Oracle 关键字(保留字) 大全

发布时间:2020-12-12 14:54:12 所属栏目:百科 来源:网络整理
导读:Oracle 关键字(保留字) 大全 其实这个东西可以在oracle 上输入一个sql语句就可以得到: select * from v$reserved_words order by keyword asc; //order 后边不是必须的,那只是个排序,使结果不至于杂乱无章,如果用的是PL/SQL的话的SQL window的话,在获得
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 上输入一个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
    推荐文章
      热点阅读