Select
V_YaoPSZMX.DanWMC customer_name,
'' customer_address,
'' customer_zone,
'' contact_man,
'' tel,
V_YaoPSZMX.BanLSJ item_saledate,
V_YaoPSZMX.YaoPMC item_name,
V_YaoPSZMX.GuiG item_spec,
YaoPXX.DanW item_unit,
V_YaoPSZMX.PiH item_batch,
V_YaoPSZMX.ShuL item_number,
'' item_price
From
V_YaoPSZMX,YaoPXX
Where V_YaoPSZMX.YaoPBH=YaoPXX.YaoPBH And V_YaoPSZMX.LeiB='出库' Or V_YaoPSZMX.LeiB='出退' And V_YaoPSZMX.CangKBH='0011'
And
V_YaoPSZMX.ShangZ=1
And V_YaoPSZMX.BanLSJ>=To_Char(@startdate,'YYYY-MM-DD,HH24:Mi:SS')
And V_YaoPSZMX.BanLSJ<=To_Char(@enddate,'YYYY-MM-DD,HH24:Mi:SS')
V_YaoPSZMX.DanWMC customer_name,
'' customer_address,
'' customer_zone,
'' contact_man,
'' tel,
V_YaoPSZMX.BanLSJ item_saledate,
V_YaoPSZMX.YaoPMC item_name,
V_YaoPSZMX.GuiG item_spec,
YaoPXX.DanW item_unit,
V_YaoPSZMX.PiH item_batch,
V_YaoPSZMX.ShuL item_number,
'' item_price
From
V_YaoPSZMX,YaoPXX
Where V_YaoPSZMX.YaoPBH=YaoPXX.YaoPBH And V_YaoPSZMX.LeiB='出库' Or V_YaoPSZMX.LeiB='出退' And V_YaoPSZMX.CangKBH='0011'
And
V_YaoPSZMX.ShangZ=1
And V_YaoPSZMX.BanLSJ>=To_Char(@startdate,'YYYY-MM-DD,HH24:Mi:SS')
And V_YaoPSZMX.BanLSJ<=To_Char(@enddate,'YYYY-MM-DD,HH24:Mi:SS')
解决方案 »
- 存储过程查询问题
- oracle热备份的问题 resetlogs
- Oracle的几个试题 帮帮忙
- 求助,各位高手解决下问题,关于System.InvalidOperationException: Timeout expired.
- 高手帮忙 万分谢谢!
- ======要做一个定时统计任务 但是不知道具体在哪一层实现======
- 如何全备份一个oracle 数据 库
- 錯誤﹕ORA-00020:Maxinum number of precesses (150) exceeded
- 注册哦oracle数据库失败,请大家帮忙,在线等~~~
- 在DEVELOPE2000中的PL/SQL出错问题
- 求一条SQL,要求分组计算两张表中数量总和
- oracle触发器绑定变量
Select V_YaoPSZMX.DanWMC customer_name,
'' customer_address,
'' customer_zone,
'' contact_man,
'' tel,
V_YaoPSZMX.BanLSJ item_saledate,
V_YaoPSZMX.YaoPMC item_name,
V_YaoPSZMX.GuiG item_spec,
YaoPXX.DanW item_unit,
V_YaoPSZMX.PiH item_batch,
V_YaoPSZMX.ShuL item_number,
'' item_price
From V_YaoPSZMX, YaoPXX
Where V_YaoPSZMX.YaoPBH = YaoPXX.YaoPBH
And V_YaoPSZMX.LeiB = '出库'
Or V_YaoPSZMX.LeiB = '出退'
And V_YaoPSZMX.CangKBH = '0011'
And V_YaoPSZMX.ShangZ = 1
And V_YaoPSZMX.BanLSJ >= To_Char(startdate, 'YYYY-MM-DD,HH24:Mi:SS')
And V_YaoPSZMX.BanLSJ <= To_Char(enddate, 'YYYY-MM-DD,HH24:Mi:SS')
startdate date;
enddate date;
begin
startdate := .. -- 赋值
enddate := ...
Select V_YaoPSZMX.DanWMC customer_name,
'' customer_address,
'' customer_zone,
'' contact_man,
'' tel,
V_YaoPSZMX.BanLSJ item_saledate,
V_YaoPSZMX.YaoPMC item_name,
V_YaoPSZMX.GuiG item_spec,
YaoPXX.DanW item_unit,
V_YaoPSZMX.PiH item_batch,
V_YaoPSZMX.ShuL item_number,
'' item_price
From V_YaoPSZMX, YaoPXX
Where V_YaoPSZMX.YaoPBH = YaoPXX.YaoPBH
And V_YaoPSZMX.LeiB = '出库'
Or V_YaoPSZMX.LeiB = '出退'
And V_YaoPSZMX.CangKBH = '0011'
And V_YaoPSZMX.ShangZ = 1
And V_YaoPSZMX.BanLSJ >= To_Char(startdate, 'YYYY-MM-DD,HH24:Mi:SS') -- 直接写变量名即可。
And V_YaoPSZMX.BanLSJ <= To_Char(enddate, 'YYYY-MM-DD,HH24:Mi:SS');
....
....
end;
And V_YaoPSZMX.BanLSJ >= To_Char(@startdate, 'YYYY-MM-DD,HH24:Mi:SS')
And V_YaoPSZMX.BanLSJ <= To_Char(@enddate, 'YYYY-MM-DD,HH24:Mi:SS');
你说如果BanLSJ为时间型是不是要把 To_char改成TO_Date?