Friday, July 27, 2018
Tuesday, July 24, 2018
Sunday, July 15, 2018
Cursor
12:52 PM
No comments
Purpose : Used to update table column:
DECLARE
CURSOR C1
IS
SELECT EMPLOYEENAME,EMPLOYEECODE
FROM ATI_PMIS_EMPLOYEE
WHERE EMPLOYEECODE IN (SELECT POLICE_BP_NO FROM OP_REGISTRATION
WHERE FULL_NAME IS NULL
AND POLICE_BP_NO IS NOT NULL
AND REL_ID=0)
AND EMPLOYEENAME IS NOT NULL;
BEGIN
FOR I IN C1 LOOP
UPDATE OP_REGISTRATION
SET FULL_NAME=I.EMPLOYEENAME
WHERE POLICE_BP_NO=I.EMPLOYEECODE;
COMMIT;
END LOOP;
END;
DECLARE
CURSOR C1
IS
SELECT EMPLOYEENAME,EMPLOYEECODE
FROM ATI_PMIS_EMPLOYEE
WHERE EMPLOYEECODE IN (SELECT POLICE_BP_NO FROM OP_REGISTRATION
WHERE FULL_NAME IS NULL
AND POLICE_BP_NO IS NOT NULL
AND REL_ID=0)
AND EMPLOYEENAME IS NOT NULL;
BEGIN
FOR I IN C1 LOOP
UPDATE OP_REGISTRATION
SET FULL_NAME=I.EMPLOYEENAME
WHERE POLICE_BP_NO=I.EMPLOYEECODE;
COMMIT;
END LOOP;
END;
Saturday, July 14, 2018
Wednesday, July 11, 2018
Tuesday, July 3, 2018
Sunday, July 1, 2018
Triks for oracle
4:12 PM
No comments
To assign search text in search box :
<>:CTRL_BLK.COMPLAIN_SRC:='<<Search Complain>>';
To assing item record sl. no:
use post query trigger block level:
<>:EMV_COMPLAIN.sl :=:system.trigger_record;
<>:CTRL_BLK.COMPLAIN_SRC:='<<Search Complain>>';
To assing item record sl. no:
use post query trigger block level:
<>:EMV_COMPLAIN.sl :=:system.trigger_record;
Time in Dhaka 
