java.sql.SQLException: ORA-01745: 无效的主机/绑定变量名

在oracle数据库操作中遇到这个问题很是郁闷!结果是表设计字段中有个oracle的关键字,没有转义,后解决:

oracle关键字有:
ACCESS ACCOUNT ACTIVATE

ADD
ADMIN
ADVISE

AFTER
ALL
ALL_ROWS

ALLOCATE
ALTER
ANALYZE

AND
ANY
ARCHIVE

ARCHIVELOG
ARRAY
AS

ASC
AT
AUDIT

AUTHENTICATED
AUTHORIZATION
AUTOEXTEND

AUTOMATIC
BACKUP
BECOME

BEFORE
BEGIN
BETWEEN

BFILE
BITMAP
BLOB

BLOCK
BODY
BY

CACHE
CACHE_INSTANCES
CANCEL

CASCADE
CAST
CFILE

CHAINED
CHANGE
CHAR

CHAR_CS
CHARACTER
CHECK

CHECKPOINT
CHOOSE
CHUNK

CLEAR
CLOB
CLONE

CLOSE
CLOSE_CACHED_OPEN_CURSORS
CLUSTER

COALESCE
COLUMN
COLUMNS

COMMENT
COMMIT
COMMITTED

COMPATIBILITY
COMPILE
COMPLETE

COMPOSITE_LIMIT
COMPRESS
COMPUTE

CONNECT
CONNECT_TIME
CONSTRAINT

CONSTRAINTS
CONTENTS
CONTINUE

CONTROLFILE
CONVERT
COST

CPU_PER_CALL
CPU_PER_SESSION
CREATE

CURRENT
CURRENT_SCHEMA
CURREN_USER

CURSOR
CYCLE

DANGLING
DATABASE
DATAFILE

DATAFILES
DATAOBJNO
DATE

DBA
DBHIGH
DBLOW

DBMAC
DEALLOCATE
DEBUG

DEC
DECIMAL
DECLARE

DEFAULT
DEFERRABLE
DEFERRED

DEGREE
DELETE
DEREF

DESC
DIRECTORY
DISABLE

DISCONNECT
DISMOUNT
DISTINCT

DISTRIBUTED
DML
DOUBLE

DROP
DUMP
EACH

ELSE
ENABLE
END

ENFORCE
ENTRY
ESCAPE

EXCEPT
EXCEPTIONS
EXCHANGE

EXCLUDING
EXCLUSIVE
EXECUTE

EXISTS
EXPIRE
EXPLAIN

EXTENT
EXTENTS
EXTERNALLY

FAILED_LOGIN_ATTEMPTS
FALSE
FAST

FILE
FIRST_ROWS
FLAGGER

FLOAT
FLOB
FLUSH

FOR
FORCE
FOREIGN

FREELIST
FREELISTS
FROM

FULL
FUNCTION
GLOBAL

GLOBALLY
GLOBAL_NAME
GRANT

GROUP
GROUPS
HASH

HASHKEYS
HAVING
HEADER

HEAP
IDENTIFIED
IDGENERATORS

IDLE_TIME
IF
IMMEDIATE

IN
INCLUDING
INCREMENT

INDEX
INDEXED
INDEXES

INDICATOR
IND_PARTITION
INITIAL

INITIALLY
INITRANS
INSERT

INSTANCE
INSTANCES
INSTEAD

INT
INTEGER
INTERMEDIATE

INTERSECT
INTO
IS

ISOLATION
ISOLATION_LEVEL
KEEP

KEY
KILL
LABEL

LAYER
LESS
LEVEL

LIBRARY
LIKE
LIMIT

LINK
LIST
LOB

LOCAL
LOCK
LOCKED

LOG
LOGFILE
LOGGING

LOGICAL_READS_PER_CALL
LOGICAL_READS_PER_SESSION
LONG

MANAGE
MASTER
MAX

MAXARCHLOGS
MAXDATAFILES
MAXEXTENTS

MAXINSTANCES
MAXLOGFILES
MAXLOGHISTORY

MAXLOGMEMBERS
MAXSIZE
MAXTRANS

MAXVALUE
MIN
MEMBER

MINIMUM
MINEXTENTS
MINUS

MINVALUE
MLSLABEL
MLS_LABEL_FORMAT

MODE
MODIFY
MOUNT

MOVE
MTS_DISPATCHERS
MULTISET

NATIONAL
NCHAR
NCHAR_CS

NCLOB
NEEDED
NESTED

NETWORK
NEW
NEXT

NOARCHIVELOG
NOAUDIT
NOCACHE

NOCOMPRESS
NOCYCLE
NOFORCE

NOLOGGING
NOMAXVALUE
NOMINVALUE

NONE
NOORDER
NOOVERRIDE

NOPARALLEL
NOPARALLEL
NOREVERSE

NORMAL
NOSORT
NOT

NOTHING
NOWAIT
NULL

NUMBER
NUMERIC
NVARCHAR2

OBJECT
OBJNO
OBJNO_REUSE

OF
OFF
OFFLINE

OID
OIDINDEX
OLD

ON
ONLINE
ONLY

OPCODE
OPEN
OPTIMAL

OPTIMIZER_GOAL
OPTION
OR

ORDER
ORGANIZATION
OSLABEL

OVERFLOW
OWN
PACKAGE

PARALLEL
PARTITION
PASSWORD

PASSWORD_GRACE_TIME
PASSWORD_LIFE_TIME
PASSWORD_LOCK_TIME

PASSWORD_REUSE_MAX
PASSWORD_REUSE_TIME
PASSWORD_VERIFY_FUNCTION

PCTFREE
PCTINCREASE
PCTTHRESHOLD

PCTUSED
PCTVERSION
PERCENT

PERMANENT
PLAN
PLSQL_DEBUG

POST_TRANSACTION
PRECISION
PRESERVE

PRIMARY
PRIOR
PRIVATE

PRIVATE_SGA
PRIVILEGE
PRIVILEGES

PROCEDURE
PROFILE
PUBLIC

PURGE
QUEUE
QUOTA

RANGE
RAW
RBA

READ
READUP
REAL

REBUILD
RECOVER
RECOVERABLE

RECOVERY
REF
REFERENCES

REFERENCING
REFRESH
RENAME

REPLACE
RESET
RESETLOGS

RESIZE
RESOURCE
RESTRICTED

RETURN
RETURNING
REUSE

REVERSE
REVOKE
ROLE

ROLES
ROLLBACK
ROW

ROWID
ROWNUM
ROWS

RULE
SAMPLE
SAVEPOINT

SB4
SCAN_INSTANCES
SCHEMA

SCN
SCOPE
SD_ALL

SD_INHIBIT
SD_SHOW
SEGMENT

SEG_BLOCK
SEG_FILE
SELECT

SEQUENCE
SERIALIZABLE
SESSION

SESSION_CACHED_CURSORS
SESSIONS_PER_USER
SET

SHARE
SHARED
SHARED_POOL

SHRINK
SIZE
SKIP

SKIP_UNUSABLE_INDEXES
SMALLINT
SNAPSHOT

SOME
SORT
SPECIFICATION

SPLIT
SQL_TRACE
STANDBY

START
STATEMENT_ID
STATISTICS

STOP
STORAGE
STORE

STRUCTURE
SUCCESSFUL
SWITCH

SYS_OP_ENFORCE_NOT_NULL$
SYS_OP_NTCIMG$
SYNONYM

SYSDATE
SYSDBA
SYSOPER

SYSTEM
TABLE
TABLES

TABLESPACE
TABLESPACE_NO
TABNO

TEMPORARY
THAN
THE

THEN
THREAD
TIMESTAMP

TIME
TO
TOPLEVEL

TRACE
TRACING
TRANSACTION

TRANSITIONAL
TRIGGER
TRIGGERS

TRUE
TRUNCATE
TX

TYPE
UB2
UBA

UID
UNARCHIVED
UNDO

UNION
UNIQUE
UNLIMITED

UNLOCK
UNRECOVERABLE
UNTIL

UNUSABLE
UNUSED
UPDATABLE

UPDATE
USAGE
USE

USER
USING
VALIDATE

VALIDATION
VALUE
VALUES

VARCHAR
VARCHAR2
VARYING

VIEW
WHEN
WHENEVER

WHERE
WITH
WITHOUT

WORK
WRITE
WRITEDOWN

WRITEUP
XID
YEAR

ZONE
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值