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多对多
- 配置Oracle AS服务后服务不能启动。
- 求sql语句(类似开关的判断,付详细说明、建表和测试数据插入脚本)
- 在导出整个数据库时,为什么要输入主机身份证明?
- exp导出表空间和imp导入表空间不一致怎么导入 ??
- 如何插入日期格式的数据(oracle数据库)
- 这样的查询要求能够用一个SQL语句就实现呢?
- 创建一个用户,grant create any table to ev,但user还是不能建表,为什么?
- 气死我了!!!为什么我的Oracle9i就是装不上呢??
- ORACLE 11G R2 RAC 设置监听密码并取消本地用户认证后 无法动态注册
- 很急的问题,请高手帮忙!(一直在线等候)
- 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;
这样些就可以了,谢谢回答的同志,这个也是别人告诉我的,我试出来的,