lect /*+ INDEX(VENUES VENUES_CITY) */ District,Address1,Name,Phone,VenueID from Venues where ( Venues.City = '上海' and District = '浦东' and UPPER(Name) like '%唐宫海鲜舫' )
UNION
select /*+ INDEX(VENUES VENUES_CITY) */ District,Address1,Name,Phone,VenueID from Venues where ( Venues.City = '上海' and District = '浦东' and branchvenue=0 and status=3 and ((sysdate-end_date)<180)) and Name<>'唐宫海鲜舫' order by VenueID desc
问题:1》用第一个SELECT可以查出所需的记录
下面的SELECT也可以查处所有记录
可是我把这个SQL打到一个文本文件里面没有看到第一条记录室我要的”唐宫海鲜舫“为什么呢
UNION
select /*+ INDEX(VENUES VENUES_CITY) */ District,Address1,Name,Phone,VenueID from Venues where ( Venues.City = '上海' and District = '浦东' and branchvenue=0 and status=3 and ((sysdate-end_date)<180)) and Name<>'唐宫海鲜舫' order by VenueID desc
问题:1》用第一个SELECT可以查出所需的记录
下面的SELECT也可以查处所有记录
可是我把这个SQL打到一个文本文件里面没有看到第一条记录室我要的”唐宫海鲜舫“为什么呢
解决方案 »
- 寻求帮助:oracle 10g用imp导入数据的时候报错:ORA-01658: 无法为表空间 MAXDATA 中的段创建 INITIAL 区
- 简单显示参数问题
- 请来帮忙--先谢了
- 求教数据库特征匹配的问题
- 如何查找long中的数据???
- 如何查询具有某个角色的所有用户?
- oracle 新手问个简单的问题。
- 请给我客户端访问ORACLE需要的几个动态连接库.100分.
- Oracle8.1.7的SQL中,如何实现Select ..... case when 语句?????
- 为什么我的oracle账号,密码在sqlplus/nolog里连接sys,都是对的,但是登录直接登录o
- 很急的问题,请高手帮忙!(一直在线等候)
- sql求助
(NO, HS_NAME, DRAWINGNAME, TYPE, GRAPHIC)
AS
SELECT PROJECTNO as no, NO as hs_name, DRAWINGNAME,
TYPE, GRAPHIC FROM KC_PROJECTDRAWMANAGE;
UNION
SELECT EQUIPMENTNO as no, NO as hs_name, DRAWINGNAME,
TYPE, GRAPHIC FROM LANGFANG.KC_EQUIPMENTFILEMANAGE;
UNION
SELECT DOCUMENTNO as no, NO as hs_name, DRAWINGNAME,
TYPE, GRAPHIC FROM LANGFANG.KC_RUNRECORDMANAGE;
我这段sql在oracle里,只能得到表一的是数据是为什么呀?
得不到后面两个表的数据,
(NO, HS_NAME, DRAWINGNAME, TYPE, GRAPHIC)
AS
SELECT PROJECTNO as no, NO as hs_name, DRAWINGNAME,
TYPE, GRAPHIC FROM KC_PROJECTDRAWMANAGE
UNION
SELECT EQUIPMENTNO as no, NO as hs_name, DRAWINGNAME,
TYPE, GRAPHIC FROM LANGFANG.KC_EQUIPMENTFILEMANAGE
UNION
SELECT DOCUMENTNO as no, NO as hs_name, DRAWINGNAME,
TYPE, GRAPHIC FROM LANGFANG.KC_RUNRECORDMANAGE;
我这段sql在oracle里,不能实现是因为GRAPHIC是long raw类型,
不知道为什么这个类型在这里不可以用来创建视图,哪位大哥能给点意见
(NO, HS_NAME, DRAWINGNAME, TYPE, GRAPHIC)
AS
SELECT PROJECTNO as no, NO as hs_name, DRAWINGNAME,
TYPE, GRAPHIC FROM KC_PROJECTDRAWMANAGE
UNION ALL
SELECT EQUIPMENTNO as no, NO as hs_name, DRAWINGNAME,
TYPE, GRAPHIC FROM LANGFANG.KC_EQUIPMENTFILEMANAGE
UNION ALL
SELECT DOCUMENTNO as no, NO as hs_name, DRAWINGNAME,
TYPE, GRAPHIC FROM LANGFANG.KC_RUNRECORDMANAGE;
这样些就可以了,谢谢回答的同志,这个也是别人告诉我的,我试出来的,