Dulu masa study buat coding sikit-sikit jak tapi sekarang
"mak ai"..Penat oh..Tapi mau buat cam mana keja
tetap di teruskan untuk sebungkus maggi..hehe..Kalau dulu
peribahasanya "Demi Sesuap Nasi" sebab dulu maggi lum ada
lagi..akakaka..
Select empname, empno, job, sal from emp where area = 'SABAH';
Kini-Kini
SELECT "HRM_LG_TRANS"."ENTITY", "HRM_LG_TRANS"."EMPNO",
"HRM_LG_TRANS"."LG_NUMBER",
"HRM_LG_TRANS"."LG_TYPE",
"HRM_LG_TRANS"."DOC_CODE",
"HRM_LG_TRANS"."TREAT_TYPE",
"HRM_LG_TRANS"."ELIGIBILITY",
"HRM_LG_TRANS"."LG_ISSUE_DATE",
"HRM_DOCLISTING_MASTER"."PAN_CODE",
"HRM_DOCLISTING_MASTER"."DOC_NAME",
"HRM_PANEL_INFO_MASTER_A"."PAN_NAME",
"HR_EMP_PROFILE_A"."EMPNAME",
"HR_EMP_PROFILE_A"."ICNO_NEW",
"HR_EMP_PROFILE_A"."ICNO_OLD",
"HRM_LG_TRANS"."RECIPIENT_NOT_EMP",
"HRM_LG_TRANS"."RECIPIENT",
"HRM_LG_TRANS"."RECIPIENT_RELATIONSHIP",
"HR_EMP_PROFILE_A"."GRADE_CODE",
"HRM_TREATYPE_MASTER"."TREAT_DESC",
"HRM_TREATYPE_MASTER"."ENTITY",
"HRM_ELIG_TRANS"."TREAT_TYPE",
"HRM_ELIG_TRANS"."TREATMENT_MAX_AMOUNT",
"HRM_PANEL_INFO_MASTER_A"."PAN_ADD1",
"HRM_PANEL_INFO_MASTER_A"."PAN_ADD2",
"HRM_PANEL_INFO_MASTER_A"."PAN_ADD3",
"HRM_PANEL_INFO_MASTER_A"."PAN_POSTCODE",
"HR_CHILD_DTLS"."ICNO",
"HR_EMP_SPOUSE"."ICNO",
"HR_CHILD_DTLS"."DOB",
"HR_EMP_SPOUSE"."DOB",
"HR_EMP_PROFILE_A"."DOB",
"HRM_LG_TRANS"."LG_EXPIRY_DATE",
"HRM_LG_MASTER"."HOSPITAL_TYPE",
"HR_POSITION_MSTR"."POSITION_CODE",
"HR_POSITION_MSTR"."POSITION_DESC",
"HR_EMP_PROFILE_B"."EMPNAME",
"HR_EMP_PROFILE_C"."EMPNAME",
"HRM_LG_TRANS"."REMARKS",
"HR_ENTITY"."NAME",
"HR_ENTITY"."ADDR1",
"HR_ENTITY"."ADDR2",
"HR_ENTITY"."ADDR3",
"HR_ENTITY"."POST_CODE",
"HR_ENTITY"."CITY",
"HR_ENTITY"."STATE",
"HRM_LG_TRANS"."ADDRESSED_BY",
"HRM_PANEL_INFO_MASTER_B"."PAN_NAME",
"HRM_PANEL_INFO_MASTER_B"."PAN_ADD1",
"HRM_PANEL_INFO_MASTER_B"."PAN_ADD2",
"HRM_PANEL_INFO_MASTER_B"."PAN_ADD3",
"HRM_PANEL_INFO_MASTER_B"."PAN_POSTCODE",
"HR_EMP_PROFILE_A"."DEPT_CODE",
"HR_DEPT_MSTR"."DEPT_DESC"
FROM "HRM_LG_TRANS",
"HRM_DOCLISTING_MASTER",
"HRM_PANEL_INFO_MASTER" "HRM_PANEL_INFO_MASTER_A",
"HR_EMP_PROFILE" "HR_EMP_PROFILE_A",
"HRM_TREATYPE_MASTER",
"HRM_ELIG_TRANS",
"HR_CHILD_DTLS",
"HR_EMP_SPOUSE",
"HR_EMP_PROFILE" "HR_EMP_PROFILE_B",
"HR_EMP_PROFILE" "HR_EMP_PROFILE_C",
"HR_POSITION_MSTR",
"HRM_LG_MASTER",
"HR_ENTITY",
"HRM_PANEL_INFO_MASTER" "HRM_PANEL_INFO_MASTER_B",
"HR_DEPT_MSTR"
WHERE ( HRM_LG_TRANS.ENTITY = HR_EMP_SPOUSE.ENTITY (+)) AND
( HRM_LG_TRANS.EMPNO = HR_EMP_SPOUSE.EMPNO (+)) AND
( HRM_LG_TRANS.RECIPIENT = HR_EMP_SPOUSE.SPOUSE_NAME (+)) AND
( HRM_LG_TRANS.ENTITY = HR_CHILD_DTLS.ENTITY (+)) AND
( HRM_LG_TRANS.EMPNO = HR_CHILD_DTLS.EMPNO (+)) AND
( HRM_LG_TRANS.RECIPIENT = HR_CHILD_DTLS.CHILD_NAME (+)) AND
( "HRM_LG_TRANS"."DOC_CODE" = "HRM_DOCLISTING_MASTER"."DOC_CODE" ) AND
( "HRM_LG_TRANS"."ENTITY" = "HR_EMP_PROFILE_A"."ENTITY" ) AND
( "HRM_LG_TRANS"."EMPNO" = "HR_EMP_PROFILE_A"."EMPNO" ) AND
( "HRM_LG_TRANS"."ENTITY" = "HR_EMP_PROFILE_B"."ENTITY" ) AND
( "HRM_LG_TRANS"."PREPARED_BY" = "HR_EMP_PROFILE_B"."EMPNO" ) AND
( "HRM_LG_TRANS"."ENTITY" = "HR_EMP_PROFILE_C"."ENTITY" ) AND
( "HRM_LG_TRANS"."APPROVE_BY" = "HR_EMP_PROFILE_C"."EMPNO" ) AND
( "HR_POSITION_MSTR"."POSITION_CODE" = "HR_EMP_PROFILE_C"."POSITION_CODE" ) AND
( "HRM_DOCLISTING_MASTER"."ENTITY" = "HRM_PANEL_INFO_MASTER_A"."ENTITY" ) AND
( "HR_EMP_PROFILE_A"."ENTITY" = "HRM_ELIG_TRANS"."ENTITY" ) AND
( "HR_EMP_PROFILE_A"."GRADE_CODE" = "HRM_ELIG_TRANS"."GRADE_CODE" ) AND
( "HRM_ELIG_TRANS"."TREAT_TYPE" = "HRM_TREATYPE_MASTER"."TREAT_TYPE" ) AND
( "HRM_LG_TRANS"."LG_TYPE" = "HRM_LG_MASTER"."LG_TYPE" ) AND
( "HRM_LG_TRANS"."ENTITY" = "HR_ENTITY"."ENTITY" ) AND
( "HRM_LG_TRANS"."ENTITY" = "HRM_PANEL_INFO_MASTER_B"."ENTITY" ) AND
( "HRM_LG_TRANS"."ADDRESSED_BY" = "HRM_PANEL_INFO_MASTER_B"."PAN_CODE" ) AND
( "HRM_LG_TRANS"."ENTITY" = "HR_DEPT_MSTR"."ENTITY" ) AND
( "HR_EMP_PROFILE_A"."DEPT_CODE" = "HR_DEPT_MSTR"."DEPT_CODE" ) AND
( ( "HRM_LG_TRANS"."ELIGIBILITY" = 'Y' ) AND
( "HRM_LG_MASTER"."HOSPITAL_TYPE" = 'P' ) )




















Free To Register