info
held-informatik
de
Anzeige aller in Oracle SQL reservierten Schlüsselwörter
Die in ORACLE SQL geschützten Schlüsselwörter zeigt die View v$reserved_words an. Sie können Sie wie folgt abfragen:
ORACLE SQL: Reservierte Schlüsselwörter
SQL> SET linesize 120 SQL> SET pagesize 3000 SQL> COL KEYWORD FORMAT a30 SQL> 1 SELECT * 2 FROM v$reserved_words 3 ORDER BY keyword;
Den Aufbau der View v$reserved_words zeigt der Befehl descibe (kurz desc) an:
Aufbau der View v$reserved_words
SQL> DESC v$reserved_words Name Typ ---------------------------- -------------- KEYWORD VARCHAR2(30) LENGTH NUMBER RESERVED VARCHAR2(1) RES_TYPE VARCHAR2(1) RES_ATTR VARCHAR2(1) RES_SEMI VARCHAR2(1) DUPLICATE VARCHAR2(1)
Die Ausgabe sieht beispielsweise wie folgt aus:
ORACLE SQL Schlüsselwörter
KEYWORD LENGTH R R R R D ------------------------------ ---------- - - - - - ! 1 Y N N N N & 1 Y N N N N ( 1 Y N N N N ) 1 Y N N N N * 1 Y N N N N + 1 Y N N N N , 1 Y N N N N - 1 Y N N N N . 1 Y N N N N / 1 Y N N N N : 1 Y N N N N < 1 Y N N N N << 2 N N N N N = 1 Y N N N N > 1 Y N N N N @ 1 Y N N N N [ 1 Y N N N N ] 1 Y N N N N ^ 1 Y N N N N | 1 Y N N N N A 1 N N N N N ABORT 5 N N N N N ACCESS 6 N N N Y N ACCESSED 8 N N N N N ACCOUNT 7 N N N N N ACTIVATE 8 N N N N N ADD 3 N N N Y N ADMIN 5 N N N N N ADMINISTER 10 N N N N N ADMINISTRATOR 13 N N N N N ADVISE 6 N N N N N ADVISOR 7 N N N N N AFTER 5 N N N N N ALIAS 5 N N N N N ALL 3 Y N N N N ALLOCATE 8 N N N N N ALLOW 5 N N N N N ALL_ROWS 8 N N N N N ALTER 5 Y N N N N ALWAYS 6 N N N N N ANALYZE 7 N N N N N ANCILLARY 9 N N N N N AND 3 Y N N N N AND_EQUAL 9 N N N N N ANTIJOIN 8 N N N N N ANY 3 Y N N N N APPEND 6 N N N N N APPLY 5 N N N N N ARCHIVE 7 N N N N N ARCHIVELOG 10 N N N N N ARRAY 5 N N N N N AS 2 Y N N N N ASC 3 Y N N N N ASSOCIATE 9 N N N N N AT 2 N N N N N ATTRIBUTE 9 N N N N N ATTRIBUTES 10 N N N N N AUDIT 5 N N N Y N AUTHENTICATED 13 N N N N N AUTHENTICATION 14 N N N N N AUTHID 6 N N N N N AUTHORIZATION 13 N N N N N AUTO 4 N N N N N AUTOALLOCATE 12 N N N N N AUTOEXTEND 10 N N N N N AUTOMATIC 9 N N N N N AVAILABILITY 12 N N N N N BACKUP 6 N N N N N BATCH 5 N N N N N BECOME 6 N N N N N BEFORE 6 N N N N N BEGIN 5 N N N N N BEGIN_OUTLINE_DATA 18 N N N N N BEHALF 6 N N N N N BETWEEN 7 Y N N N N BFILE 5 N N N N N BIGFILE 7 N N N N N BINARY_DOUBLE 13 N N N N N BINARY_DOUBLE_INFINITY 22 N N N N N BINARY_DOUBLE_NAN 17 N N N N N BINARY_FLOAT 12 N N N N N BINARY_FLOAT_INFINITY 21 N N N N N BINARY_FLOAT_NAN 16 N N N N N BINDING 7 N N N N N BITMAP 6 N N N N N BITMAPS 7 N N N N N BITMAP_TREE 11 N N N N N BITS 4 N N N N N BLOB 4 N N N N N BLOCK 5 N N N N N BLOCK_RANGE 11 N N N N N BLOCKS 6 N N N N N BLOCKSIZE 9 N N N N N BODY 4 N N N N N BOTH 4 N N N N N BOUND 5 N N N N N BROADCAST 9 N N N N N BUFFER 6 N N N N N BUFFER_CACHE 12 N N N N N BUFFER_POOL 11 N N N N N BUILD 5 N N N N N BULK 4 N N N N N BY 2 Y N N N N BYPASS_RECURSIVE_CHECK 22 N N N N N BYPASS_UJVC 11 N N N N N BYTE 4 N N N N N CACHE 5 N N N N N CACHE_CB 8 N N N N N CACHE_INSTANCES 15 N N N N N CACHE_TEMP_TABLE 16 N N N N N CALL 4 N N N N N CANCEL 6 N N N N N CARDINALITY 11 N N N N N CASCADE 7 N N N N N CASE 4 N N N N N CAST 4 N N N N N CATEGORY 8 N N N N N CERTIFICATE 11 N N N N N CFILE 5 N N N N N CHAINED 7 N N N N N CHANGE 6 N N N N N CHAR 4 Y N N N Y CHARACTER 9 N N N N N CHAR_CS 7 N N N N N CHECK 5 Y N N N N CHECKPOINT 10 N N N N N CHILD 5 N N N N N CHOOSE 6 N N N N N CHUNK 5 N N N N N CIV_GB 6 N N N N N CLASS 5 N N N N N CLEAR 5 N N N N N CLOB 4 N N N N N CLONE 5 N N N N N CLOSE 5 N N N N N CLOSE_CACHED_OPEN_CURSORS 25 N N N N N CLUSTER 7 Y N N N N CLUSTERING_FACTOR 17 N N N N N COALESCE 8 N N N N N COARSE 6 N N N N N COLLECT 7 N N N N N COLUMN 6 N N N Y N COLUMNS 7 N N N N N COLUMN_STATS 12 N N N N N COLUMN_VALUE 12 N N Y N N COMMENT 7 N N N Y N COMMIT 6 N N N N N COMMITTED 9 N N N N N COMPACT 7 N N N N N COMPATIBILITY 13 N N N N N COMPILE 7 N N N N N COMPLETE 8 N N N N N COMPOSITE_LIMIT 15 N N N N N COMPRESS 8 Y N N N N COMPUTE 7 N N N N N CONFORMING 10 N N N N N CONNECT 7 Y N N N N CONNECT_BY_COST_BASED 21 N N N N N CONNECT_BY_FILTERING 20 N N N N N CONNECT_BY_ISCYCLE 18 N N N N N CONNECT_BY_ISLEAF 17 N N N N N CONNECT_BY_ROOT 15 N N N N N CONNECT_TIME 12 N N N N N CONSIDER 8 N N N N N CONSISTENT 10 N N N N N CONSTRAINT 10 N N N N N CONSTRAINTS 11 N N N N Y CONTAINER 9 N N N N N CONTENT 7 N N N N N CONTENTS 8 N N N N N CONTEXT 7 N N N N N CONTINUE 8 N N N N N CONTROLFILE 11 N N N N N CONVERT 7 N N N N N CORRUPTION 10 N N N N N COST 4 N N N N N CPU_COSTING 11 N N N N N CPU_PER_CALL 12 N N N N N CPU_PER_SESSION 15 N N N N N CREATE 6 Y N N N N CREATE_STORED_OUTLINES 22 N N N N N CROSS 5 N N N N N CUBE 4 N N N N N CUBE_GB 7 N N N N N CURRENT 7 N N N Y N CURRENT_DATE 12 N N N N N CURRENT_SCHEMA 14 N N N N N CURRENT_TIME 12 N N N N N CURRENT_TIMESTAMP 17 N N N N N CURRENT_USER 12 N N N N N CURSOR 6 N N N N N CURSOR_SHARING_EXACT 20 N N N N N CURSOR_SPECIFIC_SEGMENT 23 N N N N N CYCLE 5 N N N N N DANGLING 8 N N N N N DATA 4 N N N N N DATABASE 8 N N N N N DATAFILE 8 N N N N N DATAFILES 9 N N N N N DATAOBJNO 9 N N N N N DATE 4 Y N N N N DATE_MODE 9 N N N N N DAY 3 N N N N N DBA 3 N N N N N DBA_RECYCLEBIN 14 N N N N N DBMS_STATS 10 N N N N N DB_ROLE_CHANGE 14 N N N N N DBTIMEZONE 10 N N N N N DDL 3 N N N N N DEALLOCATE 10 N N N N N DEBUG 5 N N N N N DEC 3 N N N N N DECIMAL 7 Y N N N Y DECLARE 7 N N N N N DECREMENT 9 N N N N N DECRYPT 7 N N N N N DEFAULT 7 Y N N N N DEFERRABLE 10 N N N N N DEFERRED 8 N N N N N DEFINED 7 N N N N N DEFINER 7 N N N N N DEGREE 6 N N N N N DELAY 5 N N N N N DELETE 6 Y N N N N DEMAND 6 N N N N N DENSE_RANK 10 N N N N N DEQUEUE 7 N N N N N DEREF 5 N N N N N DEREF_NO_REWRITE 16 N N N N N DESC 4 Y N N N N DETACHED 8 N N N N N DETERMINES 10 N N N N N DICTIONARY 10 N N N N N DIMENSION 9 N N N N N DIRECTORY 9 N N N N N DISABLE 7 N N N N N DISABLE_RPKE 12 N N N N N DISASSOCIATE 12 N N N N N DISCONNECT 10 N N N N N DISK 4 N N N N N DISKGROUP 9 N N N N N DISKS 5 N N N N N DISMOUNT 8 N N N N N DISTINCT 8 Y N N N N DISTINGUISHED 13 N N N N N DISTRIBUTED 11 N N N N N DML 3 N N N N N DML_UPDATE 10 N N N N N DOCUMENT 8 N N N N N DOMAIN_INDEX_NO_SORT 20 N N N N N DOMAIN_INDEX_SORT 17 N N N N N DOUBLE 6 N N N N N DOWNGRADE 9 N N N N N DRIVING_SITE 12 N N N N N DROP 4 Y N N N N DUMP 4 N N N N N DYNAMIC 7 N N N N N DYNAMIC_SAMPLING 16 N N N N N DYNAMIC_SAMPLING_EST_CDN 24 N N N N N E 1 N N N N N EACH 4 N N N N N ELEMENT 7 N N N N N ELIMINATE_JOIN 14 N N N N N ELIMINATE_OBY 13 N N N N N ELIMINATE_OUTER_JOIN 20 N N N N N ELSE 4 Y N N N N EMPTY 5 N N N N N ENABLE 6 N N N N N ENCRYPT 7 N N N N N ENCRYPTION 10 N N N N N END 3 N N N N N END_OUTLINE_DATA 16 N N N N N ENFORCE 7 N N N N N ENFORCED 8 N N N N N ENQUEUE 7 N N N N N ENTERPRISE 10 N N N N N ENTRY 5 N N N N N ERROR 5 N N N N N ERROR_ON_OVERLAP_TIME 21 N N N N N ERRORS 6 N N N N N ESCAPE 6 N N N N N ESTIMATE 8 N N N N N EVALNAME 8 N N N N N EVALUATION 10 N N N N N EVENTS 6 N N N N N EXCEPT 6 N N N N N EXCEPTIONS 10 N N N N N EXCHANGE 8 N N N N N EXCLUDING 9 N N N N N EXCLUSIVE 9 Y N N N N EXECUTE 7 N N N N N EXEMPT 6 N N N N N EXISTS 6 Y N N N N EXPAND_GSET_TO_UNION 20 N N N N N EXPIRE 6 N N N N N EXPLAIN 7 N N N N N EXPLOSION 9 N N N N N EXPORT 6 N N N N N EXPR_CORR_CHECK 15 N N N N N EXTENDS 7 N N N N N EXTENT 6 N N N N N EXTENTS 7 N N N N N EXTERNAL 8 N N N N N EXTERNALLY 10 N N N N N EXTRACT 7 N N N N N FACT 4 N N N N N FAILED 6 N N N N N FAILED_LOGIN_ATTEMPTS 21 N N N N N FAILGROUP 9 N N N N N FALSE 5 N N N N N FAST 4 N N N N N FBTSCAN 7 N N N N N FIC_CIV 7 N N N N N FIC_PIV 7 N N N N N FILE 4 N N N Y N FILTER 6 N N N N N FINAL 5 N N N N N FINE 4 N N N N N FINISH 6 N N N N N FIRST 5 N N N N N FIRST_ROWS 10 N N N N N FLAGGER 7 N N N N N FLASHBACK 9 N N N N N FLOAT 5 Y N N N N FLOB 4 N N N N N FLUSH 5 N N N N N FOLLOWING 9 N N N N N FOR 3 Y N N N N FORCE 5 N N N N N FORCE_XML_QUERY_REWRITE 23 N N N N N FOREIGN 7 N N N N N FREELIST 8 N N N N N FREELISTS 9 N N N N N FREEPOOLS 9 N N N N N FRESH 5 N N N N N FROM 4 Y N N N N FULL 4 N N N N N FUNCTION 8 N N N N N FUNCTIONS 9 N N N N N G 1 N N N N N GATHER_PLAN_STATISTICS 22 N N N N N GBY_CONC_ROLLUP 15 N N N N N GENERATED 9 N N N N N GLOBAL 6 N N N N N GLOBALLY 8 N N N N N GLOBAL_NAME 11 N N N N N GLOBAL_TOPIC_ENABLED 20 N N N N N GRANT 5 Y N N N N GROUP 5 Y N N N N GROUP_BY 8 N N N N N GROUPING 8 N N N N N GROUPS 6 N N N N N GUARANTEE 9 N N N N N GUARANTEED 10 N N N N N GUARD 5 N N N N N HASH 4 N N N N N HASH_AJ 7 N N N N N HASHKEYS 8 N N N N N HASH_SJ 7 N N N N N HAVING 6 Y N N N N HEADER 6 N N N N N HEAP 4 N N N N N HIERARCHY 9 N N N N N HIGH 4 N N N N N HINTSET_BEGIN 13 N N N N N HINTSET_END 11 N N N N N HOUR 4 N N N N N HWM_BROKERED 12 N N N N N ID 2 N N N N N IDENTIFIED 10 Y N N N N IDENTIFIER 10 N N N N N IDENTITY 8 N N N N N IDGENERATORS 12 N N N N N IDLE_TIME 9 N N N N N IF 2 N N N N N IGNORE 6 N N N N N IGNORE_OPTIM_EMBEDDED_HINTS 27 N N N N N IGNORE_WHERE_CLAUSE 19 N N N N N IMMEDIATE 9 N N N Y N IMPORT 6 N N N N N IN 2 Y N N N N INCLUDE_VERSION 15 N N N N N INCLUDING 9 N N N N N INCREMENT 9 N N N Y N INCREMENTAL 11 N N N N N INDEX 5 Y N N N N INDEX_ASC 9 N N N N N INDEX_COMBINE 13 N N N N N INDEX_DESC 10 N N N N N INDEXED 7 N N N N N INDEXES 7 N N N N N INDEX_FFS 9 N N N N N INDEX_FILTER 12 N N N N N INDEX_JOIN 10 N N N N N INDEX_ROWS 10 N N N N N INDEX_RRS 9 N N N N N INDEX_RS 8 N N N N Y INDEX_RS_ASC 12 N N N N N INDEX_RS_DESC 13 N N N N N INDEX_SCAN 10 N N N N N INDEX_SKIP_SCAN 15 N N N N N INDEX_SS 8 N N N N N INDEX_SS_ASC 12 N N N N N INDEX_SS_DESC 13 N N N N N INDEX_STATS 11 N N N N N INDEXTYPE 9 N N N N N INDEXTYPES 10 N N N N N INDICATOR 9 N N N N N INFINITE 8 N N N N N INFORMATIONAL 13 N N N N N INITIAL 7 N N N Y N INITIALIZED 11 N N N N N INITIALLY 9 N N N N N INITRANS 8 N N N N N INLINE 6 N N N N N INLINE_XMLTYPE_NT 17 N N N N N IN_MEMORY_METADATA 18 N N N N N INNER 5 N N N N N INSERT 6 Y N N N N INSTANCE 8 N N N N N INSTANCES 9 N N N N N INSTANTIABLE 12 N N N N N INSTANTLY 9 N N N N N INSTEAD 7 N N N N N INT 3 N N N N N INTEGER 7 Y N N N Y INTERMEDIATE 12 N N N N N INTERNAL_CONVERT 16 N N N N N INTERNAL_USE 12 N N N N N INTERPRETED 11 N N N N N INTERSECT 9 Y N N N N INTERVAL 8 N N N N N INTO 4 Y N N N N INVALIDATE 10 N N N N N IS 2 Y N N N N ISOLATION 9 N N N N N ISOLATION_LEVEL 15 N N N N N ITERATE 7 N N N N N ITERATION_NUMBER 16 N N N N N JAVA 4 N N N N N JOB 3 N N N N N JOIN 4 N N N N N K 1 N N N N N KEEP 4 N N N N N KERBEROS 8 N N N N N KEY 3 N N N N N KEY_LENGTH 10 N N N N N KEYS 4 N N N N N KEYSIZE 7 N N N N N KILL 4 N N N N N LAST 4 N N N N N LATERAL 7 N N N N N LAYER 5 N N N N N LDAP_REGISTRATION 17 N N N N N LDAP_REGISTRATION_ENABLED 25 N N N N N LDAP_REG_SYNC_INTERVAL 22 N N N N N LEADING 7 N N N N N LEFT 4 N N N N N LENGTH 6 N N N N N LESS 4 N N N N N LEVEL 5 N N N Y N LEVELS 6 N N N N N LIBRARY 7 N N N N N LIKE 4 Y N N N N LIKEC 5 N N N N N LIKE_EXPAND 11 N N N N N LIKE2 5 N N N N N LIKE4 5 N N N N N LIMIT 5 N N N N N LINK 4 N N N N N LIST 4 N N N N N LOB 3 N N N N N LOCAL 5 N N N N N LOCAL_INDEXES 13 N N N N N LOCALTIME 9 N N N N N LOCALTIMESTAMP 14 N N N N N LOCATION 8 N N N N N LOCATOR 7 N N N N N LOCK 4 Y N N N N LOCKED 6 N N N N N LOG 3 N N N N N LOGFILE 7 N N N N N LOGGING 7 N N N N N LOGICAL 7 N N N N N LOGICAL_READS_PER_CALL 22 N N N N N LOGICAL_READS_PER_SESSION 25 N N N N N LOGOFF 6 N N N N N LOGON 5 N N N N N LONG 4 Y N N N N M 1 N N N N N MAIN 4 N N N N N MANAGE 6 N N N N N MANAGED 7 N N N N N MANAGEMENT 10 N N N N N MANUAL 6 N N N N N MAPPING 7 N N N N N MASTER 6 N N N N N MATCHED 7 N N N N N MATERIALIZE 11 N N N N N MATERIALIZED 12 N N N N N MAX 3 N N N N N MAXARCHLOGS 11 N N N N Y MAXDATAFILES 12 N N N N N MAXEXTENTS 10 N N N Y N MAXIMIZE 8 N N N N N MAXINSTANCES 12 N N N N N MAXLOGFILES 11 N N N N N MAXLOGHISTORY 13 N N N N N MAXLOGMEMBERS 13 N N N N N MAXSIZE 7 N N N N N MAXTRANS 8 N N N N N MAXVALUE 8 N N N N N MEASURES 8 N N N N N MEMBER 6 N N N N N MEMORY 6 N N N N N MERGE 5 N N N N N MERGE_AJ 8 N N N N N MERGE_CONST_ON 14 N N N N N MERGE_SJ 8 N N N N N METHOD 6 N N N N N MIGRATE 7 N N N N N MIN 3 N N N N N MINEXTENTS 10 N N N N N MINIMIZE 8 N N N N N MINIMUM 7 N N N N N MINUS 5 Y N N N N MINUS_NULL 10 N N N N N MINUTE 6 N N N N N MINVALUE 8 N N N N N MIRROR 6 N N N N N MLSLABEL 8 N N N Y N MODE 4 Y N N N N MODEL 5 N N N N N MODEL_COMPILE_SUBQUERY 22 N N N N N MODEL_DONTVERIFY_UNIQUENESS 27 N N N N N MODEL_DYNAMIC_SUBQUERY 22 N N N N N MODEL_MIN_ANALYSIS 18 N N N N N MODEL_NO_ANALYSIS 17 N N N N N MODEL_PBY 9 N N N N N MODEL_PUSH_REF 14 N N N N N MODIFY 6 N N N Y N MONITORING 10 N N N N N MONTH 5 N N N N N MOUNT 5 N N N N N MOVE 4 N N N N N MOVEMENT 8 N N N N N MULTISET 8 N N N N N MV_MERGE 8 N N N N N NAME 4 N N N N N NAMED 5 N N N N N NAN 3 N N N N N NATIONAL 8 N N N N N NATIVE 6 N N N N N NATIVE_FULL_OUTER_JOIN 22 N N N N N NATURAL 7 N N N N N NAV 3 N N N N N NCHAR 5 N N N N N NCHAR_CS 8 N N N N N NCLOB 5 N N N N N NEEDED 6 N N N N N NESTED 6 N N N N N NESTED_TABLE_FAST_INSERT 24 N N N N N NESTED_TABLE_GET_REFS 21 N N N N N NESTED_TABLE_ID 15 N N Y N N NESTED_TABLE_SET_REFS 21 N N N N Y NESTED_TABLE_SET_SETID 22 N N N N N NETWORK 7 N N N N N NEVER 5 N N N N N NEW 3 N N N N N NEXT 4 N N N N N NL_AJ 5 N N N N N NLS_CALENDAR 12 N N N N N NLS_CHARACTERSET 16 N N N N N NLS_COMP 8 N N N N N NLS_CURRENCY 12 N N N N N NLS_DATE_FORMAT 15 N N N N N NLS_DATE_LANGUAGE 17 N N N N N NLS_ISO_CURRENCY 16 N N N N N NL_SJ 5 N N N N N NLS_LANG 8 N N N N N NLS_LANGUAGE 12 N N N N N NLS_LENGTH_SEMANTICS 20 N N N N N NLS_NCHAR_CONV_EXCP 19 N N N N N NLS_NUMERIC_CHARACTERS 22 N N N N N NLS_SORT 8 N N N N N NLS_SPECIAL_CHARS 17 N N N N N NLS_TERRITORY 13 N N N N N NO 2 N N N N N NO_ACCESS 9 N N N N N NOAPPEND 8 N N N N N NOARCHIVELOG 12 N N N N N NOAUDIT 7 N N N Y N NO_BASETABLE_MULTIMV_REWRITE 28 N N N N N NO_BUFFER 9 N N N N N NOCACHE 7 N N N N N NO_CARTESIAN 12 N N N N N NOCOMPRESS 10 Y N N N N NO_CONNECT_BY_COST_BASED 24 N N N N N NO_CONNECT_BY_FILTERING 23 N N N N N NO_CPU_COSTING 14 N N N N N NOCPU_COSTING 13 N N N N Y NOCYCLE 7 N N N N N NODELAY 7 N N N N N NO_ELIMINATE_JOIN 17 N N N N N NO_ELIMINATE_OBY 16 N N N N N NO_ELIMINATE_OUTER_JOIN 23 N N N N N NO_EXPAND 9 N N N N N NO_EXPAND_GSET_TO_UNION 23 N N N N N NO_FACT 7 N N N N N NO_FILTERING 12 N N N N Y NOFORCE 7 N N N N N NOGUARANTEE 11 N N N N N NO_INDEX 8 N N N N N NO_INDEX_FFS 12 N N N N N NO_INDEX_RS 11 N N N N N NO_INDEX_SS 11 N N N N N NOLOGGING 9 N N N N N NOMAPPING 9 N N N N N NOMAXVALUE 10 N N N N N NO_MERGE 8 N N N N N NOMINIMIZE 10 N N N N N NOMINVALUE 10 N N N N N NO_MODEL_PUSH_REF 17 N N N N N NO_MONITORING 13 N N N N N NOMONITORING 12 N N N N N NO_MULTIMV_REWRITE 18 N N N N N NO_NATIVE_FULL_OUTER_JOIN 25 N N N N N NONE 4 N N N N N NOORDER 7 N N N N N NO_ORDER_ROLLUPS 16 N N N N N NOOVERRIDE 10 N N N N N NO_PARALLEL 11 N N N N N NOPARALLEL 10 N N N N N NO_PARALLEL_INDEX 17 N N N N N NOPARALLEL_INDEX 16 N N N N Y NO_PARTIAL_COMMIT 17 N N N N N NO_PRUNE_GSETS 14 N N N N N NO_PULL_PRED 12 N N N N N NO_PUSH_PRED 12 N N N N N NO_PUSH_SUBQ 12 N N N N N NO_PX_JOIN_FILTER 17 N N N N N NO_QKN_BUFF 11 N N N N N NO_QUERY_TRANSFORMATION 23 N N N N N NO_REF_CASCADE 14 N N N N N NORELY 6 N N N N N NOREPAIR 8 N N N N N NORESETLOGS 11 N N N N N NOREVERSE 9 N N N N N NO_REWRITE 10 N N N N N NOREWRITE 9 N N N N Y NORMAL 6 N N N N N NOROWDEPENDENCIES 17 N N N N N NOSEGMENT 9 N N N N N NO_SEMIJOIN 11 N N N N N NO_SET_TO_JOIN 14 N N N N N NOSORT 6 N N N N N NO_SQL_TUNE 11 N N N N N NO_STAR_TRANSFORMATION 22 N N N N N NO_STATS_GSETS 14 N N N N N NOSTRICT 8 N N N N N NO_SWAP_JOIN_INPUTS 19 N N N N N NOSWITCH 8 N N N N N NOT 3 Y N N N N NO_TEMP_TABLE 13 N N N N N NOTHING 7 N N N N N NOTIFICATION 12 N N N N N NO_UNNEST 9 N N N N N NO_USE_HASH 11 N N N N N NO_USE_HASH_AGGREGATION 23 N N N N N NO_USE_MERGE 12 N N N N N NO_USE_NL 9 N N N N N NOVALIDATE 10 N N N N N NOWAIT 6 Y N N N N NO_XML_DML_REWRITE 18 N N N N N NO_XML_QUERY_REWRITE 20 N N N N N NULL 4 Y N N N N NULLS 5 N N N N N NUMBER 6 Y N N N N NUMERIC 7 N N N N N NUM_INDEX_KEYS 14 N N N N N NVARCHAR2 9 N N N N N OBJECT 6 N N N N N OBJNO 5 N N N N N OBJNO_REUSE 11 N N N N N OF 2 Y N N N N OFF 3 N N N N N OFFLINE 7 N N N Y N OID 3 N N N N N OIDINDEX 8 N N N N N OLD 3 N N N N N OLD_PUSH_PRED 13 N N N N N ON 2 Y N N N N ONLINE 6 N N N Y N ONLY 4 N N N N N OPAQUE 6 N N N N N OPAQUE_TRANSFORM 16 N N N N N OPAQUE_XCANONICAL 17 N N N N N OPCODE 6 N N N N N OPEN 4 N N N N N OPERATOR 8 N N N N N OPT_ESTIMATE 12 N N N N N OPTIMAL 7 N N N N N OPTIMIZER_FEATURES_ENABLE 25 N N N N N OPTIMIZER_GOAL 14 N N N N N OPTION 6 Y N N N N OPT_PARAM 9 N N N N N OR 2 Y N N N N ORA_ROWSCN 10 N N N N N ORDER 5 Y N N N N ORDERED 7 N N N N N ORDERED_PREDICATES 18 N N N N N ORDINALITY 10 N N N N N OR_EXPAND 9 N N N N N ORGANIZATION 12 N N N N N OUTER 5 N N N N N OUTLINE 7 N N N N N OUTLINE_LEAF 12 N N N N N OUT_OF_LINE 11 N N N N N OVER 4 N N N N N OVERFLOW 8 N N N N N OVERFLOW_NOMOVE 15 N N N N N OVERLAPS 8 N N N N N OWN 3 N N N N N P 1 N N N N N PACKAGE 7 N N N N N PACKAGES 8 N N N N N PARALLEL 8 N N N N Y PARALLEL_INDEX 14 N N N N N PARAMETERS 10 N N N N N PARENT 6 N N N N N PARITY 6 N N N N N PARTIALLY 9 N N N N N PARTITION 9 N N N N N PARTITION_HASH 14 N N N N N PARTITION_LIST 14 N N N N N PARTITION_RANGE 15 N N N N N PARTITIONS 10 N N N N N PASSING 7 N N N N N PASSWORD 8 N N N N N PASSWORD_GRACE_TIME 19 N N N N N PASSWORD_LIFE_TIME 18 N N N N N PASSWORD_LOCK_TIME 18 N N N N N PASSWORD_REUSE_MAX 18 N N N N N PASSWORD_REUSE_TIME 19 N N N N N PASSWORD_VERIFY_FUNCTION 24 N N N N N PATH 4 N N N N N PATHS 5 N N N N N PCTFREE 7 Y N N N N PCTINCREASE 11 N N N N N PCTTHRESHOLD 12 N N N N N PCTUSED 7 N N N N N PCTVERSION 10 N N N N N PERCENT 7 N N N N N PERFORMANCE 11 N N N N N PERMANENT 9 N N N N N PFILE 5 N N N N N PHYSICAL 8 N N N N N PIV_GB 6 N N N N N PIV_SSF 7 N N N N N PLAN 4 N N N N N PLSQL_CCFLAGS 13 N N N N N PLSQL_CODE_TYPE 15 N N N N N PLSQL_DEBUG 11 N N N N N PLSQL_OPTIMIZE_LEVEL 20 N N N N N PLSQL_WARNINGS 14 N N N N N POINT 5 N N N N N POLICY 6 N N N N N POST_TRANSACTION 16 N N N N N POWER 5 N N N N N PQ_DISTRIBUTE 13 N N N N N PQ_MAP 6 N N N N N PQ_NOMAP 8 N N N N N PREBUILT 8 N N N N N PRECEDING 9 N N N N N PRECISION 9 N N N N N PRECOMPUTE_SUBQUERY 19 N N N N N PREPARE 7 N N N N N PRESENT 7 N N N N N PRESERVE 8 N N N N N PRESERVE_OID 12 N N N N N PRIMARY 7 N N N N N PRIOR 5 Y N N N N PRIVATE 7 N N N N N PRIVATE_SGA 11 N N N N N PRIVILEGE 9 N N N N Y PRIVILEGES 10 N N N Y N PROCEDURE 9 N N N N N PROFILE 7 N N N N N PROGRAM 7 N N N N N PROJECT 7 N N N N N PROTECTED 9 N N N N N PROTECTION 10 N N N N N PUBLIC 6 Y N N N N PULL_PRED 9 N N N N N PURGE 5 N N N N N PUSH_PRED 9 N N N N N PUSH_SUBQ 9 N N N N N PX_GRANULE 10 N N N N N PX_JOIN_FILTER 14 N N N N N QB_NAME 7 N N N N N QUERY 5 N N N N N QUERY_BLOCK 11 N N N N N QUEUE 5 N N N N N QUEUE_CURR 10 N N N N N QUEUE_ROWP 10 N N N N N QUIESCE 7 N N N N N QUOTA 5 N N N N N RANDOM 6 N N N N N RANGE 5 N N N N N RAPIDLY 7 N N N N N RAW 3 Y N N N N RBA 3 N N N N N RBO_OUTLINE 11 N N N N N READ 4 N N N N N READS 5 N N N N N REAL 4 N N N N N REBALANCE 9 N N N N N REBUILD 7 N N N N N RECORDS_PER_BLOCK 17 N N N N N RECOVER 7 N N N N N RECOVERABLE 11 N N N N N RECOVERY 8 N N N N N RECYCLE 7 N N N N N RECYCLEBIN 10 N N N N N REDUCED 7 N N N N N REDUNDANCY 10 N N N N N REF 3 N N N N N REF_CASCADE_CURSOR 18 N N N N N REFERENCE 9 N N N N N REFERENCED 10 N N N N N REFERENCES 10 N N N N N REFERENCING 11 N N N N Y REFRESH 7 N N N N N REGEXP_LIKE 11 N N N N N REGISTER 8 N N N N N REJECT 6 N N N N N REKEY 5 N N N N N RELATIONAL 10 N N N N N RELY 4 N N N N N REMOTE_MAPPED 13 N N N N N RENAME 6 Y N N N N REPAIR 6 N N N N N REPLACE 7 N N N N N REQUIRED 8 N N N N N RESET 5 N N N N N RESETLOGS 9 N N N N N RESIZE 6 N N N N N RESOLVE 7 N N N N N RESOLVER 8 N N N N N RESOURCE 8 Y N N N N RESTORE 7 N N N N N RESTORE_AS_INTERVALS 20 N N N N N RESTRICT 8 N N N N N RESTRICT_ALL_REF_CONS 21 N N N N N RESTRICTED 10 N N N N N RESUMABLE 9 N N N N N RESUME 6 N N N N N RETENTION 9 N N N N N RETURN 6 N N N N N RETURNING 9 N N N N N REUSE 5 N N N N N REVERSE 7 N N N N N REVOKE 6 Y N N N N REWRITE 7 N N N N N REWRITE_OR_ERROR 16 N N N N N RIGHT 5 N N N N N ROLE 4 N N N N N ROLES 5 N N N N Y ROLLBACK 8 N N N N N ROLLING 7 N N N N N ROLLUP 6 N N N N N ROW 3 N N N Y N ROWDEPENDENCIES 15 N N N N N ROWID 5 N N N Y N ROW_LENGTH 10 N N N N N ROWNUM 6 N N N Y N ROWS 4 N N N Y N RULE 4 N N N N N RULES 5 N N N N N SALT 4 N N N N N SAMPLE 6 N N N N N SAVE_AS_INTERVALS 17 N N N N N SAVEPOINT 9 N N N N N SB4 3 N N N N Y SCALE 5 N N N N N SCALE_ROWS 10 N N N N N SCAN 4 N N N N N SCAN_INSTANCES 14 N N N N N SCHEDULER 9 N N N N N SCHEMA 6 N N N N N SCN 3 N N N N N SCN_ASCENDING 13 N N N N N SCOPE 5 N N N N N SD_ALL 6 N N N N N SD_INHIBIT 10 N N N N N SD_SHOW 7 N N N N N SECOND 6 N N N N N SECURITY 8 N N N N N SEED 4 N N N N N SEG_BLOCK 9 N N N N N SEG_FILE 8 N N N N N SEGMENT 7 N N N N N SELECT 6 Y N N N N SELECTIVITY 11 N N N N N SEMIJOIN 8 N N N N N SEMIJOIN_DRIVER 15 N N N N N SEQUENCE 8 N N N N N SEQUENCED 9 N N N N N SEQUENTIAL 10 N N N N N SERIALIZABLE 12 N N N N N SERVERERROR 11 N N N N N SESSION 7 N N N Y N SESSION_CACHED_CURSORS 22 N N N N N SESSIONS_PER_USER 17 N N N N N SESSIONTIMEZONE 15 N N N N N SESSIONTZNAME 13 N N N N N SET 3 Y N N N N SETS 4 N N N N N SETTINGS 8 N N N N N SET_TO_JOIN 11 N N N N N SEVERE 6 N N N N N SHARE 5 Y N N N N SHARED 6 N N N N N SHARED_POOL 11 N N N N N SHRINK 6 N N N N N SHUTDOWN 8 N N N N N SIBLINGS 8 N N N N N SID 3 N N N N N SIMPLE 6 N N N N N SINGLE 6 N N N N N SINGLETASK 10 N N N N N SIZE 4 Y N N N N SKIP 4 N N N N N SKIP_EXT_OPTIMIZER 18 N N N N N SKIP_UNQ_UNUSABLE_IDX 21 N N N N N SKIP_UNUSABLE_INDEXES 21 N N N N N SMALLFILE 9 N N N N N SMALLINT 8 Y N N N Y SNAPSHOT 8 N N N N N SOME 4 N N N N N SORT 4 N N N N N SOURCE 6 N N N N N SPACE 5 N N N N N SPECIFICATION 13 N N N N N SPFILE 6 N N N N N SPLIT 5 N N N N N SPREADSHEET 11 N N N N N SQL 3 N N N N N SQLLDR 6 N N N N N SQL_TRACE 9 N N N N N STANDALONE 10 N N N N N STANDBY 7 N N N N N STAR 4 N N N N N START 5 Y N N N N STAR_TRANSFORMATION 19 N N N N N STARTUP 7 N N N N N STATEMENT_ID 12 N N N N N STATIC 6 N N N N N STATISTICS 10 N N N N N STOP 4 N N N N N STORAGE 7 N N N N N STORE 5 N N N N N STREAMS 7 N N N N N STRICT 6 N N N N N STRING 6 N N N N N STRIP 5 N N N N N STRUCTURE 9 N N N N N SUBMULTISET 11 N N N N N SUBPARTITION 12 N N N N N SUBPARTITION_REL 16 N N N N N SUBPARTITIONS 13 N N N N N SUBQUERIES 10 N N N N N SUBSTITUTABLE 13 N N N N N SUCCESSFUL 10 N N N Y N SUMMARY 7 N N N N N SUPPLEMENTAL 12 N N N N N SUSPEND 7 N N N N N SWAP_JOIN_INPUTS 16 N N N N N SWITCH 6 N N N N N SWITCHOVER 10 N N N N N SYNONYM 7 Y N N N N SYSAUX 6 N N N N N SYSDATE 7 N N N Y N SYSDBA 6 N N N N N SYS_DL_CURSOR 13 N N N N N SYS_FBT_INSDEL 14 N N N N N SYS_OP_BITVEC 13 N N N N N SYS_OP_CAST 11 N N N N N SYS_OP_ENFORCE_NOT_NULL$ 24 N N N N N SYSOPER 7 N N N N N SYS_OP_EXTRACT 14 N N N N N SYS_OP_NOEXPAND 15 N N N N N SYS_OP_NTCIMG$ 14 N N N N N SYS_PARALLEL_TXN 16 N N N N N SYS_RID_ORDER 13 N N N N N SYSTEM 6 N N N N N SYSTIMESTAMP 12 N N N N N T 1 N N N N N TABLE 5 Y N N N N TABLES 6 N N N N N TABLESPACE 10 N N N N N TABLESPACE_NO 13 N N N N N TABLE_STATS 11 N N N N N TABNO 5 N N N N N TEMPFILE 8 N N N N N TEMPLATE 8 N N N N N TEMPORARY 9 N N N N N TEMP_TABLE 10 N N N N N TEST 4 N N N N N THAN 4 N N N N N THE 3 N N N N N THEN 4 Y N N N N THREAD 6 N N N N N THROUGH 7 N N N N N TIME 4 N N N N N TIMEOUT 7 N N N N N TIMESTAMP 9 N N N N N TIME_ZONE 9 N N N N N TIMEZONE_ABBR 13 N N N N N TIMEZONE_HOUR 13 N N N N N TIMEZONE_MINUTE 15 N N N N N TIMEZONE_OFFSET 15 N N N N N TIMEZONE_REGION 15 N N N N N TIV_GB 6 N N N N N TIV_SSF 7 N N N N N TO 2 Y N N N N TO_CHAR 7 N N N N N TOPLEVEL 8 N N N N N TRACE 5 N N N N N TRACING 7 N N N N N TRACKING 8 N N N N N TRAILING 8 N N N N N TRANSACTION 11 N N N N N TRANSITIONAL 12 N N N N N TREAT 5 N N N N N TRIGGER 7 Y N N N N TRIGGERS 8 N N N N N TRUE 4 N N N N N TRUNCATE 8 N N N N N TRUSTED 7 N N N N N TUNING 6 N N N N N TX 2 N N N N N TYPE 4 N N N N N TYPES 5 N N N N N TZ_OFFSET 9 N N N N N U 1 N N N N N UBA 3 N N N N N UB2 3 N N N N Y UID 3 N N N Y N UNARCHIVED 10 N N N N N UNBOUND 7 N N N N N UNBOUNDED 9 N N N N N UNDER 5 N N N N N UNDO 4 N N N N N UNDROP 6 N N N N N UNIFORM 7 N N N N N UNION 5 Y N N N N UNIQUE 6 Y N N N N UNLIMITED 9 N N N N N UNLOCK 6 N N N N N UNNEST 6 N N N N N UNPACKED 8 N N N N N UNPROTECTED 11 N N N N N UNQUIESCE 9 N N N N N UNRECOVERABLE 13 N N N N N UNTIL 5 N N N N N UNUSABLE 8 N N N N N UNUSED 6 N N N N N UPDATABLE 9 N N N N N UPDATE 6 Y N N N N UPDATED 7 N N N N N UPD_INDEXES 11 N N N N N UPD_JOININDEX 13 N N N N N UPGRADE 7 N N N N N UPSERT 6 N N N N N UROWID 6 N N N N N USAGE 5 N N N N N USE 3 N N N N N USE_ANTI 8 N N N N N USE_CONCAT 10 N N N N N USE_HASH 8 N N N N N USE_HASH_AGGREGATION 20 N N N N N USE_MERGE 9 N N N N N USE_NL 6 N N N N N USE_NL_WITH_INDEX 17 N N N N N USE_PRIVATE_OUTLINES 20 N N N N N USER 4 N N N Y N USER_DEFINED 12 N N N N N USER_RECYCLEBIN 15 N N N N N USERS 5 N N N N N USE_SEMI 8 N N N N N USE_STORED_OUTLINES 19 N N N N N USE_TTT_FOR_GSETS 17 N N N N N USE_WEAK_NAME_RESL 18 N N N N N USING 5 N N N N N VALIDATE 8 N N N Y N VALIDATION 10 N N N N N VALUE 5 N N N N N VALUES 6 Y N N N N VARCHAR 7 Y N N N N VARCHAR2 8 Y N N N N VARRAY 6 N N N N N VARYING 7 N N N N N VECTOR_READ 11 N N N N N VECTOR_READ_TRACE 17 N N N N N VERSION 7 N N N N N VERSIONS 8 N N N N N VIEW 4 Y N N N N WAIT 4 N N N N N WALLET 6 N N N N N WELLFORMED 10 N N N N N WHEN 4 N N N N N WHENEVER 8 N N N Y N WHERE 5 Y N N N N WHITESPACE 10 N N N N N WITH 4 Y N N N N WITHIN 6 N N N N N WITHOUT 7 N N N N N WORK 4 N N N N N WRAPPED 7 N N N N N WRITE 5 N N N N N X_DYN_PRUNE 11 N N N N N XID 3 N N N N N XMLATTRIBUTES 13 N N N N N XMLCOLATTVAL 12 N N N N N XML_DML_RWT_STMT 16 N N N N N XMLELEMENT 10 N N N N N XMLFOREST 9 N N N N N XMLNAMESPACES 13 N N N N N XMLPARSE 8 N N N N N XMLPI 5 N N N N N XMLQUERY 8 N N N N N XMLROOT 7 N N N N N XMLSCHEMA 9 N N N N N XMLSERIALIZE 12 N N N N N XMLTABLE 8 N N N N N XMLTYPE 7 N N N N N YEAR 4 N N N N N YES 3 N N N N N ZONE 4 N N N N N