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'

原文地址:https://www.cnblogs.com/huhuan123/p/6227357.html