LONG columns cannot appear in certain parts of SQL statements:
WHERE clauses, GROUP BY clauses, ORDER BY clauses, or CONNECT BY clauses or
with the DISTINCT operator in SELECT statements
The UNIQUE operator of a SELECT statement
The column list of a CREATE CLUSTER statement
The CLUSTER clause of a CREATE MATERIALIZED VIEW statement
SQL functions (such as SUBSTR or INSTR)
Expressions or conditions
SELECT lists of queries containing GROUP BY clauses
SELECT lists of subqueries or queries combined by the UNION, INTERSECT, or
MINUS set operators
** SELECT lists of CREATE TABLE ... AS SELECT statements
** SELECT lists in subqueries in INSERT statements
WHERE clauses, GROUP BY clauses, ORDER BY clauses, or CONNECT BY clauses or
with the DISTINCT operator in SELECT statements
The UNIQUE operator of a SELECT statement
The column list of a CREATE CLUSTER statement
The CLUSTER clause of a CREATE MATERIALIZED VIEW statement
SQL functions (such as SUBSTR or INSTR)
Expressions or conditions
SELECT lists of queries containing GROUP BY clauses
SELECT lists of subqueries or queries combined by the UNION, INTERSECT, or
MINUS set operators
** SELECT lists of CREATE TABLE ... AS SELECT statements
** SELECT lists in subqueries in INSERT statements
解决方案 »
- 请高手帮忙分析下代码
- oracle 时间?
- 求教oracle9i的监听进程不能解析在连接描述符中给出的SERVICE_NAME问题
- ORA-01219:数据库未打开:仅允许在固定表/视图中查询
- 建立一个Oracle的音频数据库
- 在oracle中 如何得到本机 的机器名??? 急!!!!
- SQL语句能否以这样的时间为条件?
- 如何给一个用户赋指定表空间的权限
- Oracle数据库加锁的一大难题!!!!!!!!!!!!!!!!(在线急等!多谢!!)
- 怎样取出日期字段的年份、月份、日的各部件的整数/字符值?
- ~~~~~~问题紧急,请大家务必帮小弟一把!~~~~~~~~~~~在线等!
- 自己平时收集了一些关于oracle学习的点滴知识,也有自己的一些经验所得
Long 数据类型很脆弱的。
long是一种较老的数据类型,将来会逐渐被BLOB、CLOB、NCLOB等大的对象数据类型所取代。
转移到其它表中呢?