First Delete specific column then
add this script
ALTER TABLE BPH_UAT.MM_RECONAUDITVFY
ADD (VC_FLAG CHAR(2 BYTE));...
Thursday, February 12, 2015
Trigger for hr_employee table
CREATE OR REPLACE TRIGGER TRG_synch_hpms_doctor
after update or delete of emp_name, job_id on hr_employee
for each row
declare
/*
Purpose : This trigger synchronize the Doctor Name and Designation between HR_EMPLOYEE and HPMS_DOCTOR
Created By: Kazi Mokarem;
Date: 20/03/2011
*/
cursor cur_hpms_doctor is
select doctor_no,doctor_name,designation
from hpms_doctor
where...
Wednesday, February 11, 2015
Wish to data correction for issue, requisation, verify important table and view
mm_irmst
mm_irchd
mm_issuemst
mm_issuechd
mm_receivemst
mm_receivechd
pr_invoicechd
pr_invoicemst
mm_obverify
mmv_itemstocktrns(view) for internal requisation and receive qty.
mm_itemstock
PR_INVOICEMST
PR_INVOICECHD...
Time in Dhaka 
