\n \ub370\uc774\ud130 \ub9c8\uc774\uadf8\ub808\uc774\uc158\uc740 \uae30\uc5c5\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad00\ub9ac\uc5d0\uc11c \ub9e4\uc6b0 \uc911\uc694\ud55c \uc694\uc18c\ub85c \uc790\ub9ac \uc7a1\uace0 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub294 \ub370\uc774\ud130\uc758 \uc591\uc774 \ubc29\ub300\ud574\uc9d0\uc5d0 \ub530\ub77c \ub354\uc6b1 \uac15\uc870\ub418\uace0 \uc788\ub294 \uacfc\uc815\uc785\ub2c8\ub2e4. \uc774 \uae00\uc5d0\uc11c\ub294 \uc624\ub77c\ud074 \ud504\ub85c\uc2dc\uc800\uc640 C#\uc744 \ud65c\uc6a9\ud558\uc5ec \ub370\uc774\ud130 \ub9c8\uc774\uadf8\ub808\uc774\uc158\uc744 \uc790\ub3d9\ud654\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc124\uba85\ud558\uace0, \ub300\ub7c9\uc758 \ub370\uc774\ud130\ub97c \uc624\ub77c\ud074 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uac04 \ub610\ub294 \ub2e4\ub978 \uc2dc\uc2a4\ud15c\uc73c\ub85c \ud6a8\uacfc\uc801\uc73c\ub85c \ub9c8\uc774\uadf8\ub808\uc774\uc158\ud558\ub294 \uc804\ub7b5\uc744 \ub9c8\ub828\ud569\ub2c8\ub2e4.\n <\/p>\n<\/section>\n \n \ub370\uc774\ud130 \ub9c8\uc774\uadf8\ub808\uc774\uc158\uc740 \uc5ec\ub7ec \uc774\uc720\ub85c \ud544\uc694\ud569\ub2c8\ub2e4. \uc2dc\uc2a4\ud15c \uc5c5\uadf8\ub808\uc774\ub4dc, \ub370\uc774\ud130 \ud1b5\ud569, \uc0c8\ub85c\uc6b4 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub85c\uc758 \uc774\uc804 \ub4f1 \ub2e4\uc591\ud55c \uc774\uc720\uac00 \uc788\uc2b5\ub2c8\ub2e4. \ub370\uc774\ud130 \ub9c8\uc774\uadf8\ub808\uc774\uc158\uc744 \uc131\uacf5\uc801\uc73c\ub85c \uc218\ud589\ud558\uc9c0 \ubabb\ud560 \uacbd\uc6b0 \ub370\uc774\ud130 \uc190\uc2e4, \uc2dc\uc2a4\ud15c \uc911\ub2e8, \ube44\uc988\ub2c8\uc2a4 \uc6b4\uc601\uc5d0 \uc545\uc601\ud5a5\uc744 \ubbf8\uce60 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub530\ub77c\uc11c, \uc548\uc815\uc801\uc774\uace0 \uc2e0\ub8b0\ud560 \uc218 \uc788\ub294 \uc808\ucc28\uac00 \ud544\uc694\ud569\ub2c8\ub2e4.\n <\/p>\n<\/section>\n \n \uc624\ub77c\ud074 \ud504\ub85c\uc2dc\uc800\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \uc800\uc7a5 \ud504\ub85c\uc2dc\uc800\uc758 \ud615\ud0dc\ub85c \uc791\uc131\ub41c \ud504\ub85c\uadf8\ub7a8\uc785\ub2c8\ub2e4. \uc774\ub294 \ubcf5\uc7a1\ud55c \ucffc\ub9ac \ubc0f \ube44\uc988\ub2c8\uc2a4 \ub85c\uc9c1\uc744 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ub0b4\uc5d0\uc11c \uc9c1\uc811 \uc2e4\ud589\ud560 \uc218 \uc788\ub294 \uae30\ub2a5\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4. \uc800\uc7a5 \ud504\ub85c\uc2dc\uc800\ub97c \uc774\uc6a9\ud558\uba74, \ud074\ub77c\uc774\uc5b8\ud2b8\uc640 \uc11c\ubc84 \uac04\uc758 \ub370\uc774\ud130 \uc804\uc1a1\ub7c9\uc744 \uc904\uc774\uace0, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc131\ub2a5\uc744 \ud06c\uac8c \ud5a5\uc0c1\uc2dc\ud0ac \uc218 \uc788\uc2b5\ub2c8\ub2e4.\n <\/p>\n \n C#\uc740 \ub9c8\uc774\ud06c\ub85c\uc18c\ud504\ud2b8\uac00 \uac1c\ubc1c\ud55c \uac1d\uccb4 \uc9c0\ud5a5 \ud504\ub85c\uadf8\ub798\ubc0d \uc5b8\uc5b4\ub85c, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc5d0\uc11c \ub110\ub9ac \uc0ac\uc6a9\ub418\uace0 \uc788\uc2b5\ub2c8\ub2e4. C#\uc744 \uc774\uc6a9\ud558\uc5ec \uc624\ub77c\ud074 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640\uc758 \ud1b5\uc2e0\uc744 \uad6c\ud604\ud560 \uc218 \uc788\uc73c\uba70, \uc774\ub97c \ud1b5\ud574 \ub370\uc774\ud130 \ub9c8\uc774\uadf8\ub808\uc774\uc158 \ud504\ub85c\uc138\uc2a4\ub97c \uc790\ub3d9\ud654\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud2b9\ud788 ADO.NET\uc744 \uc774\uc6a9\ud558\uba74 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640\uc758 \uc5f0\uacb0\uc744 \uc27d\uac8c \uc124\uc815\ud558\uace0, CRUD(Create, Read, Update, Delete) \uc791\uc5c5\uc744 \ubcf4\ub2e4 \ud6a8\uc728\uc801\uc73c\ub85c \uc218\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.\n <\/p>\n \n ADO.NET\uc740 C#\uc5d0\uc11c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640\uc758 \uc0c1\ud638 \uc791\uc6a9\uc744 \uc9c0\uc6d0\ud558\ub294 \ub77c\uc774\ube0c\ub7ec\ub9ac\uc785\ub2c8\ub2e4. \uc774\ub97c \ud1b5\ud574 \uc624\ub77c\ud074 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \uc5f0\uacb0\ud558\uace0 \ub370\uc774\ud130\ub97c \uc870\uc791\ud558\ub294\ub370 \ud544\uc694\ud55c \uc5ec\ub7ec \uae30\ub2a5\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4. ADO.NET\uc744 \ud65c\uc6a9\ud574 \ub370\uc774\ud130 \uc5f0\uacb0, \uba85\ub839 \uc2e4\ud589, \ub370\uc774\ud130 \uc77d\uae30 \ub4f1\uc744 \uac04\ub2e8\ud558\uac8c \uad6c\ud604\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.\n <\/p>\n<\/section>\n \n \ub370\uc774\ud130 \ub9c8\uc774\uadf8\ub808\uc774\uc158\uc744 \uc790\ub3d9\ud654\ud558\uae30 \uc704\ud574 \ub2e4\uc74c\uacfc \uac19\uc740 \uc808\ucc28\ub97c \ub530\ub985\ub2c8\ub2e4.\n <\/p>\n \n \uc624\ub77c\ud074\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uc870\ud68c\ud558\uace0, \uac00\uacf5\ud55c \ud6c4, \ub2e4\ub978 \uc704\uce58\uc5d0 \uc800\uc7a5\ud558\ub294 \ud504\ub85c\uc2dc\uc800\ub97c \uc791\uc131\ud569\ub2c8\ub2e4. \uc544\ub798\ub294 \uc608\uc81c \ud504\ub85c\uc2dc\uc800 \ucf54\ub4dc\uc785\ub2c8\ub2e4.\n <\/p>\n \n C#\uc744 \uc774\uc6a9\ud574 \uc624\ub77c\ud074 \ud504\ub85c\uc2dc\uc800\ub97c \ud638\ucd9c\ud558\uace0, \ub370\uc774\ud130\ub97c \ub9c8\uc774\uadf8\ub808\uc774\uc158\ud558\ub294 \ucf54\ub4dc\ub97c \uc791\uc131\ud569\ub2c8\ub2e4. \uc544\ub798\ub294 \uc774\ub97c \uc704\ud55c C# \uc608\uc81c \ucf54\ub4dc\uc785\ub2c8\ub2e4.\n <\/p>\n \n \ub300\ub7c9\uc758 \ub370\uc774\ud130\ub97c \ub9c8\uc774\uadf8\ub808\uc774\uc158\ud560 \uacbd\uc6b0, \ud55c \ubc88\uc5d0 \ub9ce\uc740 \uc591\uc758 \ub370\uc774\ud130\ub97c \ucc98\ub9ac\ud558\ub294 \uac83\uc774 \uc911\uc694\ud569\ub2c8\ub2e4. \uc774\ub97c \uc704\ud574 \ubc30\uce58 \ucc98\ub9ac\ub97c \uc801\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ubc30\uce58 \ucc98\ub9ac\ub780, \uc5ec\ub7ec \uac1c\uc758 \ub370\uc774\ud130\ub97c \ubaa8\uc544\uc11c \ud55c \ubc88\uc5d0 \uc804\uc1a1\ud558\ub294 \ubc29\uc2dd\uc73c\ub85c, \uc774\ub294 \ub124\ud2b8\uc6cc\ud06c \ubd80\ud558\ub97c \uc904\uc774\uace0 \uc131\ub2a5\uc744 \ud5a5\uc0c1\uc2dc\ud0a4\ub294 \ub370 \ub3c4\uc6c0\uc774 \ub429\ub2c8\ub2e4.\n <\/p>\n \n \ub2e4\uc74c\uc740 \ubc30\uce58 \ucc98\ub9ac\ub97c \uc801\uc6a9\ud55c \uc624\ub77c\ud074 \ud504\ub85c\uc2dc\uc800\uc758 \uc608\uc785\ub2c8\ub2e4.\n <\/p>\n \n \ub370\uc774\ud130 \ub9c8\uc774\uadf8\ub808\uc774\uc158 \uacfc\uc815\uc5d0\uc11c \uc624\ub958\uac00 \ubc1c\uc0dd\ud560 \uc218 \uc788\uc73c\ubbc0\ub85c, \uc774\uc5d0 \ub300\ud55c \ucc98\ub9ac\uac00 \ud544\uc694\ud569\ub2c8\ub2e4. SQL \uc608\uc678 \ubc1c\uc0dd \uc2dc \uc774\ub97c \uc801\uc808\ud788 \ucc98\ub9ac\ud558\uace0 \ub85c\uadf8\ub97c \uae30\ub85d\ud568\uc73c\ub85c\uc368, \ud6c4\uc18d \uc870\uce58\ub97c \ucde8\ud560 \uc218 \uc788\ub3c4\ub85d \ud574\uc57c \ud569\ub2c8\ub2e4.\n <\/p>\n \n \ub2e4\uc74c\uc740 \uc624\ub958\ub97c \ucc98\ub9ac\ud558\uace0 \ub85c\uadf8\ub97c \uae30\ub85d\ud558\ub294 C# \uc608\uc81c\uc785\ub2c8\ub2e4.\n <\/p>\n \n \ub370\uc774\ud130 \ub9c8\uc774\uadf8\ub808\uc774\uc158 \uc790\ub3d9\ud654\ub294 \ub9ce\uc740 \uc2dc\uac04\uacfc \ub178\ub825\uc744 \uc808\uac10\ud560 \uc218 \uc788\ub294 \uc911\uc694\ud55c \uacfc\uc815\uc785\ub2c8\ub2e4. \uc624\ub77c\ud074 \ud504\ub85c\uc2dc\uc800\uc640 C#\uc744 \ud65c\uc6a9\ud558\uba74, \ub300\ub7c9\uc758 \ub370\uc774\ud130\ub97c \uc548\uc815\uc801\uc73c\ub85c \ucc98\ub9ac\ud560 \uc218 \uc788\uc73c\uba70, \ub2e4\uc591\ud55c \uc624\ub958 \ucc98\ub9ac \uae30\ubc95\uc744 \ud1b5\ud574 \uc2e0\ub8b0\uc131\uc744 \ub192\uc77c \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc801\uc808\ud55c \uacc4\ud68d\uacfc \uad6c\ud604\uc744 \ud1b5\ud574 \uae30\uc5c5\uc758 \ub370\uc774\ud130 \uad00\ub9ac \ud6a8\uc728\uc131\uc744 \ub04c\uc5b4\uc62c\ub9b4 \uc218 \uc788\uc2b5\ub2c8\ub2e4.\n <\/p>\n<\/section>\n2. \ub370\uc774\ud130 \ub9c8\uc774\uadf8\ub808\uc774\uc158\uc758 \ud544\uc694\uc131<\/h2>\n
3. \uc624\ub77c\ud074 \ud504\ub85c\uc2dc\uc800\uc758 \uc774\ud574<\/h2>\n
3.1 \uc800\uc7a5 \ud504\ub85c\uc2dc\uc800\uc758 \uc7a5\uc810<\/h3>\n
\n
4. C#\uc758 \uc5ed\ud560<\/h2>\n
4.1 ADO.NET\uc758 \ud65c\uc6a9<\/h3>\n
5. \ub370\uc774\ud130 \ub9c8\uc774\uadf8\ub808\uc774\uc158 \uc790\ub3d9\ud654 \ud504\ub85c\uc138\uc2a4<\/h2>\n
5.1 \ud504\ub85c\uc2dc\uc800 \uc791\uc131<\/h3>\n
\n
\n CREATE OR REPLACE PROCEDURE DATA_MIGRATION AS\n BEGIN\n INSERT INTO TARGET_TABLE (COLUMN1, COLUMN2)\n SELECT COLUMN1, COLUMN2 FROM SOURCE_TABLE WHERE CONDITION;\n END DATA_MIGRATION;\n <\/code>\n <\/pre>\n5.2 C#\uc5d0\uc11c \ud504\ub85c\uc2dc\uc800 \ud638\ucd9c<\/h3>\n
\n
\n using System;\n using System.Data;\n using Oracle.ManagedDataAccess.Client;\n\n class Program\n {\n static void Main(string[] args)\n {\n string connString = \"User Id=username;Password=password;Data Source=datasource\";\n using (OracleConnection conn = new OracleConnection(connString))\n {\n conn.Open();\n using (OracleCommand cmd = new OracleCommand(\"DATA_MIGRATION\", conn))\n {\n cmd.CommandType = CommandType.StoredProcedure;\n \/\/ \ud504\ub85c\uc2dc\uc800 \ud638\ucd9c\n cmd.ExecuteNonQuery();\n Console.WriteLine(\"\ub370\uc774\ud130 \ub9c8\uc774\uadf8\ub808\uc774\uc158\uc774 \uc644\ub8cc\ub418\uc5c8\uc2b5\ub2c8\ub2e4.\");\n }\n }\n }\n }\n <\/code>\n <\/pre>\n<\/section>\n6. \ub300\ub7c9\uc758 \ub370\uc774\ud130 \ub9c8\uc774\uadf8\ub808\uc774\uc158<\/h2>\n
6.1 \ubc30\uce58 \ub9c8\uc774\uadf8\ub808\uc774\uc158 \ud504\ub85c\uc2dc\uc800 \uc608\uc81c<\/h3>\n
\n
\n CREATE OR REPLACE PROCEDURE BATCH_DATA_MIGRATION AS\n CURSOR dataCursor IS\n SELECT COLUMN1, COLUMN2 FROM SOURCE_TABLE WHERE CONDITION;\n TYPE dataArray IS TABLE OF dataCursor%ROWTYPE;\n dataBatch dataArray;\n BEGIN\n OPEN dataCursor;\n LOOP\n FETCH dataCursor BULK COLLECT INTO dataBatch LIMIT 1000;\n EXIT WHEN dataBatch.COUNT = 0;\n\n FORALL i IN 1..dataBatch.COUNT\n INSERT INTO TARGET_TABLE (COLUMN1, COLUMN2) VALUES (dataBatch(i).COLUMN1, dataBatch(i).COLUMN2);\n END LOOP;\n CLOSE dataCursor;\n END BATCH_DATA_MIGRATION;\n <\/code>\n <\/pre>\n<\/section>\n7. \uc624\ub958 \ucc98\ub9ac \ubc0f \ub85c\uadf8 \uae30\ub85d<\/h2>\n
7.1 \uc624\ub958 \ucc98\ub9ac \uc608\uc81c<\/h3>\n
\n
\n try\n {\n cmd.ExecuteNonQuery();\n }\n catch (OracleException ex)\n {\n \/\/ \ub85c\uadf8 \uae30\ub85d\n Console.WriteLine(\"\uc624\ub958 \ubc1c\uc0dd: \" + ex.Message);\n }\n <\/code>\n <\/pre>\n<\/section>\n8. \uacb0\ub860<\/h2>\n