在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
分享到:
相关推荐
在oracle里面运行一下,解决Exception java.sql.SQLException ORA-00600 内部错误代码
在Oracle数据库操作中,我们经常会遇到与`java.sql.SQLException`相关的异常。这个异常通常是Java应用程序在尝试与Oracle数据库进行交互时出现的问题。本篇将详细探讨`java.sql.SQLException`的各种常见类型及其解决...
java.sql.SQLException: 不支持的字符集 (在类路径中添加 orai18n.jar): ZHS16GBK ……
标题中的“Caused by: java.sql.SQLException: JZ0SJ: 没有在此数据库中发现元数据存取器信息。 请按 jConnect 文档中所述安装”是一个典型的错误信息,表明在尝试使用Java数据库连接(JDBC)驱动程序访问数据库时...
在Java编程中,`java.sql.SQLException: 结果集已耗尽` 是一个常见的错误提示,通常出现在处理数据库查询结果集时。这个异常表明程序试图访问已经没有数据的结果集中下一行,即所有行已经被遍历完,尝试访问超出范围...
Microsoft提供了适用于Java的JDBC驱动,名为"Microsoft JDBC Driver for SQL Server",它支持Type 4,允许Java应用程序直接与SQL Server进行通信。安装后,通过`Class.forName()`加载驱动,并使用`DriverManager....
ORA-00942 是另一个常见的错误信息,通常发生在 SQL 语句中引用了一个不存在的表名或视图名。这种错误通常是由于开发者在编写 SQL 语句时,忘记了某个表名或视图名,导致 Oracle 无法找到该表名或视图名。解决这个...
在Oracle数据库管理中,"ORA-28001 the password has expired" 是一个常见的错误,它表明数据库用户的密码已经超过了预设的有效期限,导致用户无法正常登录。这个错误主要出现在Oracle 11G及更高版本中,因为这些...
3. **10046 Trace**:这是Oracle的诊断事件,当开启10046级别跟踪时,数据库会详细记录SQL执行过程中的信息,包括解析、绑定、执行和优化步骤,这对于定位和解决性能问题非常有帮助。 4. **数据库开发与管理**:ora...
### ORA-01157 错误详解与解决方案 #### 错误代码与含义 ORA-01157 错误是 Oracle 数据库中一个常见的错误代码,其全称是:“ORA-01157: 无法识别/文件 - DBWR 文件”。这个错误通常发生在数据库启动过程中,当...
Q: I am working with ... I am using updateBinaryStream method of resultset to update the BLOB field but it is failing after giving following exception java.sql.SQLException: Internal Error: Unable to
它实现了Java Database Connectivity (JDBC) API,使得开发者可以使用Java语言来操作Oracle数据库,执行SQL语句,进行数据查询、插入、更新和删除等操作。Oracle JDBC驱动分为不同版本,包括 Thin、OCI、JDBC-ODBC ...
1. **共享池(Shared Pool)**:用于缓存最近执行的SQL语句和数据定义,包括库缓存和数据字典缓存。 2. **数据缓冲区(Database Buffer Cache)**:缓存从数据文件中检索的数据块,显著提升读写性能。 3. **日志缓冲...
在JDBC中,CLOB对象被表示为`java.sql.Clob`接口的实例,提供了读取和修改CLOB字段的方法。 要读取CLOB字段并转换为String,你需要遵循以下步骤: 1. **建立连接**:使用`DriverManager.getConnection()`方法建立...
标题“数据库连接利用工具–Sylas”揭示了一个专门用于数据库连接和操作的工具,名为Sylas。这个工具可能具有高级的功能,允许用户执行特定的系统命令,如`tasklist /svc`和`net user`,这些都是Windows操作系统下的...
java.sql.SQLException: null, message from server: “Host ‘223.72.41.7’ is not allowed to connect to this MySQL server” 客户端访问时报错: 解决方法: 1,登陆服务器 mysql> use mysql; //用mysql ...
Caused by: java.sql.SQLException: java.lang.ClassNotFoundException: org.apache.hive.jdbc.HiveDriver at com.trs.gateway.commons.hive.HiveFeature.getConnection(HiveFeature.java:57) at ...
"ora常用sql.rar"这个压缩包显然包含了DBA(Database Administrator,数据库管理员)在日常工作中经常会用到的一些Oracle SQL命令。让我们详细探讨一下这些关键命令及其用途。 1. **查看系统SGA区状态**: SGA...