数据库常用语句
select * from cpb where jcxb='D'and jcsj like '2016-11-08%' 查询D线8号所有的产品
sql2 = "insert into cpb(WGJC_ID)values('" & user_id & "')"
Exc (sql2)
SELECT *
FROM cpb
WHERE REPLACE(ptm,' ','') = REPLACE('A10293600 H16Y141112765AP11D22BT07L1',' ','') for update
update mes_production set ddentry_time=sysdate where bl_id=11
update mes_production set ddentry_time=decode(ddzt,'OK',sysdate+1,null) where bl_id=11
SELECT bl_id2
FROM mes_zl
WHERE line_id = 'D'
and bl_id2 like 'T10496300%'
AND to_char(datetime, 'yyyy-MM-dd') = '2016-12-14';
SELECT COUNT(1)
FROM mes_zl
WHERE line_id = 'D'
AND datetime >= to_date('2016-12-14', 'yyyy-MM-dd')
AND datetime < to_date('2016-12-15', 'yyyy-MM-dd');
UPDATE mes_zl SET bl_id2=REPLACE(bl_id2,'T10496300','T10496310')
insert into cpb (ptm) select ptm from cpb_tmp;向表cpb中插入表cpb_tmp中的数据
select * from cpb a where exists (select 1 from cpb_tmp b where a.ptm = b.ptm);在表cpb中查询从表cpb_tmp插入的数据
select count(1) from cpb；查询表cpb中数据数目
update mes_zl set BL_ID1 = UPPer(BL_ID1) where bl_id1 ='A10293600 H171101110348AP11d22Bt06L1' ；将条码转换成大写
update cpb_log set ptm= replace(UPPer(ptm),' ',' ') where ptm ='A10293600 H171101110348AP11d22Bt06L1'；将条码转换成大写，同时将六格替换成三格
SELECT COUNT(*)
,jcxb
FROM cpb
WHERE bzsj >= (to_char(SYSDATE, 'yyyy-mm-dd') || ' 08:00:00')
AND bzsj < (to_char(SYSDATE, 'yyyy-mm-dd') || ' 09:00:00')
GROUP BY jcxb ；查询8点到9点各线的产能
SELECT t.*
,decode(a.work_hour, NULL, 0, 0, 0, a.capacity_day / a.work_hour) AS hh_avg
FROM (SELECT jcxb
,to_char(SYSDATE, 'yyyy-mm-dd') AS workdate
,SUM(decode(hh, '00', amount, 0)) AS hh00
,SUM(decode(hh, '01', amount, 0)) AS hh01
,SUM(decode(hh, '02', amount, 0)) AS hh02
,SUM(decode(hh, '03', amount, 0)) AS hh03
,SUM(decode(hh, '04', amount, 0)) AS hh04
,SUM(decode(hh, '05', amount, 0)) AS hh05
,SUM(decode(hh, '06', amount, 0)) AS hh06
,SUM(decode(hh, '07', amount, 0)) AS hh07
,SUM(decode(hh, '08', amount, 0)) AS hh08
,SUM(decode(hh, '09', amount, 0)) AS hh09
,SUM(decode(hh, '10', amount, 0)) AS hh10
,SUM(decode(hh, '11', amount, 0)) AS hh11
,SUM(decode(hh, '12', amount, 0)) AS hh12
,SUM(decode(hh, '13', amount, 0)) AS hh13
,SUM(decode(hh, '14', amount, 0)) AS hh14
,SUM(decode(hh, '15', amount, 0)) AS hh15
,SUM(decode(hh, '16', amount, 0)) AS hh16
,SUM(decode(hh, '17', amount, 0)) AS hh17
,SUM(decode(hh, '18', amount, 0)) AS hh18
,SUM(decode(hh, '19', amount, 0)) AS hh19
,SUM
(decode(hh, '20', amount, 0)) AS hh20
,SUM(decode(hh, '21', amount, 0)) AS hh21
,SUM(decode(hh, '22', amount, 0)) AS hh22
,SUM(decode(hh, '23', amount, 0)) AS hh23
FROM (SELECT COUNT(*) AS amount
,jcxb
,to_char(to_date(substr(bzsj, 1, 19)
,'yyyy-mm-dd hh24:mi:ss')
,'hh24') AS hh
FROM cpb
WHERE to_char(to_date(substr(bzsj, 1, 19)
,'yyyy-mm-dd hh24:mi:ss')
,'yyyy-mm-dd') = to_char(SYSDATE, 'yyyy-mm-dd')
GROUP BY jcxb
,to_char(to_date(substr(bzsj, 1, 19)
,'yyyy-mm-dd hh24:mi:ss')
,'hh24')
ORDER BY jcxb
,to_char(to_date(substr(bzsj, 1, 19)
,'yyyy-mm-dd hh24:mi:ss')
,'hh24')) t
GROUP BY jcxb
ORDER BY jcxb) t
LEFT JOIN mes_capacity_set a
ON t.jcxb = a.line_name
AND to_char(a.work_date, 'yyyy-mm-dd') = t.workdate
create public database link mes_LINK
connect to fdh1 identified by fdh1
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =192.168.168.10 )(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = topprod)
)
)' 创建 DBLINK
D:\FineReport_8.0\WebReport\WEB-INF\reportlets 报表目录
http://192.168.2.20:8088/HBReport/ReportServer?reportlet=hbreport/mes/GetCapacityByHour.cpt 产能报表地址
D:\Program Files\Apache Software Foundation\Tomcat 7.0\webapps\HBReport\WEB-INF\reportlets\hbreport\mes 产能报表服务器地址
https://www.360docs.net/doc/cd7037759.html,/OA/%E7%BB%A9%E6%95%88%E7%B3%BB%E7%BB%9F_%E6%BA%90%E7%A0%81/login.aspx 上传数据地址
https://www.360docs.net/doc/cd7037759.html,/OA_CS/login.aspx 考核地址
http://192.168.168.6/web_%E7%94%9F%E4%BA%A7%E6%97%A5%E6%8A%A5%E8%A1%A8/Default2.aspx 生产报表地址
C:\Users\Administrator\AppData\Local\Temp 数据库拷贝的数据文件存放位置
E:\BaiduNetdiskDownload\oracle 10g 数据库文件位置
1.条形码扫描枪扫描时，蜂鸣声正常但是没有数据传输
造成这一问题的原因可能是扫描枪的扫描设置不正确，导致的扫描枪无数据传输，另外一种原因可能是传输的线材出现了故障，才导致没有数据的传输。
解决办法：可以参照说明书，重新设置扫描枪，确保相对应的数据线的设置是正确的。
2.扫描枪的串口线已经连接好
，但是读码时没有数据传输
造成这一问题的原因可能有两种，其一可能是没有设置扫描枪的串口模式，其二可能是通信协议错误。
解决办法：根据说明书，将扫描枪设置为串口模式，并且确保正确的通信协议。
3.扫描枪扫描时，LED灯不亮，并且没有蜂鸣声、没有激光
这样的情况可能是扫描枪的电源没有接通，或者是数据线的接口没有插紧，导致的接触不良。
解决办法：首先检查扫描枪的电源是否连接，如果已经连接，就需要检查数据线的接口是否出现松动，最好是将数据线和扫描枪从新连接，确保正常通电使用。
4.扫描枪可以正常的使用，但是没有蜂鸣声
这一情况原因基本上是将扫描枪设置为静音。
解决办法：只有将打印机的蜂鸣器开启即可。
5.扫描枪的启动正常，并且会出现激光，但是不读码
造成这一问题的原因会有很多种，第一种可能是条形码制已经被关闭，第一种可能是条形码已经被损坏，第三种可能是条形码打印是存在质量问题，也就是说条形码本身有质量问题，第四种可能是扫描枪的硬件或者主板出现故障。
解决办法：首先可以开启对应的条形码制，然后检查一下条形码是否被损坏，我们还可以检查一下打印机的模式。
6.扫描枪连接完成后，LED一直闪烁，并且没有声音，也无法扫描
这种情况基本上是由扫描枪内部出现问题，一般都是IC接触不良。
解决办法：出现这种情况可以找经销商维修。
手机事业部 MES数据库 用户：fmes 密码：fmes 数据库：oracl
select c.bl_id,c.bb,b.sk from mes_clmx c left join mes_mz b on c.mz_lot_id=b.lot_id where c.bl_id='70WSM7980YBX1X61AE1713 70WSM7980YBX1X61AE1713'
select * from mes_capacity_set where to_char(work_date, 'yyyy-MM-dd') = '2017-05-18' for update