–\uc624\ub77c\ud074\uc758 \uc554\ud638\ud654\uc640 \ubcf5\ud638\ud654
\n–\uc624\ub77c\ud074\uc758 \uc554\ud638\ud654\ub294 DBMS_OBFUSCATION_TOOLKIT\ub97c \uc774\uc6a9
\n–\uc774 \ud328\ud0a4\uc9c0\uc5d0\ub294 4\uac1c\uc758 \ud504\ub85c\uc2dc\uc800\uac00 \uc788\ub2e4.
\n–\ud504\ub85c\uc2dc\uc800\ub294 VARCHAR2 \ud0c0\uc785 \ubc0f RAW \ud0c0\uc785\uc744 \uc554\ud638\/\ubcf5\ud638\ud654 \uc9c0\uc6d0. \ub2e4\ub978 \ud0c0\uc785\uc740 \uc9c0\uc6d0\ub418\uc9c0 \uc54a\uc73c\ubbc0\ub85c NUMBER \ud0c0\uc785\uc740 TO_CHAR\ub97c \uc774\uc6a9\ud574\uc57c \ud55c\ub2e4.
\n–DBMS_OBFUSCATION_TOOLKIT \ud328\ud0a4\uc9c0\ub294 \uae30\ubcf8\uc801\uc73c\ub85c\ub294 \uc0ac\uc6a9\ud560 \uc218 \uc5c6\ub294 \uc0c1\ud0dc\uc774\ub2e4. \uc124\uce58\uc2dc\uc5d0\ub294 \uc900\ube44 \ub418\uc9c0 \uc54a\uc740 \ud328\ud0a4\uc9c0\uc774\uae30 \ub54c\ubb38\uc774\ub2e4. \uc544\ub798 \ud30c\uc77c\uc744 \uc9c1\uc811 \uc2e4\ud589\ud574\uc57c \ud328\ud0a4\uc9c0\uac00 \uc0dd\uc131\ub418\uace0, \uc900\ube44\uac00 \ub41c\ub2e4.
\nD:\\oracle\\product\\10.2.0\\db_1\\RDBMS\\ADMIN\\dbmsobtk.sql
\nD:\\oracle\\product\\10.2.0\\db_1\\RDBMS\\ADMIN\\prvtobtk.plb<\/p>\n
–SQLPLUS\uc5d0\uc11c SYS\uacc4\uc815\uc73c\ub85c \ub85c\uadf8\uc778\ud55c \ud6c4 \uc2e4\ud589\ud569\ub2c8\ub2e4.
\nSQL> @D:\\oracle\\product\\10.2.0\\db_1\\RDBMS\\ADMIN\\dbmsobtk.sql
\n–>\ud328\ud0a4\uc9c0 \uc0dd\uc131
\nSQL> @D:\\oracle\\product\\10.2.0\\db_1\\RDBMS\\ADMIN\\prvtobtk.plb
\n–>\ud328\ud0a4\uc9c0 \ubcf8\ubb38 \uc0dd\uc131
\n–SYS: DBMS_OBFUSCATION_TOOLKIT \ud328\ud0a4\uc9c0\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uad8c\ud55c\uc744 SCOTT \uc0ac\uc6a9\uc790\uc5d0\uac8c \ubd80\uc5ec
\nGRANT EXECUTE ON DBMS_OBFUSCATION_TOOLKIT TO scott;
\n–SYS: DBMS_OBFUSCATION_TOOLKIT \ud328\ud0a4\uc9c0\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uad8c\ud55c\uc744 \ubaa8\ub4e0 \uc0ac\uc6a9\uc790\uc5d0\uac8c \ubd80\uc5ec
\nGRANT EXECUTE ON DBMS_OBFUSCATION_TOOLKIT TO PUBLIC;
\n———————————–
\n–\uc554\ud638\ud654 \ubc0f \ubcf5\ud638\ud654\uc6a9 \ud328\ud0a4\uc9c0 \uc791\uc131<\/p>\n
(\uc0ac\uc6a9\ud560 \uacf3\uc5d0\uc11c \ud328\ud0a4\uc9c0 \uc0dd\uc131) \ub098\uc758 \uacbd\uc6b0\ub294 scott\uc5d0 \ud588\uc5c8\uc74c.
\n–\uc120\uc5b8
\nCREATE OR REPLACE PACKAGE CryptIT
\nIS
\nFUNCTION encrypt(str VARCHAR2, HASH VARCHAR2)
\nRETURN VARCHAR2;
\nFUNCTION decrypt(str VARCHAR2, HASH VARCHAR2)
\nRETURN VARCHAR2;
\nEND CryptIT;<\/p>\n
–\ubab8\uccb4
\nCREATE OR REPLACE PACKAGE BODY CryptIT
\nIS
\ns VARCHAR2(2000);<\/p>\n
FUNCTION encrypt(str VARCHAR2, HASH VARCHAR2) — \uc554\ud638\ud654
\nRETURN VARCHAR2
\nIS
\np NUMBER := ((FLOOR(LENGTH(str)\/8+0.9))*8);
\nBEGIN
\nDBMS_OBFUSCATION_TOOLKIT.DESEncrypt(
\ninput_string => RPAD(str,p)
\n,key_string => RPAD(HASH,8,’#’)
\n,encrypted_string => s
\n);
\nRETURN s;
\nEND;
\nFUNCTION decrypt(str VARCHAR2, HASH VARCHAR2) — \ubcf5\ud638\ud654
\nRETURN VARCHAR2
\nIS
\nBEGIN
\nDBMS_OBFUSCATION_TOOLKIT.DESDecrypt(
\ninput_string => str
\n,key_string => RPAD(HASH,8,’#’)
\n,decrypted_string => s
\n);
\nRETURN TRIM(s);
\nEND;<\/p>\n
END CryptIT;
\nCREATE TABLE abc(id NUMBER, pass VARCHAR2(20));<\/p>\n
INSERT INTO abc (id, pass) VALUES (1, CryptIT.encrypt(‘12345′,’test’));
\nCOMMIT;<\/p>\n
SELECT id, pass FROM abc;<\/p>\n","protected":false},"excerpt":{"rendered":"
–\uc624\ub77c\ud074\uc758 \uc554\ud638\ud654\uc640 \ubcf5\ud638\ud654 –\uc624\ub77c\ud074\uc758 \uc554\ud638\ud654\ub294 DBMS_OBFUSCATION_TOOLKIT\ub97c \uc774\uc6a9 –\uc774 \ud328\ud0a4\uc9c0\uc5d0\ub294 4\uac1c\uc758 \ud504\ub85c\uc2dc\uc800\uac00 \uc788\ub2e4. –\ud504\ub85c\uc2dc\uc800\ub294 VARCHAR2 \ud0c0\uc785 \ubc0f RAW \ud0c0\uc785\uc744 \uc554\ud638\/\ubcf5\ud638\ud654 \uc9c0\uc6d0. \ub2e4\ub978 \ud0c0\uc785\uc740 \uc9c0\uc6d0\ub418\uc9c0 \uc54a\uc73c\ubbc0\ub85c NUMBER \ud0c0\uc785\uc740 TO_CHAR\ub97c \uc774\uc6a9\ud574\uc57c \ud55c\ub2e4. –DBMS_OBFUSCATION_TOOLKIT \ud328\ud0a4\uc9c0\ub294 \uae30\ubcf8\uc801\uc73c\ub85c\ub294 \uc0ac\uc6a9\ud560 \uc218 \uc5c6\ub294 \uc0c1\ud0dc\uc774\ub2e4. \uc124\uce58\uc2dc\uc5d0\ub294 \uc900\ube44 \ub418\uc9c0 \uc54a\uc740 \ud328\ud0a4\uc9c0\uc774\uae30 \ub54c\ubb38\uc774\ub2e4. \uc544\ub798 \ud30c\uc77c\uc744 \uc9c1\uc811 \uc2e4\ud589\ud574\uc57c \ud328\ud0a4\uc9c0\uac00 \uc0dd\uc131\ub418\uace0, \uc900\ube44\uac00 \ub41c\ub2e4. D:\\oracle\\product\\10.2.0\\db_1\\RDBMS\\ADMIN\\dbmsobtk.sql D:\\oracle\\product\\10.2.0\\db_1\\RDBMS\\ADMIN\\prvtobtk.plb –SQLPLUS\uc5d0\uc11c SYS\uacc4\uc815\uc73c\ub85c \ub85c\uadf8\uc778\ud55c […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-496","post","type-post","status-publish","format-standard","hentry","category-about-oracle"],"_links":{"self":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/496","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/comments?post=496"}],"version-history":[{"count":1,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/496\/revisions"}],"predecessor-version":[{"id":497,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/496\/revisions\/497"}],"wp:attachment":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/media?parent=496"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/categories?post=496"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/tags?post=496"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}