oracle8i中的long类型怎么才能实现用like进行模糊查询

[henry_cn]

oracle8i中的long类型怎么才能实现用like进行模糊查询

[zjhclf]

??long为什么要模糊查询

[henry_cn]

我头一次用Oracle，把存入文章内容的类型定义成Long，现在要查询，
select * from memo like '%非典%'
就出错，说类型不对。

[zjhclf]

建议将字段类型修改掉！

[beckhambobo]

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

[henry_cn]

我的表内有数据，还能不能改字段类型，改为什么类型的？？

[tcmis]

把表的数据先备份一下再该撒

[henry_cn]

up