Ijasah ke Hapus dari tabel Ijasah

Select sth_term,sth_num,sth_course,sth_day,sth_time,sth_room,sth_today,' ',' ',0,std_bdate
From stdacdh,stdmst
where std_code=sth_num and sth_term='0502' and sth_course='BS-4' and sth_fail=2
into '/u1/adsis/bs-4.txt' /

Ulangi untuk semua level. --> ver.01
--------------------------------------------------------
sql>select sth_termsth_num,sth_course,sth_day,sth_time,st_room,'26-Dec-200',' ',' ',' ',' '
from stdacdh
where sth_term='0601' and sth_course='AD-4' and sth_fail=' '
into 'AD-4.TXT'

sql> start 'AD4.TXT'

sql> insert into ijasah: from 'AD-4.TXT' /

Read More