long不能作為查詢條件的。
long raw或者blob,clob則可以。
long raw或者blob,clob則可以。
解决方案 »
- 补分数的帖子!!!
- oracle 游标
- oracle 建存储过程报错!
- select t.part,s.part,t.plant,s.plant ,t.rowid from srm054 t,srm041 swhere t.part=s.part
- windows2003中安装ORACLE9I
- 一条简单的SQL语句,请各位大侠帮忙呀~
- Oracle9i无自增字段,那按照别人写的触发器如下,在SQL*Plus中执行不对呢?帮我看看了。
- 问一个关于 pl/sql 的 procedure 问题
- oracle 9i
- [200分]一个存储过程怎样调用java源,给个例子好吗?小弟急用???!![在线急等]
- 触发器中是否可以用in语句?这样写有什么问题?
- 帮帮忙,关于long类型字段的全文检索问题,100分相送
Application Developer’s Guide - Fundamentals
下载地址:
http://gigabase.idi.ntnu.no/oradoc/nav/docindex.htm
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
http://www.oradb.net/sql/sqlplus_005.htm
DROP INDEX index mytext_idx
/
CREATE INDEX mytext_idx
ON mytext( thetext )
INDEXTYPE is CTXSYS.CONTEXT
/
SELECT id
FROM mytext
WHERE contains (thetext, 'near((Oracle,Corporation),10)') > 0
/
SELECT score (1), id
FROM mytext
WHERE contains (thetext, 'Oracle or california', 1) > 0
ORDER BY score (1) DESC
/
SELECT id
FROM mytext
WHERE contains (thetext, '$train') > 0;
建议采用long raw或者blob,clob做为clob进行查询,可以使用相关的dbms_lob包中的东西,或者如楼上所提的方法