SQL command not properly ended的错误 - Oracle 10g / 9i - 51CTO技术论坛

社区导航: 专家门诊网络技术操作系统数据库程序设计系统应用考试认证 CIO及信息化站长交流综合交流下载基地 51CTO产品服务

【设为首页 | 收藏本站】

51CTO技术论坛» Oracle 10g / 9i » SQL command not properly ended的错误 [ 打印] [ 订阅] [ 收藏] [ 推荐给朋友] [ 本帖文本页]

论坛跳转:

该主题悬赏的10无忧币已被全部领完

clever101

新新人类

帖子 52
精华 0
无忧币 26
积分 143
阅读权限 20

注册日期 2007-7-22

最后登录 2007-10-15

离线

[查看资料] [发短消息] [Blog]

发表于:2007-9-5 10:15　　标题：SQL command not properly ended的错误
＜上一帖 | 下一帖＞

在pl/sql developer上运行这样一条sql语句：
select t1.borrow_id as borrow_id,
t2.El_Name as resource_name,
t2.El_LabelID as resource_labelid,
t3.user_name as user_name,
t3.user_organization as user_unit,
t1.Borrow_Date as resource_date,
t1.Borrow_ID as objid
from INTEL.CS_EleBorrowInfo t1,
intel.CS_ElectronicInfo t2,
cs_userinfo t3
where t1.Borrow_ObjectID = t2.El_ID
and t1.Borrow_UserID = t3.user_id
and t1.Borrow_Date > to_date('2007-9-4', 'yyyy-mm-dd')
and t1.Borrow_Date  to_date('2007-9-4', 'yyyy-mm-dd')
and t1.Borrow_Date  to_date('2007-9-4', 'yyyy-mm-dd')
and t1.Borrow_Date  to_date('2007-9-4', 'yyyy-mm-dd')
and t1.Borrow_Date  to_date('2007-9-4', 'yyyy-mm-dd')
and t1.Borrow_Date

出现错误： SQL command not properly ended
where t1.Borrow_ObjectID = t2.El_ID
and t1.Borrow_UserID = t3.user_id
and t1.Borrow_Date > to_date('2007-9-4', 'yyyy-mm-dd')
and t1.Borrow_Date
(select t1.borrow_id as borrow_id,
t2.El_Name as resource_name,
t2.El_LabelID as resource_labelid,
t3.user_name as user_name,
t3.user_organization as user_unit,
t1.Borrow_Date as resource_date,
t1.Borrow_ID as objid
from INTEL.CS_EleBorrowInfo t1,
intel.CS_ElectronicInfo t2,
cs_userinfo t3
where t1.Borrow_ObjectID = t2.El_ID
and t1.Borrow_UserID = t3.user_id
and t1.Borrow_Date > to_date('2007-9-4', 'yyyy-mm-dd')
and t1.Borrow_Date  to_date('2007-9-4', 'yyyy-mm-dd')
and t1.Borrow_Date  to_date('2007-9-4', 'yyyy-mm-dd')
and t1.Borrow_Date  to_date('2007-9-4', 'yyyy-mm-dd')
and t1.Borrow_Date  to_date('2007-9-4', 'yyyy-mm-dd')
and t1.Borrow_Date
结果又出现错误：missing right parenthesis （右括号不匹配）
错误出现在
(select t1.borrow_id as borrow_id,
t2.El_Name as resource_name,
t2.El_LabelID as resource_labelid,
t3.user_name as user_name,
t3.user_organization as user_unit,
t1.Borrow_Date as resource_date,
t1.Borrow_ID as objid
from INTEL.CS_EleBorrowInfo t1,
intel.CS_ElectronicInfo t2,
cs_userinfo t3
where t1.Borrow_ObjectID = t2.El_ID
and t1.Borrow_UserID = t3.user_id
and t1.Borrow_Date > to_date('2007-9-4', 'yyyy-mm-dd')
and t1.Borrow_Date

网络虽虚拟，技术无边界，来看看大家“真面目”！

2007-9-5 10:15

1楼

[ 顶部 ]

clever101

新新人类

帖子 52
精华 0
无忧币 26
积分 143
阅读权限 20

注册日期 2007-7-22

最后登录 2007-10-15

离线

[查看资料] [发短消息] [Blog]

发表于:2007-9-5 15:32　 ,被系统奖励 5 点无忧币

在itpub上请教一位大虾，找到了一种办法，代码如下：
select t1.borrow_id       as borrow_id,
   t2.El_Name          as resource_name,
   t2.El_LabelID       as resource_labelid,
   t3.user_name       as user_name,
   t3.user_organization as user_unit,
   t1.Borrow_Date    as resource_date,
   t1.Borrow_ID       as objid
  from INTEL.CS_EleBorrowInfo  t1,
   intel.CS_ElectronicInfo t2,
   cs_userinfo          t3
where t1.Borrow_ObjectID = t2.El_ID
and t1.Borrow_UserID = t3.user_id
and t1.Borrow_Date > to_date('2007-9-4', 'yyyy-mm-dd')
and t1.Borrow_Date < to_date('2007-9-5', 'yyyy-mm-dd')
union
select t1.borrow_id       as borrow_id,
   t2.Film_Name       as resource_name,
   t2.Film_LabelID    as resource_labelid,
   t3.user_name       as user_name,
   t3.user_organization as user_unit,
   t1.Borrow_Date    as resource_date,
   t1.Borrow_ID       as objid
  from INTEL.CS_FilmBorrowInfo t1, intel.CS_FilmInfo t2, cs_userinfo t3
where t1.Borrow_ObjectID = t2.Film_ID
and t1.Borrow_UserID = t3.user_id
and t1.Borrow_Date > to_date('2007-9-4', 'yyyy-mm-dd')
and t1.Borrow_Date < to_date('2007-9-5', 'yyyy-mm-dd')
union
select t1.borrow_id       as borrow_id,
   t2.ReliefMap_Name as resource_name,
   t2.ReliefMap_LabelID as resource_labelid,
   t3.user_name       as user_name,
   t3.user_organization as user_unit,
   t1.Borrow_Date    as resource_date,
   t1.Borrow_ID       as objid
  from INTEL.CS_MapBorrowInfo t1, intel.CS_ReliefMapInfo t2, cs_userinfo t3
where t1.Borrow_ObjectID = t2.ReliefMap_ID
and t1.Borrow_UserID = t3.user_id
and t1.Borrow_Date > to_date('2007-9-4', 'yyyy-mm-dd')
and t1.Borrow_Date < to_date('2007-9-5', 'yyyy-mm-dd')
union
select t1.borrow_id       as borrow_id,
   t2.Book_Name       as resource_name,
   t2.Book_LabelID    as resource_labelid,
   t3.user_name       as user_name,
   t3.user_organization as user_unit,
   t1.Borrow_Date    as resource_date,
   t1.Borrow_ID       as objid
  from INTEL.CS_BookBorrowInfo t1, intel.CS_BookInfo t2, cs_userinfo t3
where t1.Borrow_ObjectID = t2.Book_ID
and t1.Borrow_UserID = t3.user_id
and t1.Borrow_Date > to_date('2007-9-4', 'yyyy-mm-dd')
and t1.Borrow_Date < to_date('2007-9-5', 'yyyy-mm-dd')
union
select t1.borrow_id       as borrow_id,
   t2.Maga_Name       as resource_name,
   t2.Maga_LabelID    as resource_labelid,
   t3.user_name       as user_name,
   t3.user_organization as user_unit,
   t1.Borrow_Date    as resource_date,
   t1.Borrow_ID       as objid
  from INTEL.CS_MagaBorrowInfo t1, intel.CS_MagazineInfo t2, cs_userinfo t3
where t1.Borrow_ObjectID = t2.Maga_ID
and t1.Borrow_UserID = t3.user_id
and t1.Borrow_Date > to_date('2007-9-4', 'yyyy-mm-dd')
and t1.Borrow_Date < to_date('2007-9-5', 'yyyy-mm-dd')
order by 6 desc;

网络虽虚拟，技术无边界，来看看大家“真面目”！

2007-9-5 15:32

2楼

[ 顶部 ]

老三

初级工程师

帖子 1860
精华 2
无忧币 1810
积分 3703
阅读权限 50
来自 (保密)

注册日期 2006-6-27

最后登录 2008-8-30

离线

[查看资料] [发短消息] [Blog]

[个人主页]

发表于:2007-9-7 11:49　 ,被系统奖励 5 点无忧币

看晕了，这条件咋这样？
where t1.Borrow_ObjectID = t2.El_ID
and t1.Borrow_UserID = t3.user_id
and t1.Borrow_Date > to_date('2007-9-4', 'yyyy-mm-dd')
and t1.Borrow_Date  to_date('2007-9-4', 'yyyy-mm-dd')
and t1.Borrow_Date  to_date('2007-9-4', 'yyyy-mm-dd')
and t1.Borrow_Date  to_date('2007-9-4', 'yyyy-mm-dd')
and t1.Borrow_Date  to_date('2007-9-4', 'yyyy-mm-dd')
and t1.Borrow_Date

偶的Blog有理想，有目标，就有动力；成功源于你我真诚的合作！

2007-9-7 11:49

3楼

[ 顶部 ]

yibi
技术员