Oracle Export & Import

AUTO BOOK FEES

SELECT A.REGNO,B.REGNO,B.III_SEM FROM TB_PERSONAL A, TB_BOOK_FEE B
 WHERE A.REGNO = B.REGNO
 AND
 A.CURRENT_SEM = 'III'
 AND
 A.STUDY_STATUS IN ('NOW STUDYING','READMISSION')



UPDATE TB_BOOK_FEE
SET III_SEM = 1200
WHERE
REGNO = ANY (
SELECT A.REGNO FROM TB_PERSONAL A, TB_BOOK_FEE B
 WHERE A.REGNO = B.REGNO
 AND
 A.CURRENT_SEM = 'III'
 AND
 A.STUDY_STATUS IN ('NOW STUDYING','READMISSION'))