{"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 class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color wp-block-paragraph\">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 wp-block-paragraph\">\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 wp-block-paragraph\">\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 wp-block-paragraph\">\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 wp-block-paragraph\"><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 wp-block-paragraph\">\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 wp-block-paragraph\"><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 class=\"wp-block-paragraph\"><br><\/p>\n\n\n\n<p class=\"has-theme-palette-3-color has-text-color has-link-color wp-elements-bd1462b566447b27332d0da7d406ea89 wp-block-paragraph\">\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 wp-block-paragraph\">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 wp-block-paragraph\"><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 wp-block-paragraph\">\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 wp-block-paragraph\">\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 wp-block-paragraph\"><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 wp-block-paragraph\">\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 wp-block-paragraph\"><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 wp-block-paragraph\">\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 wp-block-paragraph\">\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 wp-block-paragraph\">\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 wp-block-paragraph\"><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 wp-block-paragraph\">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 wp-block-paragraph\"><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 wp-block-paragraph\">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 wp-block-paragraph\">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 wp-block-paragraph\"><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 wp-block-paragraph\">\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 wp-block-paragraph\"><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 class=\"wp-block-paragraph\"><br>INSERT_DATA \ud504\ub85c\uc2dc\uc800\ub97c \uc911\uc2ec\uc73c\ub85c \uc124\uba85\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\"><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 class=\"wp-block-paragraph\"><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 class=\"wp-block-paragraph\">\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 class=\"wp-block-paragraph\"><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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">p_content: \uc5d1\uc140 \ud30c\uc77c\uc758 BLOB \uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">\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 wp-block-paragraph\"><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 wp-block-paragraph\">\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 wp-block-paragraph\"><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 wp-block-paragraph\"><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 wp-block-paragraph\">\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 wp-block-paragraph\"><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 wp-block-paragraph\"><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 wp-block-paragraph\">\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 wp-block-paragraph\"><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 wp-block-paragraph\">\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 wp-block-paragraph\">\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 class=\"wp-block-paragraph\"><br><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide\"\/>\n\n\n\n<p class=\"wp-block-paragraph\"><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 class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><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 class=\"wp-block-paragraph\"><br><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/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.3","language":"en","enabled_languages":["ko","en"],"languages":{"ko":{"title":true,"content":true,"excerpt":false},"en":{"title":false,"content":false,"excerpt":false}}},"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.10 - aioseo.com -->\n\t<meta name=\"description\" content=\"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\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"autooffice\"\/>\n\t<meta name=\"keywords\" content=\"apex,oracle,oracle apex,oracle excel\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/www.autooffice.co.kr\/en\/blog\/2025\/08\/06\/apex-excel-upload\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.10\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Tech Blog of autooffice - Sharing Knowhow about automation, apps script, looker studio, BigQuery, spreadsheet.\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"[Oracle APEX] \uc5d1\uc140 \ud30c\uc77c \uc5c5\ub85c\ub4dc\ud558\uace0, \ub0b4\uc6a9 \uc870\ud68c\ud558\uae30 - Tech Blog of autooffice\" \/>\n\t\t<meta property=\"og:description\" content=\"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\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/www.autooffice.co.kr\/en\/blog\/2025\/08\/06\/apex-excel-upload\/\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2023\/07\/autooffice_share.png\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2023\/07\/autooffice_share.png\" \/>\n\t\t<meta property=\"og:image:width\" content=\"400\" \/>\n\t\t<meta property=\"og:image:height\" content=\"210\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2025-08-06T01:34:04+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2025-09-15T10:25:34+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"[Oracle APEX] \uc5d1\uc140 \ud30c\uc77c \uc5c5\ub85c\ub4dc\ud558\uace0, \ub0b4\uc6a9 \uc870\ud68c\ud558\uae30 - Tech Blog of autooffice\" \/>\n\t\t<meta name=\"twitter:description\" content=\"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\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2023\/07\/autooffice_share.png\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2025\\\/08\\\/06\\\/apex-excel-upload\\\/#blogposting\",\"name\":\"[Oracle APEX] \\uc5d1\\uc140 \\ud30c\\uc77c \\uc5c5\\ub85c\\ub4dc\\ud558\\uace0, \\ub0b4\\uc6a9 \\uc870\\ud68c\\ud558\\uae30 - Tech Blog of autooffice\",\"headline\":\"[Oracle APEX] \\uc5d1\\uc140 \\ud30c\\uc77c \\uc5c5\\ub85c\\ub4dc\\ud558\\uace0, \\ub0b4\\uc6a9 \\uc870\\ud68c\\ud558\\uae30\",\"author\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/author\\\/dev_eb\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/#organization\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/www.autooffice.co.kr\\\/wp\\\/wp-content\\\/uploads\\\/2025\\\/08\\\/WP-Thumb.jpg\",\"width\":2088,\"height\":1200},\"datePublished\":\"2025-08-06T10:34:04+09:00\",\"dateModified\":\"2025-09-15T19:25:34+09:00\",\"inLanguage\":\"en-US\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2025\\\/08\\\/06\\\/apex-excel-upload\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2025\\\/08\\\/06\\\/apex-excel-upload\\\/#webpage\"},\"articleSection\":\"APEX, APEX, oracle, Oracle APEX, oracle excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2025\\\/08\\\/06\\\/apex-excel-upload\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/category\\\/apex\\\/#listItem\",\"name\":\"APEX\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/category\\\/apex\\\/#listItem\",\"position\":2,\"name\":\"APEX\",\"item\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/category\\\/apex\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2025\\\/08\\\/06\\\/apex-excel-upload\\\/#listItem\",\"name\":\"[Oracle APEX] \\uc5d1\\uc140 \\ud30c\\uc77c \\uc5c5\\ub85c\\ub4dc\\ud558\\uace0, \\ub0b4\\uc6a9 \\uc870\\ud68c\\ud558\\uae30\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2025\\\/08\\\/06\\\/apex-excel-upload\\\/#listItem\",\"position\":3,\"name\":\"[Oracle APEX] \\uc5d1\\uc140 \\ud30c\\uc77c \\uc5c5\\ub85c\\ub4dc\\ud558\\uace0, \\ub0b4\\uc6a9 \\uc870\\ud68c\\ud558\\uae30\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/category\\\/apex\\\/#listItem\",\"name\":\"APEX\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/#organization\",\"name\":\"\\uc624\\ud1a0\\uc624\\ud53c\\uc2a4\",\"description\":\"Sharing Knowhow about automation, apps script, looker studio, BigQuery, spreadsheet.\",\"url\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/\",\"telephone\":\"+821024904264\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/www.autooffice.co.kr\\\/wp\\\/wp-content\\\/uploads\\\/2023\\\/07\\\/logo-new2023.png\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2025\\\/08\\\/06\\\/apex-excel-upload\\\/#organizationLogo\",\"width\":1461,\"height\":250},\"image\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2025\\\/08\\\/06\\\/apex-excel-upload\\\/#organizationLogo\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/author\\\/dev_eb\\\/#author\",\"url\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/author\\\/dev_eb\\\/\",\"name\":\"autooffice\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2025\\\/08\\\/06\\\/apex-excel-upload\\\/#webpage\",\"url\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2025\\\/08\\\/06\\\/apex-excel-upload\\\/\",\"name\":\"[Oracle APEX] \\uc5d1\\uc140 \\ud30c\\uc77c \\uc5c5\\ub85c\\ub4dc\\ud558\\uace0, \\ub0b4\\uc6a9 \\uc870\\ud68c\\ud558\\uae30 - Tech Blog of autooffice\",\"description\":\"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\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2025\\\/08\\\/06\\\/apex-excel-upload\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/author\\\/dev_eb\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/author\\\/dev_eb\\\/#author\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/www.autooffice.co.kr\\\/wp\\\/wp-content\\\/uploads\\\/2025\\\/08\\\/WP-Thumb.jpg\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2025\\\/08\\\/06\\\/apex-excel-upload\\\/#mainImage\",\"width\":2088,\"height\":1200},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/blog\\\/2025\\\/08\\\/06\\\/apex-excel-upload\\\/#mainImage\"},\"datePublished\":\"2025-08-06T10:34:04+09:00\",\"dateModified\":\"2025-09-15T19:25:34+09:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/\",\"name\":\"\\uc624\\ud1a0\\uc624\\ud53c\\uc2a4\",\"alternateName\":\"autooffice\",\"description\":\"Sharing Knowhow about automation, apps script, looker studio, BigQuery, spreadsheet.\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.autooffice.co.kr\\\/en\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"[Oracle APEX] \uc5d1\uc140 \ud30c\uc77c \uc5c5\ub85c\ub4dc\ud558\uace0, \ub0b4\uc6a9 \uc870\ud68c\ud558\uae30 - Tech Blog of autooffice","description":"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","canonical_url":"https:\/\/www.autooffice.co.kr\/en\/blog\/2025\/08\/06\/apex-excel-upload\/","robots":"max-image-preview:large","keywords":"apex,oracle,oracle apex,oracle excel","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2025\/08\/06\/apex-excel-upload\/#blogposting","name":"[Oracle APEX] \uc5d1\uc140 \ud30c\uc77c \uc5c5\ub85c\ub4dc\ud558\uace0, \ub0b4\uc6a9 \uc870\ud68c\ud558\uae30 - Tech Blog of autooffice","headline":"[Oracle APEX] \uc5d1\uc140 \ud30c\uc77c \uc5c5\ub85c\ub4dc\ud558\uace0, \ub0b4\uc6a9 \uc870\ud68c\ud558\uae30","author":{"@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/author\/dev_eb\/#author"},"publisher":{"@id":"https:\/\/www.autooffice.co.kr\/en\/#organization"},"image":{"@type":"ImageObject","url":"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/08\/WP-Thumb.jpg","width":2088,"height":1200},"datePublished":"2025-08-06T10:34:04+09:00","dateModified":"2025-09-15T19:25:34+09:00","inLanguage":"en-US","mainEntityOfPage":{"@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2025\/08\/06\/apex-excel-upload\/#webpage"},"isPartOf":{"@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2025\/08\/06\/apex-excel-upload\/#webpage"},"articleSection":"APEX, APEX, oracle, Oracle APEX, oracle excel"},{"@type":"BreadcrumbList","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2025\/08\/06\/apex-excel-upload\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/www.autooffice.co.kr\/en#listItem","position":1,"name":"Home","item":"https:\/\/www.autooffice.co.kr\/en","nextItem":{"@type":"ListItem","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/category\/apex\/#listItem","name":"APEX"}},{"@type":"ListItem","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/category\/apex\/#listItem","position":2,"name":"APEX","item":"https:\/\/www.autooffice.co.kr\/en\/blog\/category\/apex\/","nextItem":{"@type":"ListItem","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2025\/08\/06\/apex-excel-upload\/#listItem","name":"[Oracle APEX] \uc5d1\uc140 \ud30c\uc77c \uc5c5\ub85c\ub4dc\ud558\uace0, \ub0b4\uc6a9 \uc870\ud68c\ud558\uae30"},"previousItem":{"@type":"ListItem","@id":"https:\/\/www.autooffice.co.kr\/en#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2025\/08\/06\/apex-excel-upload\/#listItem","position":3,"name":"[Oracle APEX] \uc5d1\uc140 \ud30c\uc77c \uc5c5\ub85c\ub4dc\ud558\uace0, \ub0b4\uc6a9 \uc870\ud68c\ud558\uae30","previousItem":{"@type":"ListItem","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/category\/apex\/#listItem","name":"APEX"}}]},{"@type":"Organization","@id":"https:\/\/www.autooffice.co.kr\/en\/#organization","name":"\uc624\ud1a0\uc624\ud53c\uc2a4","description":"Sharing Knowhow about automation, apps script, looker studio, BigQuery, spreadsheet.","url":"https:\/\/www.autooffice.co.kr\/en\/","telephone":"+821024904264","logo":{"@type":"ImageObject","url":"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2023\/07\/logo-new2023.png","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2025\/08\/06\/apex-excel-upload\/#organizationLogo","width":1461,"height":250},"image":{"@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2025\/08\/06\/apex-excel-upload\/#organizationLogo"}},{"@type":"Person","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/author\/dev_eb\/#author","url":"https:\/\/www.autooffice.co.kr\/en\/blog\/author\/dev_eb\/","name":"autooffice"},{"@type":"WebPage","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2025\/08\/06\/apex-excel-upload\/#webpage","url":"https:\/\/www.autooffice.co.kr\/en\/blog\/2025\/08\/06\/apex-excel-upload\/","name":"[Oracle APEX] \uc5d1\uc140 \ud30c\uc77c \uc5c5\ub85c\ub4dc\ud558\uace0, \ub0b4\uc6a9 \uc870\ud68c\ud558\uae30 - Tech Blog of autooffice","description":"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","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/www.autooffice.co.kr\/en\/#website"},"breadcrumb":{"@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2025\/08\/06\/apex-excel-upload\/#breadcrumblist"},"author":{"@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/author\/dev_eb\/#author"},"creator":{"@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/author\/dev_eb\/#author"},"image":{"@type":"ImageObject","url":"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/08\/WP-Thumb.jpg","@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2025\/08\/06\/apex-excel-upload\/#mainImage","width":2088,"height":1200},"primaryImageOfPage":{"@id":"https:\/\/www.autooffice.co.kr\/en\/blog\/2025\/08\/06\/apex-excel-upload\/#mainImage"},"datePublished":"2025-08-06T10:34:04+09:00","dateModified":"2025-09-15T19:25:34+09:00"},{"@type":"WebSite","@id":"https:\/\/www.autooffice.co.kr\/en\/#website","url":"https:\/\/www.autooffice.co.kr\/en\/","name":"\uc624\ud1a0\uc624\ud53c\uc2a4","alternateName":"autooffice","description":"Sharing Knowhow about automation, apps script, looker studio, BigQuery, spreadsheet.","inLanguage":"en-US","publisher":{"@id":"https:\/\/www.autooffice.co.kr\/en\/#organization"}}]},"og:locale":"en_US","og:site_name":"Tech Blog of autooffice - Sharing Knowhow about automation, apps script, looker studio, BigQuery, spreadsheet.","og:type":"article","og:title":"[Oracle APEX] \uc5d1\uc140 \ud30c\uc77c \uc5c5\ub85c\ub4dc\ud558\uace0, \ub0b4\uc6a9 \uc870\ud68c\ud558\uae30 - Tech Blog of autooffice","og:description":"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","og:url":"https:\/\/www.autooffice.co.kr\/en\/blog\/2025\/08\/06\/apex-excel-upload\/","og:image":"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2023\/07\/autooffice_share.png","og:image:secure_url":"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2023\/07\/autooffice_share.png","og:image:width":400,"og:image:height":210,"article:published_time":"2025-08-06T01:34:04+00:00","article:modified_time":"2025-09-15T10:25:34+00:00","twitter:card":"summary_large_image","twitter:title":"[Oracle APEX] \uc5d1\uc140 \ud30c\uc77c \uc5c5\ub85c\ub4dc\ud558\uace0, \ub0b4\uc6a9 \uc870\ud68c\ud558\uae30 - Tech Blog of autooffice","twitter:description":"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","twitter:image":"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2023\/07\/autooffice_share.png"},"aioseo_meta_data":{"post_id":"17030","title":null,"description":null,"keywords":null,"keyphrases":{"focus":{"keyphrase":"","score":0,"analysis":{"keyphraseInTitle":{"score":0,"maxScore":9,"error":1}}},"additional":[]},"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":"","og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"BlogPosting","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":{"faqs":[],"keyPoints":[],"titles":[],"descriptions":[],"socialPosts":{"email":[],"linkedin":[],"twitter":[],"facebook":[],"instagram":[]}},"created":"2025-08-06 01:34:05","updated":"2025-09-15 10:36:13","seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/www.autooffice.co.kr\/en\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/www.autooffice.co.kr\/en\/blog\/category\/apex\/\" title=\"APEX\">APEX<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t[Oracle APEX] \uc5d1\uc140 \ud30c\uc77c \uc5c5\ub85c\ub4dc\ud558\uace0, \ub0b4\uc6a9 \uc870\ud68c\ud558\uae30\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/www.autooffice.co.kr\/en"},{"label":"APEX","link":"https:\/\/www.autooffice.co.kr\/en\/blog\/category\/apex\/"},{"label":"[Oracle APEX] \uc5d1\uc140 \ud30c\uc77c \uc5c5\ub85c\ub4dc\ud558\uace0, \ub0b4\uc6a9 \uc870\ud68c\ud558\uae30","link":"https:\/\/www.autooffice.co.kr\/en\/blog\/2025\/08\/06\/apex-excel-upload\/"}],"_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}]}}