v$reserved_words

DB 예약된 키워드를 검색한다.

• KEYWORD: 예약된 키워드의 이름
• LENGTH: 키워드의 길이
• R: 키워드가 DML(데이터 조작 언어)에서 읽기(R) 작업에 사용될 수 있는지 여부를 
• D: 키워드가 DML에서 쓰기(D) 작업에 사용될 수 있는지 여부

 

SYS@orcl>select * from v$reserved_words;

KEYWORD                            LENGTH R R R R D     CON_ID
------------------------------ ---------- - - - - - ----------
GUARD                                   5 N N N N N          0
D                                       1 N N N N N          0
GUARANTEED                             10 N N N N N          0
VECTOR_READ_TRACE                      17 N N N N N          0
INFORMATIONAL                          13 N N N N N          0
LEAST                                   5 N N N N N          0
QUERY                                   5 N N N N N          0
MIGRATION                               9 N N N N N          0
LOG_READ_ONLY_VIOLATIONS               24 N N N N N          0
RAPIDLY                                 7 N N N N N          0
NOCACHE                                 7 N N N N N          0
LIKEC                                   5 N N N N N          0
NLS_NUMERIC_CHARACTERS                 22 N N N N N          0
FILE_NAME_CONVERT                      17 N N N N N          0
SYS_OP_PARGID_1                        15 N N N N N          0
CONNECT_BY_ROOT                        15 N N N N N          0
MEASURE                                 7 N N N N N          0
SYS_OP_TPR                             10 N N N N N          0
ORA_DST_CONVERT                        15 N N N N N          0
USE_NL                                  6 N N N N N          0
NOLOGGING                               9 N N N N N          0
SYNCHRONOUS                            11 N N N N N          0
PARALLEL                                8 N N N N Y          0
MAXTRANS                                8 N N N N N          0
DAYS                                    4 N N N N N          0
SYS_OP_LOBLOC2NCLOB                    19 N N N N N          0
JSONGET                                 7 N N N N N          0
STANDBYS                                8 N N N N N          0
COVAR_SAMP                             10 N N N N N          0
MONITOR                                 7 N N N N N          0
SYS_XQNSP4PFX                          13 N N N N N          0
MATCH                                   5 N N N N N          0
POST_TRANSACTION                       16 N N N N N          0
XMLROOT                                 7 N N N N N          0
ASCIISTR                                8 N N N N N          0
HEADER                                  6 N N N N N          0
NUM_INDEX_KEYS                         14 N N N N N          0
DROP                                    4 Y N N N N          0
PERCENT_RANK                           12 N N N N N          0
SUMMARY                                 7 N N N N N          0
CACHE_TEMP_TABLE                       16 N N N N N          0
PARTITIONS                             10 N N N N N          0
PLUGGABLE                               9 N N N N N          0
SYS_OP_NIX                             10 N N N N N          0
SYS_XMLT_2_SC                          13 N N N N N          0
UTF8                                    4 N N N N N          0
VERSION                                 7 N N N N N          0
TO_TIME                                 7 N N N N N          0
TX                                      2 N N N N N          0
NO_BUFFER                               9 N N N N N          0
OWN                                     3 N N N N N          0
OUTER_JOIN_TO_ANTI                     18 N N N N N          0
ORA_CHECK_PRIVILEGE                    19 N N N N N          0
TO_TIME_TZ                             10 N N N N N          0
AUTHORIZATION                          13 N N N N N          0
MOVE                                    4 N N N N N          0