{"id":17036,"date":"2025-08-06T10:58:35","date_gmt":"2025-08-06T01:58:35","guid":{"rendered":"https:\/\/www.autooffice.co.kr\/?p=17036"},"modified":"2025-09-15T19:26:04","modified_gmt":"2025-09-15T10:26:04","slug":"apex-image-upload","status":"publish","type":"post","link":"https:\/\/www.autooffice.co.kr\/en\/blog\/2025\/08\/06\/apex-image-upload\/","title":{"rendered":"[Oracle APEX] \uc0ac\uc6a9\uc790 \uc774\ubbf8\uc9c0 \uc5c5\ub85c\ub4dc \ubc0f \uc0ad\uc81c\ud558\uae30"},"content":{"rendered":"\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-b62edfa4a6e9932c0eac39ff06e565db\">\uc774\ubc88 \ud3ec\uc2a4\ud2b8\uc5d0\uc11c\ub294 \uc0ac\uc6a9\uc790 \uad00\ub9ac \ud14c\uc774\ube14\uc5d0 \uc774\ubbf8\uc9c0\ub97c \uc5c5\ub85c\ub4dc\ud558\uace0 APEX \ud654\uba74\uc5d0\uc11c \uc774\ubbf8\uc9c0\ub97c \ud45c\uc2dc\ud558\ub294 \ubc29\ubc95\uc744 \uc18c\uac1c\ud569\ub2c8\ub2e4.<br><\/p>\n\n\n<div class=\"wp-block-aioseo-table-of-contents\"><ul><li><a class=\"aioseo-toc-item\" href=\"#aioseo-1-\ud14c\uc774\ube14\uc5d0-\uceec\ub7fc-\ucd94\uac00-\ubc0f-\ud398\uc774\uc9c0-\uc544\uc774\ud15c\uc73c\ub85c-\ub3d9\uae30\ud654\">1. \ud14c\uc774\ube14\uc5d0 \uceec\ub7fc \ucd94\uac00 \ubc0f \ud398\uc774\uc9c0 \uc544\uc774\ud15c\uc73c\ub85c \ub3d9\uae30\ud654<\/a><\/li><li><a class=\"aioseo-toc-item\" href=\"#aioseo-2-\uc774\ubbf8\uc9c0-\uc5c5\ub85c\ub4dc-\uc544\uc774\ud15c-\uc124\uc815\">2. \uc774\ubbf8\uc9c0 \uc5c5\ub85c\ub4dc \uc544\uc774\ud15c \uc124\uc815<\/a><ul><li><a class=\"aioseo-toc-item\" href=\"#aioseo-\uc774\ubbf8\uc9c0-\uc5c5\ub85c\ub4dc-\ub514\uc2a4\ud50c\ub808\uc774-5\uc885\ub958\">\uc774\ubbf8\uc9c0 \uc5c5\ub85c\ub4dc \ub514\uc2a4\ud50c\ub808\uc774 5\uc885\ub958<\/a><ul><li><a class=\"aioseo-toc-item\" href=\"#aioseo-1-inline-file-browse\">1. Inline File Browse<\/a><\/li><li><a class=\"aioseo-toc-item\" href=\"#aioseo-2-icon-dropzone\">2. Icon Dropzone<\/a><\/li><li><a class=\"aioseo-toc-item\" href=\"#aioseo-3-inline-dropzone\">3. Inline Dropzone<\/a><\/li><li><a class=\"aioseo-toc-item\" href=\"#aioseo-4-block-dropzone\">4. Block Dropzone<\/a><\/li><li><a class=\"aioseo-toc-item\" href=\"#aioseo-5-native-file-browse\">5. Native File Browse<\/a><\/li><\/ul><\/li><\/ul><\/li><li><a class=\"aioseo-toc-item\" href=\"#aioseo-3-\uc774\ubbf8\uc9c0-\ud45c\uc2dc-\uc544\uc774\ud15c-\uc124\uc815\">3. \uc774\ubbf8\uc9c0 \ud45c\uc2dc \uc544\uc774\ud15c \uc124\uc815<\/a><\/li><li><a class=\"aioseo-toc-item\" href=\"#aioseo-4-\uc774\ubbf8\uc9c0-\uc5c5\ub85c\ub4dc-\ud14c\uc2a4\ud2b8\">4. \uc774\ubbf8\uc9c0 \uc5c5\ub85c\ub4dc \ud14c\uc2a4\ud2b8<\/a><\/li><li><a class=\"aioseo-toc-item\" href=\"#aioseo-5-\uc774\ubbf8\uc9c0-\uc0ad\uc81c-\ubc84\ud2bc-\ub123\uae30\">5. \uc774\ubbf8\uc9c0 \uc0ad\uc81c \ubc84\ud2bc \ub123\uae30<\/a><\/li><li><a class=\"aioseo-toc-item\" href=\"#aioseo-\uc5c5\ubb34-\ud6a8\uc728\uc131-200-\uc62c\ub9ac\uae30-with-autooffice\">\uc5c5\ubb34 \ud6a8\uc728\uc131 200% \uc62c\ub9ac\uae30, with autooffice<\/a><\/li><li><a class=\"aioseo-toc-item\" href=\"#aioseo-\ub8e8\ucee4-\uc2a4\ud29c\ub514\uc624-\uac1c\ubc1c-\ubb38\uc758\ub294-\uad6c\uae00\ud3fc\uc744-\uc774\uc6a9\ud574\uc8fc\uc138\uc694\">APEX \uac1c\ubc1c \ubb38\uc758\ub294 \uad6c\uae00\ud3fc\uc744 \uc774\uc6a9\ud574\uc8fc\uc138\uc694!<\/a><\/li><\/ul><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"aioseo-1-\ud14c\uc774\ube14\uc5d0-\uceec\ub7fc-\ucd94\uac00-\ubc0f-\ud398\uc774\uc9c0-\uc544\uc774\ud15c\uc73c\ub85c-\ub3d9\uae30\ud654\"><br>1. \ud14c\uc774\ube14\uc5d0 \uceec\ub7fc \ucd94\uac00 \ubc0f \ud398\uc774\uc9c0 \uc544\uc774\ud15c\uc73c\ub85c \ub3d9\uae30\ud654<\/h2>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-9df570bef5b9d094f2461317f8185ab0\"><br>\uc55e\uc120 <a href=\"https:\/\/www.autooffice.co.kr\/blog\/2025\/07\/05\/apex-custom-login-1\/\" target=\"_blank\" rel=\"noopener\" title=\"\"><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-theme-palette-1-color\">\ud3ec\uc2a4\ud2b8<\/mark><\/a>\uc5d0\uc11c APEX_USERS \ub77c\ub294 \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud588\uc2b5\ub2c8\ub2e4. \uc774 \ud14c\uc774\ube14\uc5d0 \uc138 \uceec\ub7fc\uc744 \ucd94\uac00\ud569\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>IMG_BLOB BLOB;\nIMG_FILENAME VARCHAR2(100);\nIMG_MIMETYPE VARCHAR2(50);<\/code><\/pre>\n\n\n\n<p><br><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/oopy.lazyrockets.com\/api\/v2\/notion\/image?src=attachment%3A6ef3f3cb-46d5-40d5-8548-07b88763991a%3Aimage.png&amp;blockId=241b2d8a-486c-805f-ad33-c9264d9bbb55\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-1cb54c200f7431273c23283fb288bb57\"><br>\uc0ac\uc6a9\uc790 \uad00\ub9ac \ud3fc \ud398\uc774\uc9c0 (\ud398\uc774\uc9c0 11, P11)\uc5d0\uc11c Synchronize Page Items \ub97c \ud074\ub9ad\ud574\uc11c \ud14c\uc774\ube14\uc5d0 \uc0c8\ub85c \ucd94\uac00\ud55c \uc138 \uceec\ub7fc\uc744 \ubd88\ub7ec\uc635\ub2c8\ub2e4.<br><br><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/oopy.lazyrockets.com\/api\/v2\/notion\/image?src=attachment%3Acd6c06ab-16b2-41d5-b558-122af8892fd7%3Aimage.png&amp;blockId=241b2d8a-486c-80ec-9f94-cd7d1b76e851\" alt=\"\"\/><\/figure>\n<\/div>\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-9fc5872c0fb3f53399f254ff171ec41a\"><br>\uc138 \uceec\ub7fc\uc774 \ub3d9\uae30\ud654\ub418\ub294\ub370 IMG_FILENAME\uacfc IMG_MIMETYPE\uc740 \uc0ac\uc6a9\uc790\uc5d0\uac8c \ubcf4\uc5ec\uc904 \ud544\uc694\ub294 \uc5c6\uc73c\ub2c8 HIDDEN \ucc98\ub9ac\ud569\ub2c8\ub2e4.<br><br><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/oopy.lazyrockets.com\/api\/v2\/notion\/image?src=attachment%3Ab15d51b8-fd0c-47b4-af00-465e7e9f2ea2%3Aimage.png&amp;blockId=241b2d8a-486c-8073-abef-f83e34132a50\" alt=\"\"\/><\/figure>\n<\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"aioseo-2-\uc774\ubbf8\uc9c0-\uc5c5\ub85c\ub4dc-\uc544\uc774\ud15c-\uc124\uc815\"><br>2. \uc774\ubbf8\uc9c0 \uc5c5\ub85c\ub4dc \uc544\uc774\ud15c \uc124\uc815<\/h2>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-20b83ff88e88d9be10500a92eb9afce0\"><br>\uc774\ubbf8\uc9c0\ub97c \uc5c5\ub85c\ub4dc \ud558\uae30 \uc704\ud574 \ud398\uc774\uc9c0 \uc544\uc774\ud15c\uc744 \ud558\ub098 \ucd94\uac00\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-49b91fa317c00633751d1fe1fc4ed0b6\">IMG_BLOB \uc744 \ubcf5\uc81c\ud558\uba74 \ud3b8\ub9ac\ud569\ub2c8\ub2e4. \uc65c\ub0d0\ud558\uba74 \uc774\ubbf8\uc9c0 \uc5c5\ub85c\ub4dc\ub294 SOURCE \ub85c BLOB \uceec\ub7fc\uc774 \uc9c0\uc815\ub418\uc5b4\uc57c \ud558\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4. \ubcf5\uc81c\ud55c \uceec\ub7fc\uc758 \uc774\ub984\uc740 P11_IMAGE_UPLOAD \ub85c \uc124\uc815\ud558\uaca0\uc2b5\ub2c8\ub2e4. TYPE\uc740 Image Upload\ub85c \ud569\ub2c8\ub2e4.<br><br><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/oopy.lazyrockets.com\/api\/v2\/notion\/image?src=attachment%3A1fcc698b-b802-40d9-8f7e-5355380d5430%3Aimage.png&amp;blockId=241b2d8a-486c-805c-a942-e9aa767ea0aa\" alt=\"\"\/><\/figure>\n<\/div>\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-c5b4713a6e5bfdd9dd5e58de78027761\"><br>Display As \ub294 \uc774\ubbf8\uc9c0 \uc5c5\ub85c\ub4dc \ubd80\ubd84\uc758 \ubaa8\uc591\uc744 \uacb0\uc815\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-96752b7e5836192aa9802bc792e03fa9\">Storage\uc5d0\uc11c Type\uc740 BLOB cloumn specified in Item Source attribute\ub97c \uc120\ud0dd\ud558\uace0, MIME Type Column\uc5d0\ub294 IMG_MIMETYPE\uc744 Filename Column\uc5d0\ub294 IMG_FILENAME\uc744, BLOB Last Updated Column\uc5d0\ub294 UPDATED_AT \uc744 \uc9c0\uc815\ud569\ub2c8\ub2e4. \uc774 \uceec\ub7fc\ub4e4\uc740 APEX_USERS\uc5d0 \uc815\uc758\ub418\uc5b4 \uc788\ub294 \uceec\ub7fc\ub4e4\uc785\ub2c8\ub2e4.<br><br><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/oopy.lazyrockets.com\/api\/v2\/notion\/image?src=attachment%3A022df9bf-2fcd-485c-889d-58c3a7dd3418%3Aimage.png&amp;blockId=241b2d8a-486c-805f-ab45-fd32932b13b9\" alt=\"\"\/><\/figure>\n<\/div>\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-8adaa569136d518c09e591487e9441d1\"><br>\ucd94\uac00 \uc138\ud305\uc73c\ub85c \ud06c\ub86d\uc744 \ud5c8\uc6a9\ud560 \uc218\ub3c4 \uc788\uace0, \ub9ac\uc0ac\uc774\uc988\ub3c4 \uc81c\uacf5\ud569\ub2c8\ub2e4.<br><br><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/oopy.lazyrockets.com\/api\/v2\/notion\/image?src=attachment%3Ae9a9ef67-b665-4684-9388-cfdf836f514a%3Aimage.png&amp;blockId=241b2d8a-486c-80b3-912e-f9ad3831973b\" alt=\"\"\/><\/figure>\n<\/div>\n\n\n<h3 class=\"wp-block-heading\" id=\"aioseo-\uc774\ubbf8\uc9c0-\uc5c5\ub85c\ub4dc-\ub514\uc2a4\ud50c\ub808\uc774-5\uc885\ub958\"><img decoding=\"async\" src=\"blob:https:\/\/www.autooffice.co.kr\/d23c1567-0d13-4b98-ae2a-1e7bb1cffe8b\"> <br>\ud83d\udcc4\uc774\ubbf8\uc9c0 \uc5c5\ub85c\ub4dc \ub514\uc2a4\ud50c\ub808\uc774 5\uc885\ub958<\/h3>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-62fb0df08a5ed6557f5afcf409452899\"><br>Display As \uc5d0\uc11c \uc120\ud0dd\ud560 \uc218 \uc788\ub294 5 \uc885\ub958\uc758 \ud615\ud0dc\uac00 \uc788\uc2b5\ub2c8\ub2e4. \uc6d0\ud558\ub294 \uac83\uc744 \uc0ac\uc6a9\ud558\uba74 \ub429\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"aioseo-1-inline-file-browse\">1. Inline File Browse<\/h4>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/oopy.lazyrockets.com\/api\/v2\/notion\/image?src=attachment%3A43bd3160-d6ad-49c5-9049-b86237aba602%3Aimage.png&amp;blockId=241b2d8a-486c-8099-b3f3-c4159cf06da2\" alt=\"\"\/><\/figure>\n<\/div>\n\n\n<h4 class=\"wp-block-heading\" id=\"aioseo-2-icon-dropzone\"><br>2. Icon Dropzone<\/h4>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/oopy.lazyrockets.com\/api\/v2\/notion\/image?src=attachment%3A19ab1532-fa40-4119-9c89-08afae82deaa%3Aimage.png&amp;blockId=241b2d8a-486c-8075-b8e1-c479f4b4c2eb\" alt=\"\"\/><\/figure>\n<\/div>\n\n\n<h4 class=\"wp-block-heading\" id=\"aioseo-3-inline-dropzone\"><br>3. Inline Dropzone<\/h4>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/oopy.lazyrockets.com\/api\/v2\/notion\/image?src=attachment%3Afc0b015d-1dae-46bd-ab37-17fb2a694c41%3Aimage.png&amp;blockId=241b2d8a-486c-8093-8010-d0e2731ff682\" alt=\"\"\/><\/figure>\n<\/div>\n\n\n<h4 class=\"wp-block-heading\" id=\"aioseo-4-block-dropzone\"><br>4. Block Dropzone<\/h4>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/oopy.lazyrockets.com\/api\/v2\/notion\/image?src=attachment%3A6900471e-a815-41ab-ba17-de7d9b8a0cd6%3Aimage.png&amp;blockId=241b2d8a-486c-805e-a19a-c6b985120479\" alt=\"\"\/><\/figure>\n<\/div>\n\n\n<h4 class=\"wp-block-heading\" id=\"aioseo-5-native-file-browse\"><br>5. Native File Browse<\/h4>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/oopy.lazyrockets.com\/api\/v2\/notion\/image?src=attachment%3A8c1049ed-3109-47d5-b558-c16d45652a25%3Aimage.png&amp;blockId=241b2d8a-486c-80ba-b887-cc54638be389\" alt=\"\"\/><\/figure>\n<\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"aioseo-3-\uc774\ubbf8\uc9c0-\ud45c\uc2dc-\uc544\uc774\ud15c-\uc124\uc815\"><br>3. \uc774\ubbf8\uc9c0 \ud45c\uc2dc \uc544\uc774\ud15c \uc124\uc815<\/h2>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-42743dc9bc9115d975d5ef7e066e2e43\"><br>\uc774\ubbf8\uc9c0\ub97c \uc5c5\ub85c\ub4dc\ud558\uba74 \uadf8\uac83\uc744 \ud45c\uc2dc\ud560 \uc544\uc774\ud15c\uc744 \uc124\uc815\ud574\uc8fc\uc5b4\uc57c \ud569\ub2c8\ub2e4. P11_IMG_BLOB \uc544\uc774\ud15c\uc5d0 \uc124\uc815\ud558\uba74 \ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-7a8848c1822759535ec63e273eacc86a\">Type\uc744 Display Image \ub85c \uc124\uc815\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-ab82d4d442b3a1fb3d87723e201357a3\">Settings\uc5d0 Based On\uc740 BLOB Column specified in Item Source\ub97c \uc120\ud0dd\ud558\uace0, Filename, MIME Type, Last Updated\ub97c \uc124\uc815\ud569\ub2c8\ub2e4.<br><br><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/oopy.lazyrockets.com\/api\/v2\/notion\/image?src=attachment%3A831a7745-f520-4740-a386-a96b303f9965%3Aimage.png&amp;blockId=241b2d8a-486c-8018-867b-c89107d79d4b\" alt=\"\"\/><\/figure>\n<\/div>\n\n\n<p><br>\uadf8\ub9ac\uace0 \uc774\ubbf8\uc9c0\uac00 \uc5c6\uc744 \ub54c\ub294 \uc544\uc774\ud15c\uc744 \ud45c\uc2dc\ud558\uc9c0 \uc54a\ub3c4\ub85d Server-side Condition\uc744 \ub2e4\uc74c\uacfc \uac19\uc774 \uc124\uc815\ud574\uc90d\ub2c8\ub2e4.<\/p>\n\n\n\n<p>Expression &gt; SQL \ub85c \uc124\uc815\ud558\uace0 SQL Expression \uc744 \uc785\ub825\ud569\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<p><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>EXISTS (\n  SELECT 1\n    FROM APEX_USERS\n   WHERE USER_ID = :P11_USER_ID\n     AND IMG_BLOB IS NOT NULL\n)<\/code><\/pre>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-193d16c48338e55607a03afa1b886c97\"><br><\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>\ud83d\udca1\uc27d\uac8c \uc0dd\uac01\ud558\uba74 Item is NOT NULL \uc870\uac74\uc744 \uc120\ud0dd\ud558\uace0 IMG_BLOB\uc744 \uc120\ud0dd\ud558\uba74 \ub3d9\uc791\ud560 \uac83\uc73c\ub85c \uc0dd\uac01\ub418\uc9c0\ub9cc, \uc2e4\uc81c\ub85c\ub294 \uadf8\ub807\uac8c \ub3d9\uc791\uc744 \ud558\uc9c0 \uc54a\uae30 \ub54c\ubb38\uc5d0 SQL\ub85c \uc124\uc815\ud558\ub294 \uac83\uc785\ub2c8\ub2e4.<\/p>\n<\/blockquote>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"aioseo-4-\uc774\ubbf8\uc9c0-\uc5c5\ub85c\ub4dc-\ud14c\uc2a4\ud2b8\"><br>4. \uc774\ubbf8\uc9c0 \uc5c5\ub85c\ub4dc \ud14c\uc2a4\ud2b8<\/h2>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-d67d367a0ebf9ca23f89d3bb70060412\"><br>\uc774\uc81c \uc0ac\uc6a9\uc790 \uad00\ub9ac \ud3fc\uc73c\ub85c \ub4e4\uc5b4\uac00\uc11c \uc774\ubbf8\uc9c0 \uc5c5\ub85c\ub4dc\ub97c \ud14c\uc2a4\ud2b8 \ud574\ubd05\uc2dc\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/oopy.lazyrockets.com\/api\/v2\/notion\/image?src=attachment%3Aef61e571-35c7-4aa3-9f7b-4412f2ac5233%3Aimage.png&amp;blockId=241b2d8a-486c-8006-bf60-c3363d47e52f\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-83711d532527dfd2a5bc7acf91244a8f\"><br>\uc774\ubbf8\uc9c0\ub97c \uc120\ud0dd\ud558\uba74, \ud06c\ub86d \uc635\uc158\uc774 \ud45c\uc2dc\ub429\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/oopy.lazyrockets.com\/api\/v2\/notion\/image?src=attachment%3Afb45bef1-1c68-4433-bf5c-8c110b126223%3Aimage.png&amp;blockId=241b2d8a-486c-8075-9e69-e77d6b10d1b8\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-61ef7975f07c08abbd5ff81e71522c66\"><br>\ud06c\ub86d\uc744 \uc801\uc6a9\ud558\uba74 \ub2e4\uc74c\uacfc \uac19\uc774 \uc774\ubbf8\uc9c0 \uc5c5\ub85c\ub4dc \uc139\uc158\uc5d0 \uc5c5\ub85c\ub4dc\ud560 \uc774\ubbf8\uc9c0\uac00 \uc791\uac8c \ud45c\uc2dc \ub429\ub2c8\ub2e4. \ud558\uc9c0\ub9cc \uc774\uac78\ub85c \ub05d\uc774 \uc544\ub2d9\ub2c8\ub2e4. \uc5ec\uae30\uc11c \ucde8\uc18c\ub97c \ud558\uace0 \ucc3d\uc744 \ub2eb\uc73c\uba74 \uc774\ubbf8\uc9c0\ub294 \uc5c5\ub85c\ub4dc \ub418\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. Apply Changes \ub97c \ub20c\ub7ec\uc11c \uc5c5\ub85c\ub4dc\ub97c \uc9c4\ud589\ud574\uc57c \ud569\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/oopy.lazyrockets.com\/api\/v2\/notion\/image?src=attachment%3Afa929deb-b9a7-4958-b776-b4e4c6396e79%3Aimage.png&amp;blockId=241b2d8a-486c-804c-b499-f7a893efe910\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-278fc8f73203bc4573f699c5067d1f25\"><br>\uadf8\ub7ec\uba74 \uc774\uc81c \uc5c5\ub85c\ub4dc\ud55c \uc774\ubbf8\uc9c0\uac00 \ud45c\uc2dc\ub429\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/oopy.lazyrockets.com\/api\/v2\/notion\/image?src=attachment%3A271a8432-524c-4701-a7e1-eb2237b5a14e%3Aimage.png&amp;blockId=241b2d8a-486c-806f-b906-e5dadbac5557\" alt=\"\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"aioseo-5-\uc774\ubbf8\uc9c0-\uc0ad\uc81c-\ubc84\ud2bc-\ub123\uae30\"><br>5. \uc774\ubbf8\uc9c0 \uc0ad\uc81c \ubc84\ud2bc \ub123\uae30<\/h2>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-8de16f25773257fbadeb5919304c5584\"><br>\uc774\ubbf8\uc9c0 \uc5c5\ub85c\ub4dc\ub97c \ub2e4\uc2dc \ud558\uba74 \ub2e4\ub978 \uc774\ubbf8\uc9c0\ub85c \uad50\uccb4\uac00 \ub429\ub2c8\ub2e4. \ud558\uc9c0\ub9cc \uc774\ubbf8\uc9c0\ub97c \uc0ad\uc81c\ud558\ub824\uba74 \uc5b4\ub5bb\uac8c \ud574\uc57c\ud560\uae4c\uc694? \ubcc4\ub3c4\ub85c \ubc84\ud2bc\uc744 \ucd94\uac00\ud558\uace0 Dynamic Action\uc73c\ub85c \ucc98\ub9ac\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-72c21c30894e6d56ba882b4c6eb4955f\">\ub2e4\uc74c\uacfc \uac19\uc774 \ubc84\ud2bc\uc744 \ucd94\uac00\ud558\uaca0\uc2b5\ub2c8\ub2e4. \ubc84\ud2bc\uc744 \ud074\ub9ad\ud588\uc744 \ub54c, Execute Server-side Code\ub97c \uc2e4\ud589\ud558\ub3c4\ub85d \ud574\uc90d\ub2c8\ub2e4. \uc55e\uc5d0 Confirm\uc774 \uc788\uc73c\uba74 \uc720\uc6a9\ud558\uaca0\uc9c0\uc694. \ub4a4\uc5d0 Submit Page\ub97c \ud574\uc11c \uc774\ubbf8\uc9c0\ub97c \uc9c0\uc6cc\uc900 \ub2e4\uc74c \ucc3d\uc744 \uc0c8\ub85c\uace0\uce68\ud569\ub2c8\ub2e4.<br><br><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/oopy.lazyrockets.com\/api\/v2\/notion\/image?src=attachment%3Ad5c1621e-2646-4362-8a2d-2461275ebfec%3Aimage.png&amp;blockId=241b2d8a-486c-806d-9427-d01f409daf0a\" alt=\"\"\/><\/figure>\n<\/div>\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-dd86e10acf5ff20dc4ba1eb979bd3e10\"><br>Server-side Code\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>UPDATE APEX_USERS \n    SET IMG_BLOB = NULL, \n        IMG_MIMETYPE = NULL, \n        IMG_FILENAME = NULL \nWHERE USER_ID = :P11_USER_ID;<\/code><\/pre>\n\n\n\n<p><br><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/oopy.lazyrockets.com\/api\/v2\/notion\/image?src=attachment%3A05ff8e77-1307-48f1-a028-983ea5b8e393%3Aimage.png&amp;blockId=241b2d8a-486c-8029-9c50-cca8f29ed41a\" alt=\"\"\/><\/figure>\n<\/div>\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-a8ffb6b3c46c229da3af3192d134346f\"><br>\uc774\uc81c \ud654\uba74\uc5d0\uc11c \uad6c\ud604\ub41c \uac83\uc744 \ud655\uc778\ud574\ubcfc\uae4c\uc694?<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/oopy.lazyrockets.com\/api\/v2\/notion\/image?src=attachment%3Af7e05fe1-7599-4199-818c-ce914b43486b%3Aimage.png&amp;blockId=241b2d8a-486c-80b9-8ab2-de26baea32b3\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-0e898ea20f0fce0c29befd3d38f105c3\"><br>\uc774\ubbf8\uc9c0 \uc0ad\uc81c \ubc84\ud2bc\uc744 \ud074\ub9ad\ud558\uba74, Confirm \uba54\uc2dc\uc9c0 \ud6c4\uc5d0 \uc774\ubbf8\uc9c0\uac00 \uc0ad\uc81c\ub418\uace0, \uc774\ubbf8\uc9c0\uac00 \uc5c6\ub294 \ud654\uba74\uc744 \ud45c\uc2dc\ud558\uac8c \ub429\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/oopy.lazyrockets.com\/api\/v2\/notion\/image?src=attachment%3Aa2e9ec8c-0a39-43f4-a0de-7adbbb971ce7%3Aimage.png&amp;blockId=241b2d8a-486c-8088-8634-c209b1f343d8\" alt=\"\"\/><\/figure>\n\n\n\n<p><br><\/p>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-203d53e69daad3b3ca15273824e9061b\">\uc774\ubc88 \ud3ec\uc2a4\ud2b8\ub294 \uc5ec\uae30\uae4c\uc9c0 \uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p><br><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide\"\/>\n\n\n\n<p><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"691\" height=\"512\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/08\/image-27.png\" alt=\"\" class=\"wp-image-17075\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/08\/image-27.png 691w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/08\/image-27-300x222.png 300w\" sizes=\"auto, (max-width: 691px) 100vw, 691px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"aioseo-\uc5c5\ubb34-\ud6a8\uc728\uc131-200-\uc62c\ub9ac\uae30-with-autooffice\">\uc5c5\ubb34 \ud6a8\uc728\uc131 200% \uc62c\ub9ac\uae30, with autooffice<\/h2>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"aioseo-\ub8e8\ucee4-\uc2a4\ud29c\ub514\uc624-\uac1c\ubc1c-\ubb38\uc758\ub294-\uad6c\uae00\ud3fc\uc744-\uc774\uc6a9\ud574\uc8fc\uc138\uc694\">APEX \uac1c\ubc1c \ubb38\uc758\ub294 \uad6c\uae00\ud3fc\uc744 \uc774\uc6a9\ud574\uc8fc\uc138\uc694!<\/h2>\n\n\n\n<p><\/p>\n\n\n\n<p><a href=\"https:\/\/docs.google.com\/forms\/d\/e\/1FAIpQLSc-FiMM9foF0jEAWqL7IePJTEdQ0X9asQTENOIv_3mltyq2zg\/viewform?pli=1\" target=\"_blank\" rel=\"noopener\" title=\"\">\uc624\ud1a0\uc624\ud53c\uc2a4 \ud504\ub85c\uc81d\ud2b8 \ubb38\uc758<\/a><\/p>\n\n\n\n<p><br><\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uc774\ubc88 \ud3ec\uc2a4\ud2b8\uc5d0\uc11c\ub294 \uc0ac\uc6a9\uc790 \uad00\ub9ac \ud14c\uc774\ube14\uc5d0 \uc774\ubbf8\uc9c0\ub97c \uc5c5\ub85c\ub4dc\ud558\uace0 APEX \ud654\uba74\uc5d0\uc11c \uc774\ubbf8\uc9c0\ub97c \ud45c\uc2dc\ud558\ub294 \ubc29\ubc95\uc744 \uc18c\uac1c\ud569\ub2c8\ub2e4. 1. \ud14c\uc774\ube14\uc5d0 \uceec\ub7fc \ucd94\uac00 \ubc0f \ud398\uc774\uc9c0 \uc544\uc774\ud15c\uc73c\ub85c \ub3d9\uae30\ud654 \uc55e\uc120 \ud3ec\uc2a4\ud2b8\uc5d0\uc11c APEX_USERS \ub77c\ub294 \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud588\uc2b5\ub2c8\ub2e4. \uc774 \ud14c\uc774\ube14\uc5d0 \uc138 \uceec\ub7fc\uc744 \ucd94\uac00\ud569\ub2c8\ub2e4. \uc0ac\uc6a9\uc790 \uad00\ub9ac \ud3fc \ud398\uc774\uc9c0 (\ud398\uc774\uc9c0 11, P11)\uc5d0\uc11c Synchronize Page Items \ub97c \ud074\ub9ad\ud574\uc11c \ud14c\uc774\ube14\uc5d0 \uc0c8\ub85c \ucd94\uac00\ud55c \uc138 \uceec\ub7fc\uc744 \ubd88\ub7ec\uc635\ub2c8\ub2e4. \uc138 \uceec\ub7fc\uc774 \ub3d9\uae30\ud654\ub418\ub294\ub370 IMG_FILENAME\uacfc IMG_MIMETYPE\uc740&#8230;<\/p>\n","protected":false},"author":6,"featured_media":17037,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"categories":[580],"tags":[582,586,581],"class_list":["post-17036","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-apex","tag-apex","tag-oracle","tag-oracle-apex"],"translation":{"provider":"WPGlobus","version":"3.0.2","language":"en","enabled_languages":["ko","en"],"languages":{"ko":{"title":true,"content":true,"excerpt":false},"en":{"title":false,"content":false,"excerpt":false}}},"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/17036","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/comments?post=17036"}],"version-history":[{"count":5,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/17036\/revisions"}],"predecessor-version":[{"id":17274,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/17036\/revisions\/17274"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media\/17037"}],"wp:attachment":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media?parent=17036"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/categories?post=17036"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/tags?post=17036"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}