一个读取LONG类型的sql错误

luobutou

SELECT *  
FROM(
                        select /*+ INDEX(VENUES VENUES_CITY) */ District,Address1,Name,Phone,VenueID,feature,elong_lohoo_card,DIRECTIONS,parentvenueid,venuetype,2 from Venues where (  branchvenue=0 and status=3 and (elong_card is not null or elong_lohoo_card is not null) and ((sysdate-end_date)<2)) order by VenueID desc
)
WHERE rownum<=7
minus
SELECT *
FROM(
select /*+ INDEX(VENUES VENUES_CITY) */ District,Address1,Name,Phone,VenueID,feature,elong_lohoo_card,DIRECTIONS,parentvenueid,venuetype,2 from Venues where ( branchvenue=0 and status=3 and (elong_card is not null or elong_lohoo_card is not null) and ((sysdate-end_date)<2)) order by VenueID desc
)
WHERE rownum<=8
ORDER BY 5 DESC

报错误的使用long类型，请问我该怎么改写。note是long

honk

题目不是很看得懂。
long类型使用很受限制。不能在where,group by,order by 等里使用
minus 得实质是把每列来作比较，note 也作了比较。oracle认为这是在
where条件。
error-ora-997 错误
我用union all 就成功了。

honk

解决方法：

create table t(id intege,name varchar2(50),note long)
select * from where (id,name) in
(select id,name from t where rownum < 8
minus
select id,name from t where rownum <