oracle修改的sql语句,请教oracle高手 SQL语句该怎么修改,如何写。

当前位置:我的异常网» Oracle开发 » 请教oracle高手 SQL语句该怎么修改,如何写。

请教oracle高手 SQL语句该怎么修改,如何写。

www.myexceptions.net  网友分享于:2013-02-04  浏览:18次

请问oracle高手 SQL语句该如何修改,怎么写。急!!!

后台为ORACEL数据库:

select A.SORDER,A.KOTECD,A.JSTSTM,A.JSTETM,B.WAREHUSFG,B.WAREETM,

from factv2.SAGPLNFL A,FACTV2.SGPROGSS B

Where B.WAREHUSFG=1(1为入库标志)

AND A.SORDER=B.SORDER

ORDER BY A.SORDER

(说明:SORDER为表单号 KOTECD为工序号 JSTSTM为工序开始时间,JSTETM为工序结束时间。WAREHUSFG入库状态,WAREETM入库时间)

得到以下数据:

SORDER KOTECED JSTSTM JSTETM WAREHUSFG WAREETM

0310341010152008-12-31 13:58:002008-12-31 13:58:001 2009-01-06 06:15:00

0310341020152008-12-31 13:58:002008-12-31 13:58:001 2009-01-06 06:15:00

0310341020252008-12-31 18:36:002008-12-31 20:40:001 2009-01-06 06:15:00

0310341020262008-12-31 20:44:002008-12-31 20:45:001 2009-01-06 06:15:00

0310341020302008-12-31 23:29:002008-12-31 23:29:001 2009-01-06 06:15:00

0310341020362009-01-01 05:32:002009-01-01 07:23:001 2009-01-06 06:15:00

0310341020402009-01-02 15:04:002009-01-02 15:04:001 2009-01-06 06:15:00

0310341020542009-01-02 23:02:002009-01-02 23:02:001 2009-01-06 06:15:00

0310341020702009-01-03 04:55:002009-01-03 04:55:001 2009-01-06 06:15:00

0310341020752009-01-03 05:28:002009-01-03 05:28:001 2009-01-06 06:15:00

0310341020802009-01-03 15:08:002009-01-03 15:08:001 2009-01-06 06:15:00

0310341020902009-01-05 05:53:002009-01-05 05:53:001 2009-01-06 06:15:00

0310341020952009-01-05 06:15:002009-01-05 06:15:001 2009-01-06 06:15:00

031034103000null null 1 2009-01-06 06:15:00

0310342010152008-12-31 13:58:002008-12-31 13:58:001 2009-01-06 11:18:00

0310342020152008-12-31 13:58:002008-12-31 15:30:001 2009-01-06 11:18:00

0310342020252008-12-31 20:41:002008-12-31 22:01:001 2009-01-06 11:18:00

0310342020262008-12-31 22:18:002008-12-31 22:18:001 2009-01-06 11:18:00

0310342020302009-01-01 01:34:002009-01-01 01:34:001 2009-01-06 11:18:00

0310342020362009-01-01 05:32:002009-01-01 07:23:001 2009-01-06 11:18:00

0310342020402009-01-02 13:36:002009-01-02 13:37:001 2009-01-06 11:18:00

0310342020542009-01-02 23:01:002009-01-02 23:01:001 2009-01-06 11:18:00

0310342020702009-01-03 12:35:002009-01-03 12:35:001 2009-01-06 11:18:00

0310342020752009-01-03 13:48:002009-01-03 13:48:001 2009-01-06 11:18:00

0310342020802009-01-03 15:09:002009-01-03 15:09:001 2009-01-06 11:18:00

0310342020902009-01-05 08:53:002009-01-05 08:53:001 2009-01-06 11:18:00

0310342020952009-01-05 11:17:002009-01-05 11:18:001 2009-01-06 11:18:00

031034203000null null 1 2009-01-06 11:18:00

0310343010152008-12-31 12:56:002008-12-31 12:56:001 2009-01-06 11:18:00

0310343020152008-12-31 12:56:002008-12-31 18:09:001 2009-01-06 11:18:00

0310343020252008-12-31 22:02:002008-12-31 23:29:001 2009-01-06 11:18:00

0310343020262008-12-31 23:36:002008-12-31 23:36:001 2009-01-06 11:18:00

0310343020302009-01-01 03:16:002009-01-01 03:16:001 2009-01-06 11:18:00

0310343020362009-01-01 05:32:002009-01-01 07:23:001 2009-01-06 11:18:00

0310343020402009-01-02 15:41:002009-01-02 15:41:001 2009-01-06 11:18:00

0310343020542009-01-03 01:45:002009-01-03 01:45:001 2009-01-06 11:18:00

0310343020702009-01-03 11:51:002009-01-03 11:52:001 2009-01-06 11:18:00

0310343020752009-01-03 11:52:002009-01-03 11:52:001 2009-01-06 11:18:00

0310343020802009-01-03 15:08:002009-01-03 15:08:001 2009-01-06 11:18:00

0310343020902009-01-05 10:06:002009-01-05 10:06:001 2009-01-06 11:18:00

0310343020952009-01-05 11:17:002009-01-05 11:17:001 2009-01-06 11:18:00

031034303000null null 1 2009-01-06 11:18:00

文章评论

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值