Sql Monitoring

select expe.expecod No_Berkas,
expe.expeyea Thn_Berkas,
tpro.tprodes Prosedur,
expe.expedatini Tgl_Mulai,
expe.expedatend Tgl_Akhir
from expe,tpro
where expe.tprocod=tpro.tprocod
and expe.stexcod="OP"
and expe.expecod<>0
order by 1 desc,4 desc;

no_berkas tind nama_pemohon 301 208 307

select * from expe
where expecod=1524
and expeyea=2005;

select * from suex where expeid=33341;

select * from shak where shakcod in (12,54431);

select * from d301 where expeid=33341;

select expe.expecod,
expe.expeyea,
tind.tindcod,
tind.tinddes,
shak.shaknam,
d301.d301seq,
d301.d301yea,
d208.d208seq,
d208.d208yea
from expe,tind,shak,d301,d208,suex
where expe.expeyea=2005
and month(expe.expedatini)="01"
and suex.expeid=expe.expeid
and suex.suexflgapp="Y"
and shak.shakcod=suex.shakcod
and d301.expeid=expe.expeid
and d208.expeid=d301.expeid
and d301.tindcod=tind.tindcod
order by 3;