Oracle Forms 6i Reports 6i

Oracle Own Front end Developer 2000

Codings I write

update tb_fine_fee set V_sem = (nvl(V_sem,0) +100) where regno = any (
 select a.regno  from tb_personal a, tb_bus_fee b
 where a.regno = b.regno
 and a.current_sem ='V'
and a.study_status = 'NOW STUDYING')
/

update tb_fine_fee set i_sem = (nvl(i_sem,0) +100) where regno = any (
 select a.regno  from tb_personal a, tb_bus_fee b
 where a.regno = b.regno
 and a.current_sem ='I'
and a.study_status = 'NOW STUDYING'



update tb_fine_fee set i_sem = (nvl(i_sem,0) +100) where regno = any (
 select b.regno from tb_personal a,  tb_fine_fee b
 where a.regno = b.regno
 and a.current_sem = 'I')


 update tb_fine_fee set iii_sem = (nvl(iii_sem,0) +100) where regno = any (
  select b.regno from tb_personal a,  tb_fine_fee b
  where a.regno = b.regno
  and a.current_sem = 'III')


 select a.regno ,a.name, b.regno from tb_personal a, tb_hostel_fee b
 where a.regno = b.regno
 and a.current_sem in ( 'I','III','V')

select c.i_sem,c.regno ,a.regno ,a.name, a.current_sem, b.i_sem,b.iii_sem, b.v_sem,
b.regno from tb_personal a, tb_hostel_fee b, tb_fine_fee c
where a.regno = b.regno
and a.regno = c.regno
and a.current_sem in ( 'I','III','V')

select a.regno from tb_fine_fee b, tb_personal a
where
a.regno = b.regno(+) and
a.current_sem = 'I' and
b.regno is null
/

 insert into tb_fine_fee(regno) (
 select a.regno from tb_fine_fee b, tb_personal a
 where
 a.regno = b.regno(+) and
 a.current_sem = 'I' and
 b.regno is null )
 /



/


/