{"id":17030,"date":"2025-08-06T10:34:04","date_gmt":"2025-08-06T01:34:04","guid":{"rendered":"https:\/\/www.autooffice.co.kr\/?p=17030"},"modified":"2025-09-15T19:25:34","modified_gmt":"2025-09-15T10:25:34","slug":"apex-excel-upload","status":"publish","type":"post","link":"https:\/\/www.autooffice.co.kr\/en\/blog\/2025\/08\/06\/apex-excel-upload\/","title":{"rendered":"[Oracle APEX] \uc5d1\uc140 \ud30c\uc77c \uc5c5\ub85c\ub4dc\ud558\uace0, \ub0b4\uc6a9 \uc870\ud68c\ud558\uae30"},"content":{"rendered":"\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color\">APEX\ub97c \uac1c\ubc1c\ud574\uc11c \uc0ac\uc6a9\ud558\ub2e4\ubcf4\uba74 <strong><mark style=\"background-color:#ffe5fd\" class=\"has-inline-color\">\uc678\ubd80\uc5d0\uc11c \uc0dd\uc131\ud55c \uc5d1\uc140 \ud30c\uc77c\uc744 \uc5c5\ub85c\ub4dc\ud574\uc57c \ud558\ub294 \uacbd\uc6b0\uac00 \ubc1c\uc0dd\ud569\ub2c8\ub2e4. <\/mark><\/strong><\/p>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-f79e2fb013320bc429f4db77777311f2\">\ubcf4\ud1b5 \uc5c5\ubb34 \ud504\ub85c\uc138\uc2a4\uac00 \ub2e8 \ud558\ub098\uc758 \uc2dc\uc2a4\ud15c\ub9cc\uc73c\ub85c \uc774\ub8e8\uc5b4\uc9c0\uc9c0 \uc54a\uae30 \ub54c\ubb38\uc774\uc8e0.<\/p>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-a6c290c92f368d1968a5123444283a71\">\ub354\uc874\uacfc \uac19\uc740 \ud68c\uacc4 \ud504\ub85c\uadf8\ub7a8\uc744 \uc0ac\uc6a9\ud558\uba74\uc11c \ub370\uc774\ud130\ub97c \uc5f0\ub3d9\ud574\uc57c \ud560 \uc218\ub3c4 \uc788\uace0, <strong>\uc0ac\ubc29\ub137\uacfc \uac19\uc740 \ucee4\uba38\uc2a4 \ud504\ub85c\uadf8\ub7a8<\/strong>\uc5d0\uc11c \ub370\uc774\ud130\ub97c \ub0b4\ub824\ubc1b\uc544\uc11c \ud65c\uc6a9\ud574\uc57c \ud558\ub294 \uacbd\uc6b0\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-1d792022ff65ee2df65b1ae6520d1222\">\uadf8\ub7f4 \ub54c, \uc5d1\uc140\uc758 \ub0b4\uc6a9\uc744 \ubcf5\ubd99\ud560 \uc218 \uc788\ub2e4\uba74 \ud3b8\ud558\uaca0\uc9c0\ub9cc, APEX\uc5d0\uc11c\ub294 \uadf8\ub807\uac8c\uae4c\uc9c0\ub294 \uc9c0\uc6d0\ud558\uc9c0 \uc54a\uace0 \uc788\uc2b5\ub2c8\ub2e4.<br><\/p>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-e04399c1cbf5cf9811c48499be8df267\"><mark style=\"background-color:#fffec9\" class=\"has-inline-color\"><strong>\uc774 \ud3ec\uc2a4\ud2b8\uc5d0\uc11c\ub294 \uc5d1\uc140 \ud30c\uc77c\uc744 \uc5c5\ub85c\ub4dc\ud558\uace0, \uc5c5\ub85c\ub4dc\ud55c \ub0b4\uc6a9\uc744 \uc870\ud68c\ud558\ub294 \ubc29\ubc95\uae4c\uc9c0\ub97c \ub2e4\ub8f9\ub2c8\ub2e4.<\/strong><\/mark><\/p>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-d743cf383be882741ab45e66ab98208d\">\ud504\ub85c\uc2dc\uc800\ub97c \uc751\uc6a9\ud558\uba74 \uc5d1\uc140 \ud30c\uc77c\uc744 \uc5c5\ub85c\ub4dc\ud55c \ub2e4\uc74c \ud30c\uc2f1\ud574\uc11c \uc6d0\ud558\ub294 \uceec\ub7fc\ub9cc \ud2b9\uc815\ud55c \ud14c\uc774\ube14\uc5d0 INSERT \ud558\ub294 \uac83\ub3c4 \uac00\ub2a5\ud55c\ub370\uc694, \uba3c\uc800 \uae30\ucd08\ub97c \uc0b4\ud3b4\ubcf4\uc2dc\uaca0\uc2b5\ub2c8\ub2e4.<br><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-\uc0dd\uc131\">1. \ud14c\uc774\ube14 \uc0dd\uc131<\/a><ul><li><a class=\"aioseo-toc-item\" href=\"#aioseo-\uc5d1\uc140-\ud30c\uc77c\uc744-\uc5c5\ub85c\ub4dc\ud558\ub294-\ud14c\uc774\ube14-excel_file\">\uc5d1\uc140 \ud30c\uc77c\uc744 \uc5c5\ub85c\ub4dc\ud558\ub294 \ud14c\uc774\ube14 (EXCEL_FILE)<\/a><\/li><li><a class=\"aioseo-toc-item\" href=\"#aioseo-\uc5d1\uc140-\ud30c\uc77c-\ub0b4\uc6a9\uc744-\ub2f4\ub294-\ud14c\uc774\ube14-excel_upload\">\uc5d1\uc140 \ud30c\uc77c \ub0b4\uc6a9\uc744 \ub2f4\ub294 \ud14c\uc774\ube14 (EXCEL_UPLOAD)<\/a><\/li><\/ul><\/li><li><a class=\"aioseo-toc-item\" href=\"#aioseo-2-\ud398\uc774\uc9c0-\uc0dd\uc131\">2. \ud398\uc774\uc9c0 \uc0dd\uc131<\/a><ul><li><a class=\"aioseo-toc-item\" href=\"#aioseo-\uc5d1\uc140-\ud30c\uc77c-\ubaa9\ub85d-\ud398\uc774\uc9c0\">\uc5d1\uc140 \ud30c\uc77c \ubaa9\ub85d \ud398\uc774\uc9c0<\/a><\/li><li><a class=\"aioseo-toc-item\" href=\"#aioseo-\uc5d1\uc140-\ud30c\uc77c-\uc5c5\ub85c\ub4dc-\ud3fc\">\uc5d1\uc140 \ud30c\uc77c \uc5c5\ub85c\ub4dc \ud3fc<\/a><\/li><li><a class=\"aioseo-toc-item\" href=\"#aioseo-\uc5d1\uc140-\ud30c\uc77c-\ub0b4\uc6a9-\ud398\uc774\uc9c0\">\uc5d1\uc140 \ud30c\uc77c \ub0b4\uc6a9 \ud398\uc774\uc9c0<\/a><\/li><\/ul><\/li><li><a class=\"aioseo-toc-item\" href=\"#aioseo-3-\ud328\ud0a4\uc9c0-\uc0dd\uc131\">3. \ud328\ud0a4\uc9c0 \uc0dd\uc131<\/a><\/li><li><a class=\"aioseo-toc-item\" href=\"#aioseo-4-\ud398\uc774\uc9c0-\ub9c1\ud06c-\uc5f0\uacb0\">4. \ud398\uc774\uc9c0 \ub9c1\ud06c \uc5f0\uacb0<\/a><ul><li><a class=\"aioseo-toc-item\" href=\"#aioseo-\uc5d1\uc140-\ud30c\uc77c-\ubaa9\ub85d-\ud398\uc774\uc9c0-\uc5d1\uc140-\ud30c\uc77c-\ub0b4\uc6a9-\ud398\uc774\uc9c0\">\uc5d1\uc140 \ud30c\uc77c \ubaa9\ub85d \ud398\uc774\uc9c0 &#8211; \uc5d1\uc140 \ud30c\uc77c \ub0b4\uc6a9 \ud398\uc774\uc9c0<\/a><\/li><li><a class=\"aioseo-toc-item\" href=\"#aioseo-\uc5d1\uc140-\ud30c\uc77c-\ubaa9\ub85d-\ud398\uc774\uc9c0-\uc5d1\uc140-\ud30c\uc77c-\ud3fc\">\uc5d1\uc140 \ud30c\uc77c \ubaa9\ub85d \ud398\uc774\uc9c0 &#8211; \uc5d1\uc140 \ud30c\uc77c \ud3fc<\/a><\/li><\/ul><\/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 has-text-color has-link-color wp-elements-e84154d80ee3dc29bed7f0b64e11bdf8\" id=\"aioseo-1-\ud14c\uc774\ube14-\uc0dd\uc131\" style=\"color:#000000\"><br>1. \ud14c\uc774\ube14 \uc0dd\uc131<\/h2>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-fad6fb20aaddf1d78366d635efd1bda6\"><br>\uc6b0\uc120 \uc5d1\uc140 \ud30c\uc77c\uc744 \uc5c5\ub85c\ub4dc\ud558\ub294 \ud14c\uc774\ube14\uacfc \uc5d1\uc140 \ud30c\uc77c\uc758 \ub0b4\uc6a9\uc744 \ub2f4\uc744 \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud569\ub2c8\ub2e4.<br><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"aioseo-\uc5d1\uc140-\ud30c\uc77c\uc744-\uc5c5\ub85c\ub4dc\ud558\ub294-\ud14c\uc774\ube14-excel_file\">\uc5d1\uc140 \ud30c\uc77c\uc744 \uc5c5\ub85c\ub4dc\ud558\ub294 \ud14c\uc774\ube14 (EXCEL_FILE)<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE TABLE EXCEL_FILE (\n  SEQNO               NUMBER GENERATED BY DEFAULT ON NULL AS IDENTITY PRIMARY KEY,\n  FILE_NAME           VARCHAR2(255) NOT NULL,           \n  MIME_TYPE           VARCHAR2(100),                    \n  CHARACTER_SET       VARCHAR2(50),                     \n  FILE_CONTENT        BLOB,                             \n  UPLOADED_AT         TIMESTAMP DEFAULT CURRENT_TIMESTAMP,  \n  UPLOADED_BY         VARCHAR2(100)                     \n);<\/code><\/pre>\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-bd1462b566447b27332d0da7d406ea89\">\uc5d1\uc140 \ud30c\uc77c\uc744 BLOB\uc758 \ud615\ud0dc\ub85c \uc5c5\ub85c\ub4dc\ud574\uc11c \uad00\ub9ac\ud558\ub294 \ud14c\uc774\ube14\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-6269d99682ad9117a5093eb9c4721f28\">FILE_NAME, MIME_TYPE, CHARACTER_SET, FILE_CONTENT \uceec\ub7fc\uc774 \ud544\uc218\uc785\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"aioseo-\uc5d1\uc140-\ud30c\uc77c-\ub0b4\uc6a9\uc744-\ub2f4\ub294-\ud14c\uc774\ube14-excel_upload\">\uc5d1\uc140 \ud30c\uc77c \ub0b4\uc6a9\uc744 \ub2f4\ub294 \ud14c\uc774\ube14 (EXCEL_UPLOAD)<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE TABLE EXCEL_UPLOAD (\n  SEQNO               NUMBER GENERATED BY DEFAULT ON NULL AS IDENTITY PRIMARY KEY,\n  EXCEL_SEQNO         NUMBER, \n  COL1                VARCHAR2(4000),           \n  COL2                VARCHAR2(4000),           \n  COL3                VARCHAR2(4000),           \n  COL4                VARCHAR2(4000),           \n  COL5                VARCHAR2(4000),           \n  COL6                VARCHAR2(4000),           \n  COL7                VARCHAR2(4000),           \n  COL8                VARCHAR2(4000),           \n  COL9                VARCHAR2(4000),           \n  COL10               VARCHAR2(4000),           \n  COL11               VARCHAR2(4000),           \n  COL12               VARCHAR2(4000),           \n  COL13               VARCHAR2(4000),           \n  COL14               VARCHAR2(4000),           \n  COL15               VARCHAR2(4000),           \n  COL16               VARCHAR2(4000),           \n  COL17               VARCHAR2(4000),           \n  COL18               VARCHAR2(4000),           \n  COL19               VARCHAR2(4000),           \n  COL20               VARCHAR2(4000),           \n  CREATED_AT          TIMESTAMP DEFAULT CURRENT_TIMESTAMP,  \n  CREATED_BY          VARCHAR2(100),                     \n  UPDATED_AT          TIMESTAMP,  \n  UPDATED_BY          VARCHAR2(100),\n  \n  CONSTRAINT EXCEL_UPLOAD_FK\n    FOREIGN KEY (EXCEL_SEQNO)\n    REFERENCES EXCEL_FILE(SEQNO)\n    ON DELETE CASCADE         \n);<\/code><\/pre>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-469a73914e433f5ae7221206876d54d3\"><br>\uc5d1\uc140 \ud30c\uc77c\uc758 \uceec\ub7fc\uc218\uac00 20\uac1c\uae4c\uc9c0\ub77c\uace0 \uac00\uc815\ud558\uace0 \ub9cc\ub4dc\ub294 \ud14c\uc774\ube14\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-013413ee6fa914ae2b50a1679d2da358\">\ub354 \ub9ce\uc740 \uceec\ub7fc\uc774 \ud544\uc694\ud55c \uacbd\uc6b0, \uc0c1\ud669\uc5d0 \ub9de\uac8c \ub298\ub824\uc904 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-010313efcb7eef2617cd122b8ca7b84b\">\uc5d1\uc140 \ud30c\uc77c \ud14c\uc774\ube14\uc758 PK\ub97c \uc774 \ud14c\uc774\ube14\uc5d0\uc11c FK\ub85c \uc124\uc815\ud569\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"aioseo-2-\ud398\uc774\uc9c0-\uc0dd\uc131\">2. \ud398\uc774\uc9c0 \uc0dd\uc131<\/h2>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-1fd791bcf37d8a9b37c93889f813bacd\"><br>\ud398\uc774\uc9c0\ub294 3\uac1c\ub97c \uc0dd\uc131\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-45a95aca2e73e6615c5de39923102384\">\uc5c5\ub85c\ub4dc\ub41c \uc5d1\uc140 \ud30c\uc77c \ubaa9\ub85d\uc744 \ubcf4\ub294 \ud398\uc774\uc9c0<br>\uc5d1\uc140 \ud30c\uc77c\uc744 \uc5c5\ub85c\ub4dc\ud558\ub294 \ud3fc \ud398\uc774\uc9c0<br>\uc5d1\uc140 \ud30c\uc77c \ub0b4\uc6a9\uc744 \uc870\ud68c\ud558\ub294 \ud398\uc774\uc9c0<br><br><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"aioseo-\uc5d1\uc140-\ud30c\uc77c-\ubaa9\ub85d-\ud398\uc774\uc9c0\">\uc5d1\uc140 \ud30c\uc77c \ubaa9\ub85d \ud398\uc774\uc9c0<\/h3>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/oopy.lazyrockets.com\/api\/v2\/notion\/image?src=attachment%3A70c58c1f-8254-4113-acd3-73cc68cc75ad%3A%E1%84%89%E1%85%B3%E1%84%8F%E1%85%B3%E1%84%85%E1%85%B5%E1%86%AB%E1%84%89%E1%85%A3%E1%86%BA_2025-07-19_%E1%84%8B%E1%85%A9%E1%84%92%E1%85%AE_8.04.17.png&amp;blockId=235b2d8a-486c-80b3-ae28-ee48620ac21b\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-fa68127b0fead4a1a975d8775da68147\"><br>\uc5d1\uc140 \ud30c\uc77c\uc744 \uc5c5\ub85c\ub4dc\ud558\ub294 \ubc84\ud2bc\uc774 \uc788\uace0, EXCEL_FILE \ud14c\uc774\ube14\uc758 \ub370\uc774\ud130\ub97c \ubcf4\uc5ec\uc8fc\ub294 \ud14c\uc774\ube14\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-c7e8ed4777d2c58eaf75a911c472a46c\">\ud398\uc774\uc9c0\ub294 REGION TYPE \uc744 INTERACTIVE GRID \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-984aeace9f7257688495eca2e9908e55\">\ubc84\ud2bc\uc744 \ud558\ub098 \ucd94\uac00\ud558\uace0 \uc5d1\uc140 \ud30c\uc77c \uc5c5\ub85c\ub4dc\ub77c\uace0 \ub77c\ubca8\uc744 \uc785\ub825\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-0bc3ff839b7d1725696526944459a00d\">\ubc84\ud2bc\uc740 \uc5d1\uc140 \ud30c\uc77c \uc5c5\ub85c\ub4dc \ud3fc\uc73c\ub85c \uc774\ub3d9\ud558\ub3c4\ub85d \uc124\uc815\ud569\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"aioseo-\uc5d1\uc140-\ud30c\uc77c-\uc5c5\ub85c\ub4dc-\ud3fc\">\uc5d1\uc140 \ud30c\uc77c \uc5c5\ub85c\ub4dc \ud3fc<\/h3>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/oopy.lazyrockets.com\/api\/v2\/notion\/image?src=attachment%3A83e33d96-9ffc-4688-a025-0838afd4c50b%3Aimage.png&amp;blockId=235b2d8a-486c-804b-ad43-d1b3e0d83ec5\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-ec308762901a5649391886c163ddd8cf\"><br>EXCEL_FILE \ud14c\uc774\ube14\ub85c \ud3fc\uc744 \ub9cc\ub4ed\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-456d6761163d1f4e7551ca36ba8b4114\">FILE_CONTENT\ub97c TYPE\uc744 File Upload \ub85c \uc124\uc815\ud569\ub2c8\ub2e4. \uadf8\ub7ec\uba74 \uc544\uc774\ud150\uc5d0 Storage\ub77c\uace0 \uceec\ub7fc\uc744 \uc9c0\uc815\ud560 \uc218 \uc788\ub3c4\ub85d \ud45c\uc2dc\ub429\ub2c8\ub2e4. \uc5ec\uae30\uc5d0 EXCEL_FILE\uc758 \uceec\ub7fc\uc744 \uc785\ub825\ud574\uc90d\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%3A7871ec66-4fb0-44eb-831d-17583cf8e4ed%3Aimage.png&amp;blockId=235b2d8a-486c-8091-8082-f8f5382b33f0\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-ab28cc67e7a2fe411a765cd69d60e0c5\"><br>MIME Type Column: MIME_TYPE<br>Filename Column: FILE_NAME<br>Character Set Column: CHARACTER_SET<br>BLOB Last Updated Column: UPLOADED_AT<\/p>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-a3ba558a9d58117a7bfc4031b0ddeefa\">File Types: .xls, .xlsx \u21d2 \ub450 \uc885\ub958\uc758 \uc5d1\uc140 \ud30c\uc77c\ub9cc \uc5c5\ub85c\ub4dc\ud558\ub3c4\ub85d \uc81c\ud55c\ud569\ub2c8\ub2e4.<br>Maximum File Size \u21d2 \ud30c\uc77c \uc0ac\uc774\uc988\ub97c \uc81c\ud55c\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-2bcd73191bbcdb9289e924f1db64898d\">CHARACTER_SET \ub294 \ud30c\uc77c\uc744 \ubd84\uc11d\ud574\uc11c \uac00\uc838\uc62c \uc218\uac00 \uc5c6\uc2b5\ub2c8\ub2e4. Popup LOV\ub85c \uc120\ud0dd\ud560 \uc218 \uc788\ub3c4\ub85d \ub9cc\ub4e4\uc5b4\uc90d\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%3Ab29b9310-10c4-4e19-a155-dcca84229bd4%3Aimage.png&amp;blockId=235b2d8a-486c-8091-a497-f37a102ec14f\" alt=\"\"\/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"aioseo-\uc5d1\uc140-\ud30c\uc77c-\ub0b4\uc6a9-\ud398\uc774\uc9c0\"><br>\uc5d1\uc140 \ud30c\uc77c \ub0b4\uc6a9 \ud398\uc774\uc9c0<\/h3>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/oopy.lazyrockets.com\/api\/v2\/notion\/image?src=attachment%3A17a1d9a2-a1f5-4ca5-963d-754e13242dfe%3Aimage.png&amp;blockId=235b2d8a-486c-8083-86d5-f3666dea386b\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-a702213dbeec58acff79afb68cb716aa\"><br>\uc5d1\uc140 \ud30c\uc77c\uc758 \ub0b4\uc6a9\uc744 \uc870\ud68c\ud558\ub294 \ud398\uc774\uc9c0\uc785\ub2c8\ub2e4. EXCEL_SEQNO\ub97c \ubc1b\uc544\uc11c EXCEL_UPLOAD \ud14c\uc774\ube14\uc5d0\uc11c \ud544\ud130\ub9c1\ud55c \uacb0\uacfc\ub97c \ubcf4\uc5ec\uc90d\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-f390eeb18b964f02dcffc94ffcd6b354\">\uc5d1\uc140 \ud30c\uc77c \ubaa9\ub85d \ud398\uc774\uc9c0\uc5d0\uc11c EXCEL_SEQNO\ub97c \ubc1b\uc744 \uc218 \uc788\ub3c4\ub85d \ud398\uc774\uc9c0 \uc544\uc774\ud15c\uc744 \ucd94\uac00\ud574\uc90d\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%3Aecec5471-e8ca-4dd2-b414-769c324a15aa%3Aimage.png&amp;blockId=235b2d8a-486c-8096-8451-d087086ed6ec\" alt=\"\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"aioseo-3-\ud328\ud0a4\uc9c0-\uc0dd\uc131\"><br>3. \ud328\ud0a4\uc9c0 \uc0dd\uc131<\/h2>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-8fa0cd0b3a1709f41688f21ca661bd49\"><br>\ud398\uc774\uc9c0 \uc900\ube44\uac00 \ub418\uc5c8\uc73c\ub2c8 \uc5d1\uc140\uc744 \uc5c5\ub85c\ub4dc \ud588\uc744 \ub54c \uc5d1\uc140\uc758 \ub370\uc774\ud130\ub97c EXCEL_UPLOAD\uc5d0 \ub123\uc5b4\uc904 \uc218 \uc788\ub3c4\ub85d \ud568\uc218\uc640 \ud504\ub85c\uc2dc\uc800\ub97c \ub2f4\uc740 \ud328\ud0a4\uc9c0\ub97c \ub9cc\ub4e4\uc5b4\uc90d\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>create or replace PACKAGE \"AUTOOFFICE_EXCEL_UPLOAD\" AS\n\nFUNCTION GET_FILE_BLOB (P_SEQNO NUMBER) RETURN BLOB;\nFUNCTION GET_FILE_NAME (P_SEQNO NUMBER) RETURN VARCHAR2;\nFUNCTION GET_FILE_TYPE (P_SEQNO NUMBER) RETURN VARCHAR2;\n\nPROCEDURE INSERT_DATA (P_SEQNO IN NUMBER, P_APPUSER IN VARCHAR2);\n\nEND \"AUTOOFFICE_EXCEL_UPLOAD\";\n\/<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>create or replace PACKAGE BODY \"AUTOOFFICE_EXCEL_UPLOAD\" AS \n\nFUNCTION GET_FILE_BLOB (P_SEQNO NUMBER) \nRETURN BLOB IS L_BLOB BLOB;\n\n    BEGIN\n    SELECT\n        FILE_CONTENT INTO L_BLOB\n    FROM\n        EXCEL_FILE\n    WHERE\n        SEQNO = P_SEQNO;\n\n    RETURN L_BLOB;\n\n    END;\n\nFUNCTION GET_FILE_NAME (P_SEQNO NUMBER) \nRETURN VARCHAR2 IS L_FILE_NAME VARCHAR2 (200);\n\n    BEGIN\n    SELECT\n        FILE_NAME INTO L_FILE_NAME\n    FROM\n        EXCEL_FILE\n    WHERE\n        SEQNO = P_SEQNO;\n\n    RETURN L_FILE_NAME;\n\n    END;\n\nFUNCTION GET_FILE_TYPE (P_SEQNO NUMBER) \nRETURN VARCHAR2 IS L_FILE_TYPE VARCHAR2 (100);\n\n    BEGIN\n    SELECT\n        APEX_DATA_PARSER.GET_FILE_TYPE(FILE_NAME) INTO L_FILE_TYPE\n    FROM\n        EXCEL_FILE\n    WHERE\n        SEQNO = P_SEQNO;\n\n    RETURN L_FILE_TYPE;\n\n    END;\n\nPROCEDURE INSERT_DATA (\n        P_SEQNO    IN NUMBER,\n        P_APPUSER  IN VARCHAR2\n    ) IS\n\n    CURSOR C_EXCEL IS\n    SELECT\n        COL001,\n        COL002,\n        COL003,\n        COL004,\n        COL005,\n        COL006,\n        COL007,\n        COL008,\n        COL009,\n        COL010,\n        COL011,\n        COL012,\n        COL013,\n        COL014,\n        COL015, \n        COL016,\n        COL017,\n        COL018,\n        COL019,\n        COL020\n    FROM\n         TABLE ( APEX_DATA_PARSER.PARSE(\n            P_CONTENT =\uff1e AUTOOFFICE_EXCEL_UPLOAD.GET_FILE_BLOB(P_SEQNO), \n            P_FILE_NAME =\uff1e AUTOOFFICE_EXCEL_UPLOAD.GET_FILE_NAME(P_SEQNO),\n            P_SKIP_ROWS =\uff1e 0, \n            P_FILE_TYPE =\uff1e AUTOOFFICE_EXCEL_UPLOAD.GET_FILE_TYPE(P_SEQNO)\n            ) \n        );\n\n    BEGIN\n\n        FOR R_EXCEL IN C_EXCEL LOOP\n\n            INSERT INTO EXCEL_UPLOAD (\n                EXCEL_SEQNO,\n                COL1,\n                COL2,\n                COL3,\n                COL4,\n                COL5,\n                COL6,\n                COL7,\n                COL8,\n                COL9,\n                COL10,\n                COL11,\n                COL12,\n                COL13,\n                COL14,\n                COL15,\n                COL16,\n                COL17,\n                COL18,\n                COL19,\n                COL20,\n                CREATED_AT,\n                CREATED_BY\n            ) VALUES (\n                P_SEQNO,\n                R_EXCEL.COL001,\n                R_EXCEL.COL002, \n                R_EXCEL.COL003,\n                R_EXCEL.COL004,\n                R_EXCEL.COL005,  \n                R_EXCEL.COL006,\n                R_EXCEL.COL007,\n                R_EXCEL.COL008,\n                R_EXCEL.COL009,\n                R_EXCEL.COL010,\n                R_EXCEL.COL011,\n                R_EXCEL.COL012,\n                R_EXCEL.COL013,\n                R_EXCEL.COL014,\n                R_EXCEL.COL015,\n                R_EXCEL.COL016,\n                R_EXCEL.COL017,\n                R_EXCEL.COL018,\n                R_EXCEL.COL019,\n                R_EXCEL.COL020,\n                SYSTIMESTAMP,\n                P_APPUSER\n            );        \n\n        END LOOP;\n\n        COMMIT;\n\n        EXCEPTION\n        WHEN OTHERS THEN\n            RAISE_APPLICATION_ERROR(-20123, 'EXCEL_UPLOAD INSERT ERROR =='                                                    \n                                            || ' EXCEL_SEQNO:'\n                                            || P_SEQNO\n                                            || SQLERRM);\n\n    END;\n\nEND \"AUTOOFFICE_EXCEL_UPLOAD\";\n\/<\/code><\/pre>\n\n\n\n<p><br>INSERT_DATA \ud504\ub85c\uc2dc\uc800\ub97c \uc911\uc2ec\uc73c\ub85c \uc124\uba85\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p>INSERT_DATA \ud504\ub85c\uc2dc\uc800\ub294 \uc5d1\uc140 \ud30c\uc77c \uc5c5\ub85c\ub4dc \ud3fc\uc5d0\uc11c \ud3fc \ud504\ub85c\uc138\uc2a4\ub97c \uc644\ub8cc\ud55c \ub4a4\uc5d0 \uc5f0\uc18d\uc801\uc73c\ub85c \uc2e4\ud589\ub418\ub294 \ud504\ub85c\uc138\uc2a4\ub85c \ucd94\uac00\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%3Af07aa2bc-12cf-4d35-8f79-f1729576de63%3Aimage.png&amp;blockId=235b2d8a-486c-8011-a11d-ea2bae694a32\" alt=\"\"\/><\/figure>\n<\/div>\n\n\n<p><br>\ud504\ub85c\uc138\uc2a4\uc758 Type\uc740 Invoke API\ub97c \uc120\ud0dd\ud558\uace0, \ud328\ud0a4\uc9c0\ub97c AUTOOFFICE_EXCEL_UPLOAD\ub97c \uc120\ud0dd\ud55c \ub4a4, \ud504\ub85c\uc2dc\uc800\ub97c INSERT_DATA\ub97c \uc120\ud0dd\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%3Adec23046-e4de-4597-8c69-a315e91e5ebc%3Aimage.png&amp;blockId=235b2d8a-486c-8089-851d-ece7d43b6f6a\" alt=\"\"\/><\/figure>\n\n\n\n<p><br>\uc774\ub807\uac8c \uc120\ud0dd\ud558\uba74 \ud30c\ub77c\ubbf8\ud130 \uac12\uc744 \uc9c0\uc815\ud574\uc8fc\uc5b4\uc57c \ud558\ub294\ub370, p_seqno \uc5d0\ub294 P21_SEQNO (\uc5ec\uae30\uc11c\ub294 21\ubc88 \ud398\uc774\uc9c0\ub77c\uc11c P21\uc785\ub2c8\ub2e4.), p_appuser\uc5d0\ub294 :APP_USER \ub97c \uc785\ub825\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc774\uc81c \ud3fc\uc73c\ub85c \uc5d1\uc140\uc744 \uc5c5\ub85c\ub4dc\ud558\uba74 INSERT_DATA\uac00 \uc2e4\ud589\ub418\uba74\uc11c EXCEL_UPLOAD \ud14c\uc774\ube14\uc5d0 \ud574\ub2f9 \uc5d1\uc140\uc758 \ub370\uc774\ud130\ub97c INSERT \ud574\uc90d\ub2c8\ub2e4. \ucf54\ub4dc \ub808\ubca8\ub85c \uc0b4\ud3b4\ubcf4\uc2e4\uae4c\uc694?<br><br><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>PROCEDURE INSERT_DATA (\n        P_SEQNO    IN NUMBER,\n        P_APPUSER  IN VARCHAR2\n    ) IS\n\n    CURSOR C_EXCEL IS\n    SELECT\n        COL001,\n        COL002,\n        COL003,\n        COL004,\n        COL005,\n        COL006,\n        COL007,\n        COL008,\n        COL009,\n        COL010,\n        COL011,\n        COL012,\n        COL013,\n        COL014,\n        COL015, \n        COL016,\n        COL017,\n        COL018,\n        COL019,\n        COL020\n    FROM\n         TABLE ( APEX_DATA_PARSER.PARSE(\n            P_CONTENT =\uff1e AUTOOFFICE_EXCEL_UPLOAD.GET_FILE_BLOB(P_SEQNO), \n            P_FILE_NAME =\uff1e AUTOOFFICE_EXCEL_UPLOAD.GET_FILE_NAME(P_SEQNO),\n            P_SKIP_ROWS =\uff1e 0, \n            P_FILE_TYPE =\uff1e AUTOOFFICE_EXCEL_UPLOAD.GET_FILE_TYPE(P_SEQNO)\n            ) \n        );<\/code><\/pre>\n\n\n\n<p><br><br>C_EXCEL\uc774\ub77c\ub294 \ucee4\uc11c\ub97c \ub9cc\ub4dc\ub294\ub370, APEX_DATA_PARSER.PARSE \ub77c\ub294 \ub0b4\uc7a5\ud568\uc218\ub97c \uc0ac\uc6a9\ud574\uc11c \ub9cc\ub4e0 \ud14c\uc774\ube14\uc5d0\uc11c SELECT\ub97c \ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p>APEX_DATA_PARSER.PARSE\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \ud30c\ub77c\ubbf8\ud130\ub97c \ubc1b\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>p_content: \uc5d1\uc140 \ud30c\uc77c\uc758 BLOB \uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p>AUTOOFFICE_EXCEL_UPLOAD.GET_FILE_BLOB(P_SEQNO) \uc73c\ub85c BLOB\uc744 \uac00\uc838\uc635\ub2c8\ub2e4. \uc774 \ud568\uc218\ub294 \uc55e\uc5d0 \uc815\uc758\uac00 \ub418\uc5b4 \uc788\ub294\ub370, p_seqno\ub85c blob\uc744 \uac00\uc838\uc624\ub294 \ud568\uc218\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p>p_file_name: AUTOOFFICE_EXCEL_UPLOAD.GET_FILE_NAME(P_SEQNO) \uc73c\ub85c \ud30c\uc77c\uc774\ub984\uc744 \uac00\uc838\uc635\ub2c8\ub2e4. (\uc0dd\ub7b5\ud574\ub3c4 \ub3d9\uc791\ud558\uae30\ub294 \ud569\ub2c8\ub2e4.)<\/p>\n\n\n\n<p>p_skip_rows: \uba87 \ud589\uc744 SKIP\ud560\uc9c0 \uacb0\uc815\ud569\ub2c8\ub2e4. 0\uc73c\ub85c \uc124\uc815\ud558\uba74 \ub9e8 \uccab \ud589\uc758 \ub77c\ubca8\ub3c4 \uac00\uc838\uc635\ub2c8\ub2e4. \ube44\uc815\ud615\uc758 \uc5d1\uc140 \ud30c\uc77c\uc744 \ub2e4\uc591\ud558\uac8c \ud65c\uc6a9\ud560 \ub54c\uc5d0\ub294 0\uc73c\ub85c \ud558\uba74 EXCEL_UPLOAD\uc5d0\uc11c \ub77c\ubca8\uae4c\uc9c0 \ubcfc \uc218 \uc788\uc5b4\uc11c \ud3b8\ub9ac\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p>p_file_type: AUTOOFFICE_EXCEL_UPLOAD.GET_FILE_TYPE(P_SEQNO)\uc73c\ub85c \ud30c\uc77c \ud655\uc7a5\uc790\ub97c \uac00\uc838\uc635\ub2c8\ub2e4. (\uc880 \ub354 \uc815\ud655\ud558\uac8c\ub294 APEX\uc5d0\uc11c \uc0ac\uc6a9\ud558\ub294 \ud615\ud0dc\ub85c \ubcc0\ud658\ud55c \uac12\uc744 \uac00\uc838\uc635\ub2c8\ub2e4.)<\/p>\n\n\n\n<p>\ud83d\udca1\ub354 \uc790\uc138\ud788 \ubcf4\uc2dc\ub824\uba74, \uc624\ub77c\ud074 \uc6f9\uc0ac\uc774\ud2b8\ub97c \ubc29\ubb38\ud558\uc138\uc694.<br><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"alignleft size-full is-resized\"><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/application-express\/21.1\/aeapi\/PARSE-Function.html\" target=\"_blank\" rel=\" noreferrer noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"768\" height=\"432\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/08\/Oracle-Logo-1-768x432-1.png\" alt=\"\" class=\"wp-image-17032\" style=\"width:342px;height:auto\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/08\/Oracle-Logo-1-768x432-1.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/08\/Oracle-Logo-1-768x432-1-300x169.png 300w\" sizes=\"auto, (max-width: 768px) 100vw, 768px\" \/><\/a><figcaption class=\"wp-element-caption\"><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/application-express\/21.1\/aeapi\/PARSE-Function.html\" target=\"_blank\" rel=\"noopener\" title=\"\">API Reference<\/a><\/figcaption><\/figure>\n<\/div>\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-4b8031565505ea17504eda488abd6ddf\"><br><br><br><br><br><br><br><br><br><br><br><br>\uadf8 \ub2e4\uc74c\uc73c\ub85c \ucee4\uc11c\ub97c \uc21c\ud68c\ud558\uba74\uc11c \uac01 \ud589\uc744 EXCEL_UPLOAD\uc5d0 INSERT \ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-c98d1eef2fe7d18e2cd9df021ed5d399\">\uc774 \ub54c EXCEL_SEQNO\uc5d0 p_seqno \ub97c \ub123\uc5b4\uc8fc\uc5b4\uc11c FK\uc5ed\ud560\uc744 \ud558\ub3c4\ub85d \ub9cc\ub4e4\uc5b4\uc90d\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"aioseo-4-\ud398\uc774\uc9c0-\ub9c1\ud06c-\uc5f0\uacb0\">4. \ud398\uc774\uc9c0 \ub9c1\ud06c \uc5f0\uacb0<\/h2>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-1537324fced900141839edf1c4599b14\"><br>\uc774\uc81c \ub370\uc774\ud130\ub294 \uc815\uc0c1\uc801\uc73c\ub85c \ub4e4\uc5b4\uac00\uae30 \ub54c\ubb38\uc5d0 \ud398\uc774\uc9c0 \ub9c1\ud06c\ub9cc \uc5f0\uacb0\uc744 \ud574\uc8fc\uba74 \ub429\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"aioseo-\uc5d1\uc140-\ud30c\uc77c-\ubaa9\ub85d-\ud398\uc774\uc9c0-\uc5d1\uc140-\ud30c\uc77c-\ub0b4\uc6a9-\ud398\uc774\uc9c0\">\uc5d1\uc140 \ud30c\uc77c \ubaa9\ub85d \ud398\uc774\uc9c0 &#8211; \uc5d1\uc140 \ud30c\uc77c \ub0b4\uc6a9 \ud398\uc774\uc9c0<br><\/h3>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-17d49f3f9adadb44163923c9b0315253\"><br>\uc5d1\uc140 \ud30c\uc77c \ubaa9\ub85d \ud398\uc774\uc9c0\uc5d0\uc11c SEQNO\uc5d0\ub294 \uc5d1\uc140 \ud30c\uc77c \ub0b4\uc6a9 \ud398\uc774\uc9c0\ub85c \uc5f0\uacb0\uc744 \ud574\uc8fc\uba74\uc11c SEQNO\ub97c EXCEL_SEQNO \uc544\uc774\ud15c\uc73c\ub85c \ub118\uaca8\uc90d\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-72aed553e935eddf1e7d4208c06edae5\">\uc5d1\uc140 \ud30c\uc77c \ub0b4\uc6a9 \ud398\uc774\uc9c0\uc5d0\uc11c\ub294 REGION\uc758 \uc18c\uc2a4\uc5d0 EXCEL_SEQNO\ub85c WHERE \ubb38\uc744 \ub123\uc5b4 \ud544\ud130\ub9c1\uc744 \ud574\uc90d\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%3A2471fde6-c128-4fb5-8533-d5a1c8b8b693%3Aimage.png&amp;blockId=235b2d8a-486c-809a-bd64-f5c7a83aeabe\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-927bb36411f63caa96b16bb8cfa4bfd7\"><br>\uc5f0\uacb0\uc774 \uc815\uc0c1\uc801\uc73c\ub85c \ub418\uba74, \uc5d1\uc140 \ud30c\uc77c \ubaa9\ub85d \ud398\uc774\uc9c0\uc5d0\uc11c \uc5d1\uc140 \ud30c\uc77c \ub0b4\uc6a9 \ud398\uc774\uc9c0\ub85c \ub118\uc5b4\uac00\uba74\uc11c \ud574\ub2f9 \ub370\uc774\ud130\ub97c \ud45c\uc2dc\ud574\uc8fc\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%3A16e4696d-37c3-43f1-be65-d896c5d1d13c%3Aimage.png&amp;blockId=237b2d8a-486c-80f9-b263-ce2b1b568745\" alt=\"\"\/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading has-theme-palette-3-color has-text-color has-link-color wp-elements-4b23f445542d02679a39562c3dcb1a13\" id=\"aioseo-\uc5d1\uc140-\ud30c\uc77c-\ubaa9\ub85d-\ud398\uc774\uc9c0-\uc5d1\uc140-\ud30c\uc77c-\ud3fc\"><br>\uc5d1\uc140 \ud30c\uc77c \ubaa9\ub85d \ud398\uc774\uc9c0 &#8211; \uc5d1\uc140 \ud30c\uc77c \ud3fc<\/h3>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-8cff37a2f06a6b405be0affb5a0b8a18\"><br>FILE_NAME \uc544\uc774\ud15c\uc5d0\ub294 \uc5d1\uc140 \ud30c\uc77c \ud3fc \ud398\uc774\uc9c0\ub85c \uc5f0\uacb0\uc744 \ud574\uc8fc\uba74\uc11c SEQNO\ub97c \ub118\uaca8\uc90d\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-55dad93d05354f0f010501fcb389309a\">\uc774\ub807\uac8c \ud558\uba74 \ud3fc \ud398\uc774\uc9c0\ub85c \ub4e4\uc5b4\uac00 \uc5c5\ub85c\ub4dc\ud588\ub358 \ud30c\uc77c\uc744 \ub2e4\uc6b4\ub85c\ub4dc \ud560 \uc218\ub3c4 \uc788\uc2b5\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%3A01e3f3e5-67ff-4399-9a2a-989558ce220f%3Aimage.png&amp;blockId=235b2d8a-486c-80e2-94eb-ccf127ab7412\" alt=\"\"\/><\/figure>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-64977e5980cf71ad1e09d64bcd82fc8b\"><br>\uc774\ub807\uac8c \ud574\uc11c \uc5d1\uc140 \ud30c\uc77c\uc744 \uc5c5\ub85c\ub4dc\ud558\uace0 \ub0b4\uc6a9\uc744 APEX\uc5d0\uc11c \ud655\uc778\ud558\ub294 \ud398\uc774\uc9c0\ub97c \uc0dd\uc131\ud558\uc600\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-0192f63a1da98ab56936841ca18c7f11\">\uc2e4\ubb34\uc5d0\uc11c\ub294 \uc5ec\uae30\uc11c \uadf8\uce58\uc9c0 \uc54a\uace0, \ud30c\uc2f1\uc744 \uc880 \ub354 \uc815\uad50\ud558\uac8c \ud574\uc11c \ud544\uc694\ud55c \ub370\uc774\ud130\ub85c \ub9cc\ub4e0 \ud6c4\uc5d0 \ubaa9\uc801\ud558\ub294 \ud14c\uc774\ube14\ub85c INSERT \ud569\ub2c8\ub2e4. \uadf8\ub798\uc11c \ud328\ud0a4\uc9c0\uc5d0 INSERT_DATA \uc5ed\ud560\uc744 \ud558\ub294 \ud504\ub85c\uc2dc\uc800\uac00 \uc5d1\uc140 \ud30c\uc77c\uc758 \ud15c\ud50c\ub9bf\uc5d0 \ub530\ub77c \uc5ec\ub7ec\uac1c \ub9cc\ub4e4\uc5b4\uc9c0\uace4 \ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-a859d2a534fdc2632202e74d3211ff9f\">\uc774 \ud3ec\uc2a4\ud2b8\ub97c \uae30\ucd08\ub85c \ud558\uba74 \uc751\uc6a9\ub3c4 \uac00\ub2a5\ud560 \uac83\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>APEX\ub97c \uac1c\ubc1c\ud574\uc11c \uc0ac\uc6a9\ud558\ub2e4\ubcf4\uba74 \uc678\ubd80\uc5d0\uc11c \uc0dd\uc131\ud55c \uc5d1\uc140 \ud30c\uc77c\uc744 \uc5c5\ub85c\ub4dc\ud574\uc57c \ud558\ub294 \uacbd\uc6b0\uac00 \ubc1c\uc0dd\ud569\ub2c8\ub2e4. \ubcf4\ud1b5 \uc5c5\ubb34 \ud504\ub85c\uc138\uc2a4\uac00 \ub2e8 \ud558\ub098\uc758 \uc2dc\uc2a4\ud15c\ub9cc\uc73c\ub85c \uc774\ub8e8\uc5b4\uc9c0\uc9c0 \uc54a\uae30 \ub54c\ubb38\uc774\uc8e0. \ub354\uc874\uacfc \uac19\uc740 \ud68c\uacc4 \ud504\ub85c\uadf8\ub7a8\uc744 \uc0ac\uc6a9\ud558\uba74\uc11c \ub370\uc774\ud130\ub97c \uc5f0\ub3d9\ud574\uc57c \ud560 \uc218\ub3c4 \uc788\uace0, \uc0ac\ubc29\ub137\uacfc \uac19\uc740 \ucee4\uba38\uc2a4 \ud504\ub85c\uadf8\ub7a8\uc5d0\uc11c \ub370\uc774\ud130\ub97c \ub0b4\ub824\ubc1b\uc544\uc11c \ud65c\uc6a9\ud574\uc57c \ud558\ub294 \uacbd\uc6b0\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\ub7f4 \ub54c, \uc5d1\uc140\uc758 \ub0b4\uc6a9\uc744 \ubcf5\ubd99\ud560 \uc218 \uc788\ub2e4\uba74 \ud3b8\ud558\uaca0\uc9c0\ub9cc, APEX\uc5d0\uc11c\ub294 \uadf8\ub807\uac8c\uae4c\uc9c0\ub294 \uc9c0\uc6d0\ud558\uc9c0 \uc54a\uace0 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \ud3ec\uc2a4\ud2b8\uc5d0\uc11c\ub294&#8230;<\/p>\n","protected":false},"author":6,"featured_media":17031,"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,587],"class_list":["post-17030","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-apex","tag-apex","tag-oracle","tag-oracle-apex","tag-oracle-excel"],"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\/17030","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=17030"}],"version-history":[{"count":6,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/17030\/revisions"}],"predecessor-version":[{"id":17273,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/17030\/revisions\/17273"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media\/17031"}],"wp:attachment":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media?parent=17030"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/categories?post=17030"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/tags?post=17030"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}