【oracle】java.sql.SQLException: ORA-01747: user.table.column, table.column 或列说明无效

3 篇文章 0 订阅
2 篇文章 0 订阅

1. 报错

java.sql.SQLException: ORA-01747: user.table.column, table.column 或列说明无效

2. 报错原因

这个出错的原因是因为表的列名称使用了Oracle声明的关键字。

3. oracle关键字查询语句

select * from v$reserved_words ORDER BY KEYWORD ASC

4. 查询结果

在这里插入图片描述

=
@
A
ABORT
ABS
ACCESS
ACCESSED
ACCOUNT
ACOS
ACTIVATE
ACTIVE_COMPONENT
ACTIVE_FUNCTION
ACTIVE_TAG
ADD
ADD_COLUMN
ADD_GROUP
ADD_MONTHS
ADJ_DATE
ADMIN
ADMINISTER
ADMINISTRATOR
ADVISE
ADVISOR
AFTER
ALIAS
ALL
ALLOCATE
ALLOW
ALL_ROWS
ALTER
ALWAYS
ANALYZE
ANCILLARY
AND
AND_EQUAL
ANTIJOIN
ANY
ANYSCHEMA
APPEND
APPENDCHILDXML
APPEND_VALUES
APPLY
ARCHIVE
ARCHIVELOG
ARRAY
AS
ASC
ASCII
ASCIISTR
ASIN
ASSEMBLY
ASSOCIATE
ASYNC
ASYNCHRONOUS
AT
ATAN
ATAN2
ATTRIBUTE
ATTRIBUTES
AUDIT
AUTHENTICATED
AUTHENTICATION
AUTHID
AUTHORIZATION
AUTO
AUTOALLOCATE
AUTOEXTEND
AUTOMATIC
AVAILABILITY
AVG
BACKUP
BASIC
BASICFILE
BATCH
BECOME
BEFORE
BEGIN
BEGIN_OUTLINE_DATA
BEHALF
BETWEEN
BFILE
BFILENAME
BIGFILE
BINARY
BINARY_DOUBLE
BINARY_DOUBLE_INFINITY
BINARY_DOUBLE_NAN
BINARY_FLOAT
BINARY_FLOAT_INFINITY
BINARY_FLOAT_NAN
BINDING
BIND_AWARE
BIN_TO_NUM
BITAND
BITMAP
BITMAPS
BITMAP_TREE
BITS
BLOB
BLOCK
BLOCKS
BLOCKSIZE
BLOCK_RANGE
BODY
BOTH
BOUND
BRANCH
BREADTH
BROADCAST
BUFFER
BUFFER_CACHE
BUFFER_POOL
BUILD
BULK
BY
BYPASS_RECURSIVE_CHECK
BYPASS_UJVC
BYTE
CACHE
CACHE_CB
CACHE_INSTANCES
CACHE_TEMP_TABLE
CALL
CANCEL
CARDINALITY
CASCADE
CASE
CAST
CATEGORY
CEIL
CELL_FLASH_CACHE
CERTIFICATE
CFILE
CHAINED
CHANGE
CHANGE_DUPKEY_ERROR_INDEX
CHAR
CHARACTER
CHARTOROWID
CHAR_CS
CHECK
CHECKPOINT
CHECK_ACL_REWRITE
CHILD
CHOOSE
CHR
CHUNK
CLASS
CLEAR
CLOB
CLONE
CLOSE
CLOSE_CACHED_OPEN_CURSORS
CLUSTER
CLUSTERING_FACTOR
CLUSTER_ID
CLUSTER_PROBABILITY
CLUSTER_SET
COALESCE
COALESCE_SQ
COARSE
COLD
COLLECT
COLUMN
COLUMNAR
COLUMNS
COLUMN_AUTH_INDICATOR
COLUMN_STATS
COLUMN_VALUE
COMMENT
COMMIT
COMMITTED
COMPACT
COMPATIBILITY
COMPILE
COMPLETE
COMPLIANCE
COMPOSE
COMPOSITE
COMPOSITE_LIMIT
COMPOUND
COMPRESS
COMPUTE
CONCAT
CONFIRM
CONFORMING
CONNECT
CONNECT_BY_CB_WHR_ONLY
CONNECT_BY_COMBINE_SW
CONNECT_BY_COST_BASED
CONNECT_BY_ELIM_DUPS
CONNECT_BY_FILTERING
CONNECT_BY_ISCYCLE
CONNECT_BY_ISLEAF
CONNECT_BY_ROOT
CONNECT_TIME
CONSIDER
CONSISTENT
CONST
CONSTANT
CONSTRAINT
CONSTRAINTS
CONTAINER
CONTENT
CONTENTS
CONTEXT
CONTINUE
CONTROLFILE
CONVERT
CORR
CORRUPTION
CORRUPT_XID
CORRUPT_XID_ALL
CORR_K
CORR_S
COS
COSH
COST
COST_XML_QUERY_REWRITE
COUNT
COVAR_POP
COVAR_SAMP
CO_AUTH_IND
CPU_COSTING
CPU_PER_CALL
CPU_PER_SESSION
CRASH
CREATE
CREATE_STORED_OUTLINES
CREATION
CROSS
CROSSEDITION
CSCONVERT
CUBE
CUBE_GB
CUME_DIST
CUME_DISTM
CURRENT
CURRENTV
CURRENT_DATE
CURRENT_SCHEMA
CURRENT_TIME
CURRENT_TIMESTAMP
CURRENT_USER
CURSOR
CURSOR_SHARING_EXACT
CURSOR_SPECIFIC_SEGMENT
CV
CYCLE
D
DANGLING
DATA
DATABASE
DATABASE_DEFAULT
DATAFILE
DATAFILES
DATAOBJNO
DATAOBJ_TO_PARTITION
DATE
DATE_MODE
DAY
DBA
DBA_RECYCLEBIN
DBMS_STATS
DBTIMEZONE
DB_ROLE_CHANGE
DB_VERSION
DDL
DEALLOCATE
DEBUG
DEBUGGER
DEC
DECIMAL
DECLARE
DECODE
DECOMPOSE
DECR
DECREMENT
DECRYPT
DEDUPLICATE
DEFAULT
DEFAULTS
DEFERRABLE
DEFERRED
DEFINED
DEFINER
DEGREE
DELAY
DELETE
DELETEXML
DEMAND
DENSE_RANK
DENSE_RANKM
DEPENDENT
DEPTH
DEQUEUE
DEREF
DEREF_NO_REWRITE
DESC
DETACHED
DETERMINES
DICTIONARY
DIMENSION
DIRECTORY
DIRECT_LOAD
DISABLE
DISABLE_PRESET
DISABLE_RPKE
DISALLOW
DISASSOCIATE
DISCONNECT
DISK
DISKGROUP
DISKS
DISMOUNT
DISTINCT
DISTINGUISHED
DISTRIBUTED
DML
DML_UPDATE
DOCFIDELITY
DOCUMENT
DOMAIN_INDEX_FILTER
DOMAIN_INDEX_NO_SORT
DOMAIN_INDEX_SORT
DOUBLE
DOWNGRADE
DRIVING_SITE
DROP
DROP_COLUMN
DROP_GROUP
DST_UPGRADE_INSERT_CONV
DUMP
DYNAMIC
DYNAMIC_SAMPLING
DYNAMIC_SAMPLING_EST_CDN
E
EACH
EDITION
EDITIONING
EDITIONS
ELEMENT
ELIMINATE_JOIN
ELIMINATE_OBY
ELIMINATE_OUTER_JOIN
ELSE
EMPTY
EMPTY_BLOB
EMPTY_CLOB
ENABLE
ENABLE_PRESET
ENCODING
ENCRYPT
ENCRYPTION
END
END_OUTLINE_DATA
ENFORCE
ENFORCED
ENQUEUE
ENTERPRISE
ENTITYESCAPING
ENTRY
ERROR
ERRORS
ERROR_ARGUMENT
ERROR_ON_OVERLAP_TIME
ESCAPE
ESTIMATE
EVALNAME
EVALUATION
EVENTS
EVERY
EXCEPT
EXCEPTIONS
EXCHANGE
EXCLUDE
EXCLUDING
EXCLUSIVE
EXECUTE
EXEMPT
EXISTS
EXISTSNODE
EXP
EXPAND_GSET_TO_UNION
EXPAND_TABLE
EXPIRE
EXPLAIN
EXPLOSION
EXPORT
EXPR_CORR_CHECK
EXTENDS
EXTENT
EXTENTS
EXTERNAL
EXTERNALLY
EXTRA
EXTRACT
EXTRACTVALUE
FACILITY
FACT
FACTORIZE_JOIN
FAILED
FAILED_LOGIN_ATTEMPTS
FAILGROUP
FALSE
FAST
FBTSCAN
FEATURE_ID
FEATURE_SET
FEATURE_VALUE
FILE
FILESYSTEM_LIKE_LOGGING
FILTER
FINAL
FINE
FINISH
FIRST
FIRSTM
FIRST_ROWS
FIRST_VALUE
FLAGGER
FLASHBACK
FLASH_CACHE
FLOAT
FLOB
FLOOR
FLUSH
FOLDER
FOLLOWING
FOLLOWS
FOR
FORCE
FORCE_XML_QUERY_REWRITE
FOREIGN
FOREVER
FORWARD
FREELIST
FREELISTS
FREEPOOLS
FRESH
FROM
FROM_TZ
FULL
FUNCTION
FUNCTIONS
G
GATHER_PLAN_STATISTICS
GBY_CONC_ROLLUP
GBY_PUSHDOWN
GENERATED
GLOBAL
GLOBALLY
GLOBAL_NAME
GLOBAL_TOPIC_ENABLED
GRANT
GREATEST
GROUP
GROUPING
GROUPING_ID
GROUPS
GROUP_BY
GROUP_ID
GUARANTEE
GUARANTEED
GUARD
H
HASH
HASHKEYS
HASH_AJ
HASH_SJ
HAVING
HEADER
HEAP
HELP
HEXTORAW
HEXTOREF
HIDDEN
HIDE
HIERARCHY
HIGH
HINTSET_BEGIN
HINTSET_END
HOT
HOUR
HWM_BROKERED
HYBRID
ID
IDENTIFIED
IDENTIFIER
IDENTITY
IDGENERATORS
IDLE_TIME
IF
IGNORE
IGNORE_OPTIM_EMBEDDED_HINTS
IGNORE_ROW_ON_DUPKEY_INDEX
IGNORE_WHERE_CLAUSE
IMMEDIATE
IMPACT
IMPORT
IN
INCLUDE
INCLUDE_VERSION
INCLUDING
INCR
INCREMENT
INCREMENTAL
INDENT
INDEX
INDEXED
INDEXES
INDEXTYPE
INDEXTYPES
INDEX_ASC
INDEX_COMBINE
INDEX_DESC
INDEX_FFS
INDEX_FILTER
INDEX_JOIN
INDEX_ROWS
INDEX_RRS
INDEX_RS
INDEX_RS_ASC
INDEX_RS_DESC
INDEX_SCAN
INDEX_SKIP_SCAN
INDEX_SS
INDEX_SS_ASC
INDEX_SS_DESC
INDEX_STATS
INDICATOR
INFINITE
INFORMATIONAL
INITCAP
INITIAL
INITIALIZED
INITIALLY
INITRANS
INLINE
INLINE_XMLTYPE_NT
INNER
INSERT
INSERTCHILDXML
INSERTCHILDXMLAFTER
INSERTCHILDXMLBEFORE
INSERTXMLAFTER
INSERTXMLBEFORE
INSTANCE
INSTANCES
INSTANTIABLE
INSTANTLY
INSTEAD
INSTR
INSTR2
INSTR4
INSTRB
INSTRC
INT
INTEGER
INTERMEDIATE
INTERNAL_CONVERT
INTERNAL_USE
INTERPRETED
INTERSECT
INTERVAL
INTO
INVALIDATE
INVISIBLE
IN_MEMORY_METADATA
IN_XQUERY
IS
ISOLATION
ISOLATION_LEVEL
ITERATE
ITERATION_NUMBER
JAVA
JOB
JOIN
K
KEEP
KEEP_DUPLICATES
KERBEROS
KEY
KEYS
KEYSIZE
KEY_LENGTH
KILL
LAG
LAST
LAST_DAY
LAST_VALUE
LATERAL
LAYER
LDAP_REGISTRATION
LDAP_REGISTRATION_ENABLED
LDAP_REG_SYNC_INTERVAL
LEAD
LEADING
LEAST
LEFT
LENGTH
LENGTH2
LENGTH4
LENGTHB
LENGTHC
LESS
LEVEL
LEVELS
LIBRARY
LIFE
LIFETIME
LIKE
LIKE2
LIKE4
LIKEC
LIKE_EXPAND
LIMIT
LINK
LIST
LISTAGG
LN
LNNVL
LOB
LOBNVL
LOBS
LOCAL
LOCALTIME
LOCALTIMESTAMP
LOCAL_INDEXES
LOCATION
LOCATOR
LOCK
LOCKED
LOG
LOGFILE
LOGFILES
LOGGING
LOGICAL
LOGICAL_READS_PER_CALL
LOGICAL_READS_PER_SESSION
LOGOFF
LOGON
LONG
LOW
LOWER
LPAD
LTRIM
M
MAIN
MAKE_REF
MANAGE
MANAGED
MANAGEMENT
MANUAL
MAPPING
MASTER
MATCHED
MATERIALIZE
MATERIALIZED
MAX
MAXARCHLOGS
MAXDATAFILES
MAXEXTENTS
MAXIMIZE
MAXINSTANCES
MAXLOGFILES
MAXLOGHISTORY
MAXLOGMEMBERS
MAXSIZE
MAXTRANS
MAXVALUE
MEASURE
MEASURES
MEDIAN
MEDIUM
MEMBER
MEMORY
MERGE
MERGE A C T I O N S M E R G E A J M E R G E C O N S T O N M E R G E S J M E T H O D M I G R A T E M I G R A T I O N M I N M I N E X T E N T S M I N I M I Z E M I N I M U M M I N I N G M I N U S M I N U S N U L L M I N U T E M I N V A L U E M I R R O R M I R R O R C O L D M I R R O R H O T M L S L A B E L M O D M O D E M O D E L M O D E L C O M P I L E S U B Q U E R Y M O D E L D O N T V E R I F Y U N I Q U E N E S S M O D E L D Y N A M I C S U B Q U E R Y M O D E L M I N A N A L Y S I S M O D E L N O A N A L Y S I S M O D E L P B Y M O D E L P U S H R E F M O D I F Y M O N I T O R M O N I T O R I N G M O N T H M O N T H S B E T W E E N M O U N T M O U N T P A T H M O V E M O V E M E N T M U L T I S E T M V M E R G E N A M E N A M E D N A M E S P A C E N A N N A N V L N A T I O N A L N A T I V E N A T I V E F U L L O U T E R J O I N N A T U R A L N A V N C H A R N C H A R C S N C H R N C L O B N E E D E D N E S T E D N E S T E D T A B L E F A S T I N S E R T N E S T E D T A B L E G E T R E F S N E S T E D T A B L E I D N E S T E D T A B L E S E T R E F S N E S T E D T A B L E S E T S E T I D N E T W O R K N E V E R N E W N E W T I M E N E X T N E X T D A Y N L J B A T C H I N G N L J I N D E X F I L T E R N L J I N D E X S C A N N L J P R E F E T C H N L S S O R T N L S C A L E N D A R N L S C H A R A C T E R S E T N L S C H A R S E T D E C L L E N N L S C H A R S E T I D N L S C H A R S E T N A M E N L S C O M P N L S C U R R E N C Y N L S D A T E F O R M A T N L S D A T E L A N G U A G E N L S I N I T C A P N L S I S O C U R R E N C Y N L S L A N G N L S L A N G U A G E N L S L E N G T H S E M A N T I C S N L S L O W E R N L S N C H A R C O N V E X C P N L S N U M E R I C C H A R A C T E R S N L S S O R T N L S S P E C I A L C H A R S N L S T E R R I T O R Y N L S U P P E R N L A J N L S J N O N O A P P E N D N O A R C H I V E L O G N O A U D I T N O C A C H E N O C O M P R E S S N O C P U C O S T I N G N O C Y C L E N O D E L A Y N O E N T I T Y E S C A P I N G N O F O R C E N O G U A R A N T E E N O L O C A L N O L O G G I N G N O M A P P I N G N O M A X V A L U E N O M I N I M I Z E N O M I N V A L U E N O M O N I T O R I N G N O N E N O N S C H E M A N O O R D E R N O O V E R R I D E N O P A R A L L E L N O P A R A L L E L I N D E X N O R E L Y N O R E P A I R N O R E S E T L O G S N O R E V E R S E N O R E W R I T E N O R M A L N O R O W D E P E N D E N C I E S N O S C H E M A C H E C K N O S E G M E N T N O S O R T N O S T R I C T N O S W I T C H N O T N O T H I N G N O T I F I C A T I O N N O V A L I D A T E N O W A I T N O A C C E S S N O B A S E T A B L E M U L T I M V R E W R I T E N O B I N D A W A R E N O B U F F E R N O C A R T E S I A N N O C H E C K A C L R E W R I T E N O C O A L E S C E S Q N O C O N N E C T B Y C B W H R O N L Y N O C O N N E C T B Y C O M B I N E S W N O C O N N E C T B Y C O S T B A S E D N O C O N N E C T B Y E L I M D U P S N O C O N N E C T B Y F I L T E R I N G N O C O S T X M L Q U E R Y R E W R I T E N O C P U C O S T I N G N O D O M A I N I N D E X F I L T E R N O D S T U P G R A D E I N S E R T C O N V N O E L I M I N A T E J O I N N O E L I M I N A T E O B Y N O E L I M I N A T E O U T E R J O I N N O E X P A N D N O E X P A N D G S E T T O U N I O N N O E X P A N D T A B L E N O F A C T N O F A C T O R I Z E J O I N N O F I L T E R I N G N O G B Y P U S H D O W N N O I N D E X N O I N D E X F F S N O I N D E X S S N O L O A D N O M E R G E N O M O D E L P U S H R E F N O M O N I T O R N O M O N I T O R I N G N O M U L T I M V R E W R I T E N O N A T I V E F U L L O U T E R J O I N N O N L J B A T C H I N G N O N L J P R E F E T C H N O O R D E R R O L L U P S N O O U T E R J O I N T O I N N E R N O P A R A L L E L N O P A R A L L E L I N D E X N O P A R T I A L C O M M I T N O P L A C E D I S T I N C T N O P L A C E G R O U P B Y N O P Q M A P N O P R U N E G S E T S N O P U L L P R E D N O P U S H P R E D N O P U S H S U B Q N O P X J O I N F I L T E R N O Q K N B U F F N O Q U E R Y T R A N S F O R M A T I O N N O R E F C A S C A D E N O R E S U L T C A C H E N O R E W R I T E N O S E M I J O I N N O S E T T O J O I N N O S Q L T U N E N O S T A R T R A N S F O R M A T I O N N O S T A T E M E N T Q U E U I N G N O S T A T S G S E T S N O S U B Q U E R Y P R U N I N G N O S U B S T R B P A D N O S W A P J O I N I N P U T S N O T E M P T A B L E N O T R A N S F O R M D I S T I N C T A G G N O U N N E S T N O U S E H A S H N O U S E H A S H A G G R E G A T I O N N O U S E I N V I S I B L E I N D E X E S N O U S E M E R G E N O U S E N L N O X M L I N D E X R E W R I T E N O X M L I N D E X R E W R I T E I N S E L E C T N O X M L D M L R E W R I T E N O X M L Q U E R Y R E W R I T E N T H V A L U E N T I L E N U L L N U L L I F N U L L S N U M B E R N U M E R I C N U M T O D S I N T E R V A L N U M T O Y M I N T E R V A L N U M I N D E X K E Y S N V A R C H A R 2 N V L N V L 2 O B J E C T O B J E C T T O X M L O B J N O O B J N O R E U S E O C C U R E N C E S O F O F F O F F L I N E O I D O I D I N D E X O L A P O L D O L D P U S H P R E D O L T P O N O N L I N E O N L Y O P A Q U E O P A Q U E T R A N S F O R M O P A Q U E X C A N O N I C A L O P C O D E O P E N O P E R A T I O N S O P E R A T O R O P T I M A L O P T I M I Z E R F E A T U R E S E N A B L E O P T I M I Z E R G O A L O P T I O N O P T E S T I M A T E O P T P A R A M O R O R A D E B U G O R A B R A N C H O R A C H E C K A C L O R A D S T A F F E C T E D O R A D S T C O N V E R T O R A D S T E R R O R O R A G E T A C L I D S O R A G E T P R I V I L E G E S O R A H A S H O R A R O W S C N O R A R O W S C N R A W O R A R O W V E R S I O N O R A T A B V E R S I O N O R D E R O R D E R E D O R D E R E D P R E D I C A T E S O R D I N A L I T Y O R G A N I Z A T I O N O R E X P A N D O R P R E D I C A T E S O T H E R O U T E R O U T E R J O I N T O I N N E R O U T L I N E O U T L I N E L E A F O U T O F L I N E O V E R O V E R F L O W O V E R F L O W N O M O V E O V E R L A P S O W N O W N E R O W N E R S H I P P P A C K A G E P A C K A G E S P A R A L L E L P A R A L L E L I N D E X P A R A M P A R A M E T E R S P A R E N T P A R I T Y P A R T ACTIONS MERGE_AJ MERGE_CONST_ON MERGE_SJ METHOD MIGRATE MIGRATION MIN MINEXTENTS MINIMIZE MINIMUM MINING MINUS MINUS_NULL MINUTE MINVALUE MIRROR MIRRORCOLD MIRRORHOT MLSLABEL MOD MODE MODEL MODEL_COMPILE_SUBQUERY MODEL_DONTVERIFY_UNIQUENESS MODEL_DYNAMIC_SUBQUERY MODEL_MIN_ANALYSIS MODEL_NO_ANALYSIS MODEL_PBY MODEL_PUSH_REF MODIFY MONITOR MONITORING MONTH MONTHS_BETWEEN MOUNT MOUNTPATH MOVE MOVEMENT MULTISET MV_MERGE NAME NAMED NAMESPACE NAN NANVL NATIONAL NATIVE NATIVE_FULL_OUTER_JOIN NATURAL NAV NCHAR NCHAR_CS NCHR NCLOB NEEDED NESTED NESTED_TABLE_FAST_INSERT NESTED_TABLE_GET_REFS NESTED_TABLE_ID NESTED_TABLE_SET_REFS NESTED_TABLE_SET_SETID NETWORK NEVER NEW NEW_TIME NEXT NEXT_DAY NLJ_BATCHING NLJ_INDEX_FILTER NLJ_INDEX_SCAN NLJ_PREFETCH NLSSORT NLS_CALENDAR NLS_CHARACTERSET NLS_CHARSET_DECL_LEN NLS_CHARSET_ID NLS_CHARSET_NAME NLS_COMP NLS_CURRENCY NLS_DATE_FORMAT NLS_DATE_LANGUAGE NLS_INITCAP NLS_ISO_CURRENCY NLS_LANG NLS_LANGUAGE NLS_LENGTH_SEMANTICS NLS_LOWER NLS_NCHAR_CONV_EXCP NLS_NUMERIC_CHARACTERS NLS_SORT NLS_SPECIAL_CHARS NLS_TERRITORY NLS_UPPER NL_AJ NL_SJ NO NOAPPEND NOARCHIVELOG NOAUDIT NOCACHE NOCOMPRESS NOCPU_COSTING NOCYCLE NODELAY NOENTITYESCAPING NOFORCE NOGUARANTEE NOLOCAL NOLOGGING NOMAPPING NOMAXVALUE NOMINIMIZE NOMINVALUE NOMONITORING NONE NONSCHEMA NOORDER NOOVERRIDE NOPARALLEL NOPARALLEL_INDEX NORELY NOREPAIR NORESETLOGS NOREVERSE NOREWRITE NORMAL NOROWDEPENDENCIES NOSCHEMACHECK NOSEGMENT NOSORT NOSTRICT NOSWITCH NOT NOTHING NOTIFICATION NOVALIDATE NOWAIT NO_ACCESS NO_BASETABLE_MULTIMV_REWRITE NO_BIND_AWARE NO_BUFFER NO_CARTESIAN NO_CHECK_ACL_REWRITE NO_COALESCE_SQ NO_CONNECT_BY_CB_WHR_ONLY NO_CONNECT_BY_COMBINE_SW NO_CONNECT_BY_COST_BASED NO_CONNECT_BY_ELIM_DUPS NO_CONNECT_BY_FILTERING NO_COST_XML_QUERY_REWRITE NO_CPU_COSTING NO_DOMAIN_INDEX_FILTER NO_DST_UPGRADE_INSERT_CONV NO_ELIMINATE_JOIN NO_ELIMINATE_OBY NO_ELIMINATE_OUTER_JOIN NO_EXPAND NO_EXPAND_GSET_TO_UNION NO_EXPAND_TABLE NO_FACT NO_FACTORIZE_JOIN NO_FILTERING NO_GBY_PUSHDOWN NO_INDEX NO_INDEX_FFS NO_INDEX_SS NO_LOAD NO_MERGE NO_MODEL_PUSH_REF NO_MONITOR NO_MONITORING NO_MULTIMV_REWRITE NO_NATIVE_FULL_OUTER_JOIN NO_NLJ_BATCHING NO_NLJ_PREFETCH NO_ORDER_ROLLUPS NO_OUTER_JOIN_TO_INNER NO_PARALLEL NO_PARALLEL_INDEX NO_PARTIAL_COMMIT NO_PLACE_DISTINCT NO_PLACE_GROUP_BY NO_PQ_MAP NO_PRUNE_GSETS NO_PULL_PRED NO_PUSH_PRED NO_PUSH_SUBQ NO_PX_JOIN_FILTER NO_QKN_BUFF NO_QUERY_TRANSFORMATION NO_REF_CASCADE NO_RESULT_CACHE NO_REWRITE NO_SEMIJOIN NO_SET_TO_JOIN NO_SQL_TUNE NO_STAR_TRANSFORMATION NO_STATEMENT_QUEUING NO_STATS_GSETS NO_SUBQUERY_PRUNING NO_SUBSTRB_PAD NO_SWAP_JOIN_INPUTS NO_TEMP_TABLE NO_TRANSFORM_DISTINCT_AGG NO_UNNEST NO_USE_HASH NO_USE_HASH_AGGREGATION NO_USE_INVISIBLE_INDEXES NO_USE_MERGE NO_USE_NL NO_XMLINDEX_REWRITE NO_XMLINDEX_REWRITE_IN_SELECT NO_XML_DML_REWRITE NO_XML_QUERY_REWRITE NTH_VALUE NTILE NULL NULLIF NULLS NUMBER NUMERIC NUMTODSINTERVAL NUMTOYMINTERVAL NUM_INDEX_KEYS NVARCHAR2 NVL NVL2 OBJECT OBJECTTOXML OBJNO OBJNO_REUSE OCCURENCES OF OFF OFFLINE OID OIDINDEX OLAP OLD OLD_PUSH_PRED OLTP ON ONLINE ONLY OPAQUE OPAQUE_TRANSFORM OPAQUE_XCANONICAL OPCODE OPEN OPERATIONS OPERATOR OPTIMAL OPTIMIZER_FEATURES_ENABLE OPTIMIZER_GOAL OPTION OPT_ESTIMATE OPT_PARAM OR ORADEBUG ORA_BRANCH ORA_CHECKACL ORA_DST_AFFECTED ORA_DST_CONVERT ORA_DST_ERROR ORA_GET_ACLIDS ORA_GET_PRIVILEGES ORA_HASH ORA_ROWSCN ORA_ROWSCN_RAW ORA_ROWVERSION ORA_TABVERSION ORDER ORDERED ORDERED_PREDICATES ORDINALITY ORGANIZATION OR_EXPAND OR_PREDICATES OTHER OUTER OUTER_JOIN_TO_INNER OUTLINE OUTLINE_LEAF OUT_OF_LINE OVER OVERFLOW OVERFLOW_NOMOVE OVERLAPS OWN OWNER OWNERSHIP P PACKAGE PACKAGES PARALLEL PARALLEL_INDEX PARAM PARAMETERS PARENT PARITY PART ACTIONSMERGEAJMERGECONSTONMERGESJMETHODMIGRATEMIGRATIONMINMINEXTENTSMINIMIZEMINIMUMMININGMINUSMINUSNULLMINUTEMINVALUEMIRRORMIRRORCOLDMIRRORHOTMLSLABELMODMODEMODELMODELCOMPILESUBQUERYMODELDONTVERIFYUNIQUENESSMODELDYNAMICSUBQUERYMODELMINANALYSISMODELNOANALYSISMODELPBYMODELPUSHREFMODIFYMONITORMONITORINGMONTHMONTHSBETWEENMOUNTMOUNTPATHMOVEMOVEMENTMULTISETMVMERGENAMENAMEDNAMESPACENANNANVLNATIONALNATIVENATIVEFULLOUTERJOINNATURALNAVNCHARNCHARCSNCHRNCLOBNEEDEDNESTEDNESTEDTABLEFASTINSERTNESTEDTABLEGETREFSNESTEDTABLEIDNESTEDTABLESETREFSNESTEDTABLESETSETIDNETWORKNEVERNEWNEWTIMENEXTNEXTDAYNLJBATCHINGNLJINDEXFILTERNLJINDEXSCANNLJPREFETCHNLSSORTNLSCALENDARNLSCHARACTERSETNLSCHARSETDECLLENNLSCHARSETIDNLSCHARSETNAMENLSCOMPNLSCURRENCYNLSDATEFORMATNLSDATELANGUAGENLSINITCAPNLSISOCURRENCYNLSLANGNLSLANGUAGENLSLENGTHSEMANTICSNLSLOWERNLSNCHARCONVEXCPNLSNUMERICCHARACTERSNLSSORTNLSSPECIALCHARSNLSTERRITORYNLSUPPERNLAJNLSJNONOAPPENDNOARCHIVELOGNOAUDITNOCACHENOCOMPRESSNOCPUCOSTINGNOCYCLENODELAYNOENTITYESCAPINGNOFORCENOGUARANTEENOLOCALNOLOGGINGNOMAPPINGNOMAXVALUENOMINIMIZENOMINVALUENOMONITORINGNONENONSCHEMANOORDERNOOVERRIDENOPARALLELNOPARALLELINDEXNORELYNOREPAIRNORESETLOGSNOREVERSENOREWRITENORMALNOROWDEPENDENCIESNOSCHEMACHECKNOSEGMENTNOSORTNOSTRICTNOSWITCHNOTNOTHINGNOTIFICATIONNOVALIDATENOWAITNOACCESSNOBASETABLEMULTIMVREWRITENOBINDAWARENOBUFFERNOCARTESIANNOCHECKACLREWRITENOCOALESCESQNOCONNECTBYCBWHRONLYNOCONNECTBYCOMBINESWNOCONNECTBYCOSTBASEDNOCONNECTBYELIMDUPSNOCONNECTBYFILTERINGNOCOSTXMLQUERYREWRITENOCPUCOSTINGNODOMAININDEXFILTERNODSTUPGRADEINSERTCONVNOELIMINATEJOINNOELIMINATEOBYNOELIMINATEOUTERJOINNOEXPANDNOEXPANDGSETTOUNIONNOEXPANDTABLENOFACTNOFACTORIZEJOINNOFILTERINGNOGBYPUSHDOWNNOINDEXNOINDEXFFSNOINDEXSSNOLOADNOMERGENOMODELPUSHREFNOMONITORNOMONITORINGNOMULTIMVREWRITENONATIVEFULLOUTERJOINNONLJBATCHINGNONLJPREFETCHNOORDERROLLUPSNOOUTERJOINTOINNERNOPARALLELNOPARALLELINDEXNOPARTIALCOMMITNOPLACEDISTINCTNOPLACEGROUPBYNOPQMAPNOPRUNEGSETSNOPULLPREDNOPUSHPREDNOPUSHSUBQNOPXJOINFILTERNOQKNBUFFNOQUERYTRANSFORMATIONNOREFCASCADENORESULTCACHENOREWRITENOSEMIJOINNOSETTOJOINNOSQLTUNENOSTARTRANSFORMATIONNOSTATEMENTQUEUINGNOSTATSGSETSNOSUBQUERYPRUNINGNOSUBSTRBPADNOSWAPJOININPUTSNOTEMPTABLENOTRANSFORMDISTINCTAGGNOUNNESTNOUSEHASHNOUSEHASHAGGREGATIONNOUSEINVISIBLEINDEXESNOUSEMERGENOUSENLNOXMLINDEXREWRITENOXMLINDEXREWRITEINSELECTNOXMLDMLREWRITENOXMLQUERYREWRITENTHVALUENTILENULLNULLIFNULLSNUMBERNUMERICNUMTODSINTERVALNUMTOYMINTERVALNUMINDEXKEYSNVARCHAR2NVLNVL2OBJECTOBJECTTOXMLOBJNOOBJNOREUSEOCCURENCESOFOFFOFFLINEOIDOIDINDEXOLAPOLDOLDPUSHPREDOLTPONONLINEONLYOPAQUEOPAQUETRANSFORMOPAQUEXCANONICALOPCODEOPENOPERATIONSOPERATOROPTIMALOPTIMIZERFEATURESENABLEOPTIMIZERGOALOPTIONOPTESTIMATEOPTPARAMORORADEBUGORABRANCHORACHECKACLORADSTAFFECTEDORADSTCONVERTORADSTERRORORAGETACLIDSORAGETPRIVILEGESORAHASHORAROWSCNORAROWSCNRAWORAROWVERSIONORATABVERSIONORDERORDEREDORDEREDPREDICATESORDINALITYORGANIZATIONOREXPANDORPREDICATESOTHEROUTEROUTERJOINTOINNEROUTLINEOUTLINELEAFOUTOFLINEOVEROVERFLOWOVERFLOWNOMOVEOVERLAPSOWNOWNEROWNERSHIPPPACKAGEPACKAGESPARALLELPARALLELINDEXPARAMPARAMETERSPARENTPARITYPARTNUMKaTeX parse error: Double subscript at position 3204: …ROSSTAB STATS_F_̲TEST STATS_KS_T…
SYS_OP_EXTRACT
SYS_OP_GROUPING
SYS_OP_GUID
SYS_OP_IIX
SYS_OP_ITR
SYS_OP_LBID
SYS_OP_LOBLOC2BLOB
SYS_OP_LOBLOC2CLOB
SYS_OP_LOBLOC2ID
SYS_OP_LOBLOC2NCLOB
SYS_OP_LOBLOC2TYP
SYS_OP_LSVI
SYS_OP_LVL
SYS_OP_MAKEOID
SYS_OP_MAP_NONNULL
SYS_OP_MSR
SYS_OP_NICOMBINE
SYS_OP_NIEXTRACT
SYS_OP_NII
SYS_OP_NIX
SYS_OP_NOEXPAND
SYS_OP_NTCIMG$
SYS_OP_NUMTORAW
SYS_OP_OIDVALUE
SYS_OP_OPNSIZE
SYS_OP_PAR
SYS_OP_PARGID
SYS_OP_PARGID_1
SYS_OP_PAR_1
SYS_OP_PIVOT
SYS_OP_R2O
SYS_OP_RAWTONUM
SYS_OP_RDTM
SYS_OP_REF
SYS_OP_RMTD
SYS_OP_ROWIDTOOBJ
SYS_OP_RPB
SYS_OP_TOSETID
SYS_OP_TPR
SYS_OP_TRTB
SYS_OP_UNDESCEND
SYS_OP_VECAND
SYS_OP_VECBIT
SYS_OP_VECOR
SYS_OP_VECXOR
SYS_OP_VERSION
SYS_OP_VREF
SYS_OP_VVD
SYS_OP_XPTHATG
SYS_OP_XPTHIDX
SYS_OP_XPTHOP
SYS_OP_XTXT2SQLT
SYS_ORDERKEY_DEPTH
SYS_ORDERKEY_MAXCHILD
SYS_ORDERKEY_PARENT
SYS_PARALLEL_TXN
SYS_PATHID_IS_ATTR
SYS_PATHID_IS_NMSPC
SYS_PATHID_LASTNAME
SYS_PATHID_LASTNMSPC
SYS_PATH_REVERSE
SYS_PXQEXTRACT
SYS_RID_ORDER
SYS_ROW_DELTA
SYS_SC_2_XMLT
SYS_SYNRCIREDO
SYS_TYPEID
SYS_UMAKEXML
SYS_XMLANALYZE
SYS_XMLCONTAINS
SYS_XMLCONV
SYS_XMLEXNSURI
SYS_XMLGEN
SYS_XMLI_LOC_ISNODE
SYS_XMLI_LOC_ISTEXT
SYS_XMLLOCATOR_GETSVAL
SYS_XMLNODEID
SYS_XMLNODEID_GETCID
SYS_XMLNODEID_GETLOCATOR
SYS_XMLNODEID_GETOKEY
SYS_XMLNODEID_GETPATHID
SYS_XMLNODEID_GETPTRID
SYS_XMLNODEID_GETRID
SYS_XMLNODEID_GETSVAL
SYS_XMLNODEID_GETTID
SYS_XMLTRANSLATE
SYS_XMLTYPE2SQL
SYS_XMLT_2_SC
SYS_XQBASEURI
SYS_XQCASTABLEERRH
SYS_XQCODEP2STR
SYS_XQCODEPEQ
SYS_XQCON2SEQ
SYS_XQCONCAT
SYS_XQDELETE
SYS_XQDFLTCOLATION
SYS_XQDOC
SYS_XQDOCURI
SYS_XQED4URI
SYS_XQENDSWITH
SYS_XQERR
SYS_XQERRH
SYS_XQESHTMLURI
SYS_XQEXLOBVAL
SYS_XQEXSTWRP
SYS_XQEXTRACT
SYS_XQEXTRREF
SYS_XQEXVAL
SYS_XQFB2STR
SYS_XQFNBOOL
SYS_XQFNCMP
SYS_XQFNDATIM
SYS_XQFNLNAME
SYS_XQFNNM
SYS_XQFNNSURI
SYS_XQFNPREDTRUTH
SYS_XQFNQNM
SYS_XQFNROOT
SYS_XQFORMATNUM
SYS_XQFTCONTAIN
SYS_XQFUNCR
SYS_XQGETCONTENT
SYS_XQINDXOF
SYS_XQINSERT
SYS_XQINSPFX
SYS_XQIRI2URI
SYS_XQLANG
SYS_XQLLNMFRMQNM
SYS_XQMKNODEREF
SYS_XQNILLED
SYS_XQNODENAME
SYS_XQNORMSPACE
SYS_XQNORMUCODE
SYS_XQNSP4PFX
SYS_XQNSPFRMQNM
SYS_XQPFXFRMQNM
SYS_XQPOLYABS
SYS_XQPOLYADD
SYS_XQPOLYCEL
SYS_XQPOLYCST
SYS_XQPOLYCSTBL
SYS_XQPOLYDIV
SYS_XQPOLYFLR
SYS_XQPOLYMOD
SYS_XQPOLYMUL
SYS_XQPOLYRND
SYS_XQPOLYSQRT
SYS_XQPOLYSUB
SYS_XQPOLYUMUS
SYS_XQPOLYUPLS
SYS_XQPOLYVEQ
SYS_XQPOLYVGE
SYS_XQPOLYVGT
SYS_XQPOLYVLE
SYS_XQPOLYVLT
SYS_XQPOLYVNE
SYS_XQREF2VAL
SYS_XQRENAME
SYS_XQREPLACE
SYS_XQRESVURI
SYS_XQRNDHALF2EVN
SYS_XQRSLVQNM
SYS_XQRYENVPGET
SYS_XQRYVARGET
SYS_XQRYWRP
SYS_XQSEQ2CON
SYS_XQSEQ2CON4XC
SYS_XQSEQDEEPEQ
SYS_XQSEQINSB
SYS_XQSEQRM
SYS_XQSEQRVS
SYS_XQSEQSUB
SYS_XQSEQTYPMATCH
SYS_XQSTARTSWITH
SYS_XQSTATBURI
SYS_XQSTR2CODEP
SYS_XQSTRJOIN
SYS_XQSUBSTRAFT
SYS_XQSUBSTRBEF
SYS_XQTOKENIZE
SYS_XQTREATAS
SYS_XQXFORM
SYS_XQ_ASQLCNV
SYS_XQ_ATOMCNVCHK
SYS_XQ_NRNG
SYS_XQ_PKSQL2XML
SYS_XQ_UPKXML2SQL
T
TABLE
TABLES
TABLESPACE
TABLESPACE_NO
TABLE_STATS
TABNO
TAN
TANH
TBL O R OR ORIDX P A R T PART PARTNUM
TEMPFILE
TEMPLATE
TEMPORARY
TEMP_TABLE
TEST
THAN
THE
THEN
THREAD
THROUGH
TIME
TIMEOUT
TIMES
TIMESTAMP
TIMEZONE_ABBR
TIMEZONE_HOUR
TIMEZONE_MINUTE
TIMEZONE_OFFSET
TIMEZONE_REGION
TIME_ZONE
TIV_GB
TIV_SSF
TO
TOPLEVEL
TO_BINARY_DOUBLE
TO_BINARY_FLOAT
TO_BLOB
TO_CHAR
TO_CLOB
TO_DATE
TO_DSINTERVAL
TO_LOB
TO_MULTI_BYTE
TO_NCHAR
TO_NCLOB
TO_NUMBER
TO_SINGLE_BYTE
TO_TIME
TO_TIMESTAMP
TO_TIMESTAMP_TZ
TO_TIME_TZ
TO_YMINTERVAL
TRACE
TRACING
TRACKING
TRAILING
TRANSACTION
TRANSFORM_DISTINCT_AGG
TRANSITION
TRANSITIONAL
TRANSLATE
TREAT
TRIGGER
TRIGGERS
TRIM
TRUE
TRUNC
TRUNCATE
TRUSTED
TUNING
TX
TYPE
TYPES
TZ_OFFSET
U
UB2
UBA
UID
UNARCHIVED
UNBOUND
UNBOUNDED
UNDER
UNDO
UNDROP
UNIFORM
UNION
UNIQUE
UNISTR
UNLIMITED
UNLOCK
UNNEST
UNPACKED
UNPIVOT
UNPROTECTED
UNQUIESCE
UNRECOVERABLE
UNRESTRICTED
UNTIL
UNUSABLE
UNUSED
UPDATABLE
UPDATE
UPDATED
UPDATEXML
UPD_INDEXES
UPD_JOININDEX
UPGRADE
UPPER
UPSERT
UROWID
USAGE
USE
USER
USERENV
USERGROUP
USERS
USER_DEFINED
USER_RECYCLEBIN
USE_ANTI
USE_CONCAT
USE_HASH
USE_HASH_AGGREGATION
USE_INVISIBLE_INDEXES
USE_MERGE
USE_MERGE_CARTESIAN
USE_NL
USE_NL_WITH_INDEX
USE_PRIVATE_OUTLINES
USE_SEMI
USE_STORED_OUTLINES
USE_TTT_FOR_GSETS
USE_WEAK_NAME_RESL
USING
VALIDATE
VALIDATION
VALUE
VALUES
VARCHAR
VARCHAR2
VARIANCE
VARRAY
VARRAYS
VARYING
VAR_POP
VAR_SAMP
VECTOR_READ
VECTOR_READ_TRACE
VERIFY
VERSION
VERSIONING
VERSIONS
VERSIONS_ENDSCN
VERSIONS_ENDTIME
VERSIONS_OPERATION
VERSIONS_STARTSCN
VERSIONS_STARTTIME
VERSIONS_XID
VIEW
VIRTUAL
VISIBLE
VOLUME
VSIZE
WAIT
WALLET
WELLFORMED
WHEN
WHENEVER
WHERE
WHITESPACE
WIDTH_BUCKET
WITH
WITHIN
WITHOUT
WORK
WRAPPED
WRITE
XID
XML
XMLATTRIBUTES
XMLCAST
XMLCDATA
XMLCOLATTVAL
XMLCOMMENT
XMLCONCAT
XMLDIFF
XMLELEMENT
XMLEXISTS
XMLEXISTS2
XMLFOREST
XMLINDEX_REWRITE
XMLINDEX_REWRITE_IN_SELECT
XMLINDEX_SEL_IDX_TBL
XMLISNODE
XMLISVALID
XMLNAMESPACES
XMLPARSE
XMLPATCH
XMLPI
XMLQUERY
XMLROOT
XMLSCHEMA
XMLSERIALIZE
XMLTABLE
XMLTOOBJECT
XMLTRANSFORM
XMLTRANSFORMBLOB
XMLTYPE
XML_DML_RWT_STMT
XPATHTABLE
XS_SYS_CONTEXT
X_DYN_PRUNE
YEAR
YES
ZONE

  • 7
    点赞
  • 12
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
这个错误信息 "java.sql.SQLException: ORA-01017: invalid username/password; logon denied" 是由于无效的用户名或密码所引起的。 主要的问题是用户名和密码的组合是无效的,但除了密码不正确之外,还有其他可能导致ORA-01017错误的用户ID问题。 要解决这个问题,您可以执行以下检查步骤: 1. 使用管理员权限登录到Oracle数据库。 2. 运行以下命令来检查数据库中的用户名: select username from dba_users; 这将列出所有存在的用户名。 3. 确保您输入的用户名和密码与数据库中的用户名和密码匹配。 4. 如果您仍然遇到问题,请尝试重置密码或联系数据库管理员以获取进一步的支持。 总结来说,"ORA-01017: invalid username/password; logon denied" 错误是由于无效的用户名或密码所引起的。您可以通过检查用户名和密码的正确性以及与数据库中存在的用户名进行匹配来解决这个问题。<span class="em">1</span><span class="em">2</span><span class="em">3</span> #### 引用[.reference_title] - *1* *2* *3* [JDBC连接ORACLE无法登陆java.sql.SQLException: ORA-01017: invalid username/password; logon denied...](https://blog.csdn.net/aoningxun2220/article/details/101627502)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 100%"] [ .reference_list ]

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值