SELECT * FROM v$reserved_words; SUCCESSFUL 10 N N N Y N CURRENT_SCHEMA 14 N N N N N INT 3 N N N N N ROWS 4 N N N Y N DANGLING 8 N N N N N TRUE 4 N N N N N KEYWORD LENGTH R R R R D ------------------------------ ---------- - - - - - XMLTABLE 8 N N N N N ZONE 4 N N N N N NLS_NUMERIC_CHARACTERS 22 N N N N N | 1 Y N N N N BACKUP 6 N N N N N DEBUG 5 N N N N N UPDATED 7 N N N N N RESTRICTED 10 N N N N N NO_EXPAND_GSET_TO_UNION 23 N N N N N STATEMENT_ID 12 N N N N N GLOBAL_NAME 11 N N N N N KEYWORD LENGTH R R R R D ------------------------------ ---------- - - - - - AUTHORIZATION 13 N N N N N NO_USE_MERGE 12 N N N N N OPAQUE_TRANSFORM 16 N N N N N ARRAY 5 N N N N N MEASURES 8 N N N N N VALIDATE 8 N N N Y N CREATE 6 Y N N N N MODEL 5 N N N N N CASE 4 N N N N N CONNECT_TIME 12 N N N N N OPTIMIZER_GOAL 14 N N N N N KEYWORD LENGTH R R R R D ------------------------------ ---------- - - - - - SUPPLEMENTAL 12 N N N N N > 1 Y N N N N INTERSECT 9 Y N N N N ] 1 Y N N N N PCTFREE 7 Y N N N N OPEN 4 N N N N N ANALYZE 7 N N N N N RECOVER 7 N N N N N DB_ROLE_CHANGE 14 N N N N N BLOCKS 6 N N N N N MAXINSTANCES 12 N N N N N KEYWORD LENGTH R R R R D ------------------------------ ---------- - - - - - DDL 3 N N N N N NOVALIDATE 10 N N N N N PRESERVE 8 N N N N N CUBE 4 N N N N N OPT_PARAM 9 N N N N N DISTINCT 8 Y N N N N CLEAR 5 N N N N N ANTIJOIN 8 N N N N N CHECKPOINT 10 N N N N N IDLE_TIME 9 N N N N N SYSOPER 7 N N N N N KEYWORD LENGTH R R R R D ------------------------------ ---------- - - - - - CONNECT 7 Y N N N N ORDINALITY 10 N N N N N SCALE_ROWS 10 N N N N N ARCHIVELOG 10 N N N N N CERTIFICATE 11 N N N N N NORMAL 6 N N N N N USE_TTT_FOR_GSETS 17 N N N N N TABLES 6 N N N N N SET 3 Y N N N N UPGRADE 7 N N N N N K 1 N N N N N KEYWORD LENGTH R R R R D ------------------------------ ---------- - - - - - MERGE_SJ 8 N N N N N NOARCHIVELOG 12 N N N N N CONTROLFILE 11 N N N N N IDENTITY 8 N N N N N PERFORMANCE 11 N N N N N INSTANTLY 9 N N N N N MAPPING 7 N N N N N MODE 4 Y N N N N SHRINK 6 N N N N N VARYING 7 N N N N N LOGICAL_READS_PER_SESSION 25 N N N N N KEYWORD LENGTH R R R R D ------------------------------ ---------- - - - - - USE_HASH_AGGREGATION 20 N N N N N DEFERRED 8 N N N N N REPAIR 6 N N N N N NO_SWAP_JOIN_INPUTS 19 N N N N N GLOBAL_TOPIC_ENABLED 20 N N N N N ELIMINATE_OBY 13 N N N N N SUBSTITUTABLE 13 N N N N N INVALIDATE 10 N N N N N NLS_CALENDAR 12 N N N N N LAYER 5 N N N N N BATCH 5 N N N N N KEYWORD LENGTH R R R R D ------------------------------ ---------- - - - - - KEY_LENGTH 10 N N N N N INCREMENT 9 N N N Y N OF 2 Y N N N N BUILD 5 N N N N N ORDERED 7 N N N N N MONTH 5 N N N N N NCLOB 5 N N N N N EXPR_CORR_CHECK 15 N N N N N CLOSE 5 N N N N N MEMORY 6 N N N N N UROWID 6 N N N N N KEYWORD LENGTH R R R R D ------------------------------ ---------- - - - - - EVENTS 6 N N N N N ALL_ROWS 8 N N N N N SYS_OP_ENFORCE_NOT_NULL$ 24 N N N N N CALL 4 N N N N N MAXARCHLOGS 11 N N N N Y COMPUTE 7 N N N N N USE_WEAK_NAME_RESL 18 N N N N N NOMINIMIZE 10 N N N N N WHEN 4 N N N N N SPREADSHEET 11 N N N N N NL_AJ 5 N N N N N KEYWORD LENGTH R R R R D ------------------------------ ---------- - - - - - * 1 Y N N N N BUFFER_POOL 11 N N N N N MERGE_AJ 8 N N N N N A 1 N N N N N SIBLINGS 8 N N N N N UNIQUE 6 Y N N N N VARCHAR2 8 Y N N N N SKIP_UNUSABLE_INDEXES 21 N N N N N ) 1 Y N N N N USER_DEFINED 12 N N N N N LOG 3 N N N N N KEYWORD LENGTH R R R R D ------------------------------ ---------- - - - - - IMPORT 6 N N N N N NESTED_TABLE_SET_SETID 22 N N N N N LEVELS 6 N N N N N PERCENT 7 N N N N N PUSH_PRED 9 N N N N N VARCHAR 7 Y N N N N REFERENCE 9 N N N N N CURSOR 6 N N N N N RESUME 6 N N N N N NO_CPU_COSTING 14 N N N N N SIMPLE 6 N N N N N KEYWORD LENGTH R R R R D ------------------------------ ---------- - - - - - ( 1 Y N N N N TIME_ZONE 9 N N N N N LOCK 4 Y N N N N WHITESPACE 10 N N N N N NLS_CURRENCY 12 N N N N N OR 2 Y N N N N PLSQL_WARNINGS 14 N N N N N PLSQL_DEBUG 11 N N N N N EXECUTE 7 N N N N N CATEGORY 8 N N N N N AUTHID 6 N N N N N KEYWORD LENGTH R R R R D ------------------------------ ---------- - - - - - ATTRIBUTE 9 N N N N N FIRST 5 N N N N N CHAR 4 Y N N N Y USER_RECYCLEBIN 15 N N N N N DEALLOCATE 10 N N N N N DECIMAL 7 Y N N N Y TREAT 5 N N N N N NEVER 5 N N N N N CYCLE 5 N N N N N HASH_SJ 7 N N N N N UNDROP 6 N N N N N KEYWORD LENGTH R R R R D ------------------------------ ---------- - - - - - MODEL_DONTVERIFY_UNIQUENESS 27 N N N N N LOGGING 7 N N N N N INDEX_DESC 10 N N N N N PASSING 7 N N N N N BINARY_FLOAT_INFINITY 21 N N N N N SORT 4 N N N N N UNION 5 Y N N N N NOMAPPING 9 N N N N N TIMEZONE_ABBR 13 N N N N N NODELAY 7 N N N N N QUERY_BLOCK 11 N N N N N KEYWORD LENGTH R R R R D ------------------------------ ---------- - - - - - PARTITION_RANGE 15 N N N N N SCN 3 N N N N N ALLOCATE 8 N N N N N SUMMARY 7 N N N N N INDEX_STATS 11 N N N N N DISTINGUISHED 13 N N N N N INTERNAL_CONVERT 16 N N N N N NO_USE_NL 9 N N N N N NCHAR_CS 8 N N N N N SYS_OP_CAST 11 N N N N N DOWNGRADE 9 N N N N N KEYWORD LENGTH R R R R D ------------------------------ ---------- - - - - - PUBLIC 6 Y N N N N NO_INDEX_SS 11 N N N N N AND 3 Y N N N N NESTED 6 N N N N N PLSQL_CODE_TYPE 15 N N N N N REFERENCES 10 N N N N N E 1 N N N N N PARITY 6 N N N N N MAXLOGFILES 11 N N N N N NO_FACT 7 N N N N N PACKAGE 7 N N N N N KEYWORD LENGTH R R R R D ------------------------------ ---------- - - - - - XMLSERIALIZE 12 N N N N N NEEDED 6 N N N N N JAVA 4 N N N N N USE_PRIVATE_OUTLINES 20 N N N N N DEREF 5 N N N N N OUTLINE 7 N N N N N SET_TO_JOIN 11 N N N N N UNUSABLE 8 N N N N N VERSIONS 8 N N N N N NCHAR 5 N N N N N EXTENTS 7 N N N N N KEYWORD LENGTH R R R R D ------------------------------ ---------- - - - - - SESSIONTIMEZONE 15 N N N N N INSTEAD 7 N N N N N NATURAL 7 N N N N N MONITORING 10 N N N N N SAVEPOINT 9 N N N N N STATIC 6 N N N N N INDEX_SCAN 10 N N N N N RESUMABLE 9 N N N N N RANGE 5 N N N N N RESTORE 7 N N N N N MANAGEMENT 10 N N N N N KEYWORD LENGTH R R R R D ------------------------------ ---------- - - - - - COMPATIBILITY 13 N N N N N START 5 Y N N N N CHAINED 7 N N N N N ROLLBACK 8 N N N N N PRIMARY 7 N N N N N UNDER 5 N N N N N PARALLEL 8 N N N N Y TIV_GB 6 N N N N N COMPACT 7 N N N N N OPTIMAL 7 N N N N N CUBE_GB 7 N N N N N KEYWORD LENGTH R R R R D ------------------------------ ---------- - - - - - INCLUDE_VERSION 15 N N N N N PARALLEL_INDEX 14 N N N N N FINE 4 N N N N N BINARY_DOUBLE_NAN 17 N N N N N INDEXTYPE 9 N N N N N CHARACTER 9 N N N N N OUTLINE_LEAF 12 N N N N N MIN 3 N N N N N INNER 5 N N N N N MINUTE 6 N N N N N NLS_LANGUAGE 12 N N N N N KEYWORD LENGTH R R R R D ------------------------------ ---------- - - - - - STRING 6 N N N N N CAST 4 N N N N N UNARCHIVED 10 N N N N N PROFILE 7 N N N N N SAMPLE 6 N N N N N 0 N N N N N 0 N N N N N 已选择1129行。 SQL>
SELECT * FROM v$reserved_words WHERE keyword IN (SELECT column_name FROM all_tab_columns WHERE table_name = 'TS_BIZ_TEST' AND owner='VHLUAMS');
SELECT * FROM v$reserved_words WHERE keyword = 'ID';
SELECT * FROM v$reserved_words WHERE keyword = 'OPTION';
