요청지 : [AAA]기타사업장 (etc_cd)
작성자 : 희원 (Heewon)
연락처 : 055-238-9156
E-Mail : heewonsoft.co@gmail.com
요청일 : 2026-08-11
구분 : 긴급
관련메뉴 :
제목 : [동국대] 전산요청
내용 : * 요청방식(메일/유선) : 카톡
* 요청자 : 송좌근대리
* 내용 : exec :HOSCOD := '01';
1. 쿼리삭제
exec :RESNUM := '6407151042218';
SELECT
pls_decrypt_b64_id(RESNO, '999') RESNO
, PATNME, PATNUM, SEXTYP, PATTYP, BITDAT, INSUNO
, ZIPCOD, ADDRS1, ADDRS2, TELNO1, TELNO2, PNOTYP
, EMAIL , CUSTCD, CUSTNM, EMPNUM, DEPTNM
, TELNO3, TELNO4, IPSADT, JNIPDT, JIKJCD, JIKJNM
, JIKGNM, JIKWNM, JOBTYP, PRESNO, PROGCD, PROGNM
, CLASS1, CLASS2, CLASS3, POCKET, NATION, PASSNO, PATNM2, JOBTIM
, ENTDAT, ENTEID, EDTDAT, EDITID, EDITIP, NATICD, PATNM3, VIPTYP
, PATTXT, CERTYP, CERNUM, CERTYN
, '' DPTNM2, '' DPTNM3
,(SELECT Z.JUGTYP FROM IMCUSTMT Z WHERE Z.CUSTCD = A.CUSTCD AND Z.CUSTYP = '1'
AND Z.HOSCOD = :HOSCOD
) CALTYP
,(SELECT Z.REMARK FROM IMCUSTMT Z WHERE Z.CUSTCD = A.CUSTCD AND Z.CUSTYP = '1'
AND Z.HOSCOD = :HOSCOD
) CSTRMK
, '' DCRATE
, '' JBGSCD, '' JBGSNM
, '' NATCD2
FROM IMPATBAT A
WHERE 1=1
AND pls_decrypt_b64_id(RESNO, '999') = :RESNUM;
2.쿼리변경
SELECT
:RESNUM RESNO
, PATNME, PATNUM, SEXTYP, PATTYP, BITDAT, INSUNO
, ZIPCOD, ADDRS1, ADDRS2, TELNO1, TELNO2, PNOTYP
, EMAIL , CUSTCD, CUSTNM, EMPNUM, DEPTNM
, TELNO3, TELNO4, IPSADT, JNIPDT, JIKJCD, JIKJNM
, JIKGNM, JIKWNM, JOBTYP, PRESNO, PROGCD, PROGNM
, CLASS1, CLASS2, CLASS3, POCKET, NATION, PASSNO, PATNM2, JOBTIM
, ENTDAT, ENTEID, EDTDAT, EDITID, EDITIP, NATICD, PATNM3, VIPTYP
, PATTXT, CERTYP, CERNUM, CERTYN
, '' DPTNM2, '' DPTNM3
,(SELECT Z.JUGTYP FROM IMCUSTMT Z WHERE Z.CUSTCD = A.CUSTCD AND Z.CUSTYP = '1'
AND Z.HOSCOD = :HOSCOD
) CALTYP
,(SELECT Z.REMARK FROM IMCUSTMT Z WHERE Z.CUSTCD = A.CUSTCD AND Z.CUSTYP = '1'
AND Z.HOSCOD = :HOSCOD
) CSTRMK
, '' DCRATE
, '' JBGSCD, '' JBGSNM
, '' NATCD2
FROM IMPATBAT A
WHERE RESNO = PLS_ENCRYPT_B64_ID(:RESNUM, '999');
3.쿼리삭제2
select count(*) from IMPATBAT; --77151
첨부파일1 :
첨부파일2 :
첨부파일3 :