oracle数据查询
select * from XMBL_EM_DBBACK where f_djbh='DB01201612270013'
select * from flow_task_list where biz_djbh='DB01201612270015' order by op_time desc
select * from SYS_OBJECTs where obj_id= 'YKT_ZZJG';
select * from sys_objects where obj_id='PX_CJBT_HH'
select * from sys_objcols where obj_id='PX_CJBT_HH';
SELECT * FROM PX_DJLX;
select * from sys_objects where obj_id='TEST111 '
select * from sys_objcols;
select * from sys_model A WHERE MDL_ID LIKE '%CJGL%';
select * from px_cjbt_hh;
select * from PX_CJBT_HH ;
SELECT * FROM SYS_MDL_BH_MOM_CJGL_HH 查询单据编号生成规则表的编号
select * from TESTZYPX_9999.SYS_MDL_VAL where MDL_ID='MOM_CJGL_HH ';
select * from flow_status_list for update 查询当前的流程状态
delete from flow_status_list where flow_id='PX_CJGL'
清醒时做事,糊涂时读书,大怒时睡觉,独处时思考;做一个幸福的人,读书,旅行,努力工作,关心身体和心情,成为最好的自己