\n1. \uc11c\ub860<\/h2>\n
\n \uc18c\ud504\ud2b8\uc6e8\uc5b4 \uac1c\ubc1c\uc5d0\uc11c \ub2e4\uc911 \uc0ac\uc6a9\uc790 \ud658\uacbd\uc744 \uc9c0\uc6d0\ud558\ub294 \uac83\uc740 \ub9e4\uc6b0 \uc911\uc694\ud569\ub2c8\ub2e4. \ud2b9\ud788 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \uc0c1\ud638\uc791\uc6a9\ud558\ub294 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc758 \uacbd\uc6b0 \ub2e4\uc218\uc758 \uc0ac\uc6a9\uc790\uac00 \ub3d9\uc2dc\uc5d0 \ub370\uc774\ud130\ub97c \uc870\ud68c\ud558\uac70\ub098 \uc218\uc815\ud560 \uc218 \uc788\uc5b4\uc57c \ud569\ub2c8\ub2e4. \ubcf8 \uae00\uc5d0\uc11c\ub294 C#\uacfc \uc624\ub77c\ud074 ProC(Pro*C) \ud504\ub85c\uc2dc\uc800\ub97c \uc774\uc6a9\ud55c \ub2e4\uc911 \uc0ac\uc6a9\uc790 \ub3d9\uc2dc \ucc98\ub9ac\uc5d0 \ub300\ud574 \ub2e4\ub8e8\uace0, \ub3d9\uc2dc\uc131 \uc81c\uc5b4 \ubc0f \uc7a0\uae08 \uc804\ub7b5\uc744 \uc124\uba85\ud558\uba70, C#\uc758 \ube44\ub3d9\uae30 \ud638\ucd9c \ubc29\uc2dd\uc5d0 \ub300\ud574 \uc790\uc138\ud788 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.\n <\/p>\n<\/section>\n\n2. \ub2e4\uc911 \uc0ac\uc6a9\uc790 \ub3d9\uc2dc \ucc98\ub9ac\ub780?<\/h2>\n
\n \ub2e4\uc911 \uc0ac\uc6a9\uc790 \ub3d9\uc2dc \ucc98\ub9ac\ub294 \uc5ec\ub7ec \uc0ac\uc6a9\uc790\uac00 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \ub3d9\uc2dc\uc5d0 \uc811\uadfc\ud558\uace0 \uc0c1\ud638\uc791\uc6a9\ud558\ub294 \uac83\uc744 \uc758\ubbf8\ud569\ub2c8\ub2e4. \uc774 \uacfc\uc815\uc5d0\uc11c \ub370\uc774\ud130\uc758 \uc77c\uad00\uc131\uacfc \ubb34\uacb0\uc131\uc744 \uc720\uc9c0\ud558\uae30 \uc704\ud574 \ub3d9\uc2dc\uc131 \uc81c\uc5b4\uac00 \ud544\uc694\ud569\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \ub450 \uc0ac\uc6a9\uc790\uac00 \ub3d9\uc77c\ud55c \ub370\uc774\ud130\ub97c \ub3d9\uc2dc\uc5d0 \uc218\uc815\ud558\ub824\uace0 \ud560 \ub54c \ub370\uc774\ud130 \uc190\uc0c1\uc774\ub098 \ucda9\ub3cc\uc774 \ubc1c\uc0dd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.\n <\/p>\n<\/section>\n\n3. C#\uacfc \uc624\ub77c\ud074 ProC \uac1c\uc694<\/h2>\n
\n C#\uc740 Microsoft\uc5d0\uc11c \uac1c\ubc1c\ud55c \uac1d\uccb4 \uc9c0\ud5a5 \ud504\ub85c\uadf8\ub798\ubc0d \uc5b8\uc5b4\ub85c, .NET \ud50c\ub7ab\ud3fc\uc5d0\uc11c \ub110\ub9ac \uc0ac\uc6a9\ub429\ub2c8\ub2e4. \uc624\ub77c\ud074 ProC\ub294 C \uc5b8\uc5b4\ub97c \uae30\ubc18\uc73c\ub85c \ud558\uba70, \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc791\uc5c5\uc744 \uc218\ud589\ud558\ub294 \ud504\ub85c\uc2dc\uc800\ub97c \uc791\uc131\ud558\ub294 \ub370 \uc0ac\uc6a9\ub429\ub2c8\ub2e4. ProC\ub294 SQL\uc744 \ud3ec\ud568\ud55c C \ud504\ub85c\uadf8\ub7a8\uc744 \uc791\uc131\ud560 \uc218 \uc788\ub3c4\ub85d \ud574\uc8fc\uba70, \uadf8 \uacb0\uacfc \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640\uc758 \uc6d0\ud65c\ud55c \ud1b5\uc2e0\uc774 \uac00\ub2a5\ud569\ub2c8\ub2e4.\n <\/p>\n<\/section>\n\n4. \ub3d9\uc2dc\uc131 \uc81c\uc5b4\uc758 \uc911\uc694\uc131<\/h2>\n
\n \ub3d9\uc2dc\uc131 \uc81c\uc5b4\ub294 \uc5ec\ub7ec \uc0ac\uc6a9\uc790\uac00 \ub3d9\uc2dc\uc5d0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc811\uadfc\ud560 \ub54c \ubc1c\uc0dd\ud560 \uc218 \uc788\ub294 \ubb38\uc81c\ub97c \ubc29\uc9c0\ud558\ub294 \uba54\ucee4\ub2c8\uc998\uc785\ub2c8\ub2e4. \uc77c\ubc18\uc801\uc73c\ub85c \uc0ac\uc6a9\ub418\ub294 \ub3d9\uc2dc\uc131 \uc81c\uc5b4 \ubc29\uc2dd\uc5d0\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uac83\ub4e4\uc774 \uc788\uc2b5\ub2c8\ub2e4:\n <\/p>\n
\n- \ub099\uad00\uc801 \ub3d9\uc2dc\uc131 \uc81c\uc5b4 (Optimistic Concurrency Control)<\/strong>: \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc218\uc815\uc774 \uc77c\uc5b4\ub0a0 \ub54c \ucda9\ub3cc\uc744 \uac80\uc99d\ud558\ub294 \ubc29\uc2dd.<\/li>\n
- \ube44\uad00\uc801 \ub3d9\uc2dc\uc131 \uc81c\uc5b4 (Pessimistic Concurrency Control)<\/strong>: \ub370\uc774\ud130\ub97c \uc218\uc815\ud558\uae30 \uc804\uc5d0 \ud574\ub2f9 \ub370\uc774\ud130\uc5d0 \ub300\ud55c \uc7a0\uae08\uc744 \uc124\uc815\ud558\uc5ec \ub2e4\ub978 \uc0ac\uc6a9\uc790\uc758 \uc811\uadfc\uc744 \ubc29\uc9c0\ud558\ub294 \ubc29\uc2dd.<\/li>\n<\/ul>\n<\/section>\n\n
5. \uc7a0\uae08 \uc804\ub7b5<\/h2>\n
\n \ub370\uc774\ud130\uc758 \ub3d9\uc2dc \uc811\uadfc\uc744 \uad00\ub9ac\ud558\uae30 \uc704\ud574 \uc0ac\uc6a9\ud558\ub294 \uc7a0\uae08 \uc804\ub7b5\uc5d0\ub294 \uc5ec\ub7ec \uac00\uc9c0\uac00 \uc788\uc2b5\ub2c8\ub2e4. \ub300\ud45c\uc801\uc778 \uc7a0\uae08 \uc804\ub7b5\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4:\n <\/p>\n
\n- \ud589 \uc7a0\uae08 (Row Locking)<\/strong>: \ud2b9\uc815 \ud589\uc5d0 \ub300\ud574 \uc7a0\uae08\uc744 \uc124\uc815\ud558\uc5ec \ub2e4\ub978 \ud2b8\ub79c\uc7ad\uc158\uc774 \ud574\ub2f9 \ud589\uc744 \uc218\uc815\ud558\uac70\ub098 \uc77d\uc744 \uc218 \uc5c6\ub3c4\ub85d \ud569\ub2c8\ub2e4.<\/li>\n
- \ud14c\uc774\ube14 \uc7a0\uae08 (Table Locking)<\/strong>: \uc804\uccb4 \ud14c\uc774\ube14\uc744 \uc7a0\uad88 \ud574\ub2f9 \ud14c\uc774\ube14\uc5d0 \ub300\ud55c \ubaa8\ub4e0 \uc218\uc815 \uc791\uc5c5\uc744 \uc9c1\ub82c\ud654\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n
\n \uc774\ub7ec\ud55c \uc7a0\uae08 \uc804\ub7b5\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc131\ub2a5 \ubc0f \uc751\ub2f5 \uc2dc\uac04\uc5d0 \uc601\ud5a5\uc744 \ubbf8\uce58\uae30 \ub54c\ubb38\uc5d0 \uc0c1\ud669\uc5d0 \ub530\ub77c \uc801\uc808\ud788 \uc120\ud0dd\ud574\uc57c \ud569\ub2c8\ub2e4.\n <\/p>\n<\/section>\n\n6. C#\uc5d0\uc11c\uc758 \ube44\ub3d9\uae30 \ud638\ucd9c<\/h2>\n
\n \ube44\ub3d9\uae30 \ud504\ub85c\uadf8\ub798\ubc0d\uc740 \uc0ac\uc6a9\uc790 \uc778\ud130\ud398\uc774\uc2a4(UI) \uc2a4\ub808\ub4dc\uac00 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640\uc758 \uc0c1\ud638\uc791\uc6a9\uc73c\ub85c \uc778\ud574 \ube14\ub85c\ud0b9\ub418\uc9c0 \uc54a\ub3c4\ub85d \ud574\uc90d\ub2c8\ub2e4. .NET\uc5d0\uc11c \ube44\ub3d9\uae30 \ud638\ucd9c\uc744 \uad6c\ud604\ud558\uae30 \uc704\ud574 async<\/code>\uc640 await<\/code> \ud0a4\uc6cc\ub4dc\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub97c \ud1b5\ud574 \uc0ac\uc6a9\uc790\ub294 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc758 \ub2e4\ub978 \uae30\ub2a5\uc744 \uacc4\uc18d \uc774\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.\n <\/p>\n\n \ube44\ub3d9\uae30 \ud638\ucd9c\uc744 \uc0ac\uc6a9\ud558\ub294 \uc608\uc81c\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4:\n <\/p>\n
\nusing System;\nusing System.Data;\nusing System.Data.SqlClient;\nusing System.Threading.Tasks;\n\nclass Program\n{\n static async Task Main(string[] args)\n {\n await ExecuteQueryAsync();\n }\n\n static async Task ExecuteQueryAsync()\n {\n string connectionString = \"your_connection_string\";\n using (SqlConnection connection = new SqlConnection(connectionString))\n {\n await connection.OpenAsync();\n SqlCommand command = new SqlCommand(\"SELECT * FROM your_table\", connection);\n SqlDataReader reader = await command.ExecuteReaderAsync();\n while (await reader.ReadAsync())\n {\n Console.WriteLine(reader[0].ToString());\n }\n }\n }\n}\n <\/code><\/pre>\n<\/section>\n\n7. \uc624\ub77c\ud074 ProC\uc5d0\uc11c\uc758 \ub3d9\uc2dc\uc131 \uc81c\uc5b4 \ubc0f \uc7a0\uae08 \uc804\ub7b5<\/h2>\n
\n \uc624\ub77c\ud074 ProC\uc5d0\uc11c\ub3c4 C#\uacfc \ub9c8\ucc2c\uac00\uc9c0\ub85c \ub2e4\uc591\ud55c \ub3d9\uc2dc\uc131 \uc81c\uc5b4 \ubc0f \uc7a0\uae08 \uc804\ub7b5\uc744 \ud65c\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. ProC\uc5d0\uc11c\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud2b8\ub79c\uc7ad\uc158\uc744 \uad00\ub9ac\ud558\uae30 \uc704\ud574 \uba85\uc2dc\uc801 \uc7a0\uae08\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc73c\uba70, \uc608\ub97c \ub4e4\uc5b4 \ub2e4\uc74c\uacfc \uac19\uc740 SQL \ubb38\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4:\n <\/p>\n
\n#include <stdio.h>\n#include <sqlca.h>\n\nvoid main()\n{\n EXEC SQL BEGIN DECLARE SECTION;\n int emp_id;\n float emp_salary;\n EXEC SQL END DECLARE SECTION;\n\n EXEC SQL CONNECT :username IDENTIFIED BY :password;\n\n EXEC SQL SELECT salary INTO :emp_salary\n FROM employees\n WHERE employee_id = :emp_id\n FOR UPDATE;\n\n \/* Update salary logic here *\/\n \n EXEC SQL COMMIT;\n EXEC SQL DISCONNECT;\n}\n <\/code><\/pre>\n\n \uc704 \ucf54\ub4dc\uc5d0\uc11c FOR UPDATE<\/code> \uc808\uc740 \ud2b9\uc815 \ud589\uc5d0 \ub300\ud55c \uc7a0\uae08\uc744 \uc124\uc815\ud558\uc5ec \ub2e4\ub978 \ud2b8\ub79c\uc7ad\uc158\uc774 \ud574\ub2f9 \ub370\uc774\ud130\ub97c \uc218\uc815\ud558\uc9c0 \ubabb\ud558\ub3c4\ub85d \ud569\ub2c8\ub2e4.\n <\/p>\n<\/section>\n\n8. \uacb0\ub860<\/h2>\n
\n C#\uacfc \uc624\ub77c\ud074 ProC\ub97c \ud1b5\ud574 \ub2e4\uc911 \uc0ac\uc6a9\uc790 \ub3d9\uc2dc \ucc98\ub9ac\ub97c \ud6a8\uacfc\uc801\uc73c\ub85c \uad00\ub9ac\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub3d9\uc2dc\uc131 \uc81c\uc5b4 \ubc0f \uc7a0\uae08 \uc804\ub7b5\uc744 \ud1b5\ud574 \ub370\uc774\ud130 \ubb34\uacb0\uc131\uc744 \uc720\uc9c0\ud558\uba74\uc11c \uc131\ub2a5\uc744 \uadf9\ub300\ud654\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ube44\ub3d9\uae30 \ud638\ucd9c\uc744 \ud65c\uc6a9\ud558\uc5ec \uc0ac\uc6a9\uc790 \uacbd\ud5d8\uc744 \ud5a5\uc0c1\uc2dc\ud0a4\uace0, \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640\uc758 \uc0c1\ud638\uc791\uc6a9\uc5d0\uc11c \ubc1c\uc0dd\ud560 \uc218 \uc788\ub294 \ubb38\uc81c\ub97c \uc608\ubc29\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub7ec\ud55c \uc6d0\uce59\ub4e4\uc744 \uc798 \uc774\ud574\ud558\uace0 \uc801\uc808\ud788 \uc801\uc6a9\ud558\uba74, \ub2e4\uc911 \uc0ac\uc6a9\uc790 \ud658\uacbd\uc5d0\uc11c\ub3c4 \uc548\uc815\uc801\uc774\uace0 \uc2e0\ub8b0\uc131 \ub192\uc740 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc744 \uac1c\ubc1c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.\n <\/p>\n<\/section>\n<\/article>\n
<\/body><\/p>\n","protected":false},"excerpt":{"rendered":"
1. \uc11c\ub860 \uc18c\ud504\ud2b8\uc6e8\uc5b4 \uac1c\ubc1c\uc5d0\uc11c \ub2e4\uc911 \uc0ac\uc6a9\uc790 \ud658\uacbd\uc744 \uc9c0\uc6d0\ud558\ub294 \uac83\uc740 \ub9e4\uc6b0 \uc911\uc694\ud569\ub2c8\ub2e4. \ud2b9\ud788 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \uc0c1\ud638\uc791\uc6a9\ud558\ub294 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc758 \uacbd\uc6b0 \ub2e4\uc218\uc758 \uc0ac\uc6a9\uc790\uac00 \ub3d9\uc2dc\uc5d0 \ub370\uc774\ud130\ub97c \uc870\ud68c\ud558\uac70\ub098 \uc218\uc815\ud560 \uc218 \uc788\uc5b4\uc57c \ud569\ub2c8\ub2e4. \ubcf8 \uae00\uc5d0\uc11c\ub294 C#\uacfc \uc624\ub77c\ud074 ProC(Pro*C) \ud504\ub85c\uc2dc\uc800\ub97c \uc774\uc6a9\ud55c \ub2e4\uc911 \uc0ac\uc6a9\uc790 \ub3d9\uc2dc \ucc98\ub9ac\uc5d0 \ub300\ud574 \ub2e4\ub8e8\uace0, \ub3d9\uc2dc\uc131 \uc81c\uc5b4 \ubc0f \uc7a0\uae08 \uc804\ub7b5\uc744 \uc124\uba85\ud558\uba70, C#\uc758 \ube44\ub3d9\uae30 \ud638\ucd9c \ubc29\uc2dd\uc5d0 \ub300\ud574 \uc790\uc138\ud788 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. 2. \ub2e4\uc911 \uc0ac\uc6a9\uc790 \ub3d9\uc2dc … \ub354 \ubcf4\uae30 “[C# PL\/SQL] 17.C#\uacfc \uc624\ub77c\ud074 \ud504\ub85c\uc2dc\uc800\ub97c \uc774\uc6a9\ud55c \ub2e4\uc911 \uc0ac\uc6a9\uc790 \ub3d9\uc2dc \ucc98\ub9ac, \ub3d9\uc2dc\uc131 \uc81c\uc5b4, \uc7a0\uae08(locking) \uc804\ub7b5, C#\uc758 \ube44\ub3d9\uae30 \ud638\ucd9c.”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[241],"tags":[],"class_list":["post-42618","post","type-post","status-publish","format-standard","hentry","category-csharp"],"yoast_head":"\n[C# PL\/SQL] 17.C#\uacfc \uc624\ub77c\ud074 \ud504\ub85c\uc2dc\uc800\ub97c \uc774\uc6a9\ud55c \ub2e4\uc911 \uc0ac\uc6a9\uc790 \ub3d9\uc2dc \ucc98\ub9ac, \ub3d9\uc2dc\uc131 \uc81c\uc5b4, \uc7a0\uae08(locking) \uc804\ub7b5, C#\uc758 \ube44\ub3d9\uae30 \ud638\ucd9c. - \ub77c\uc774\ube0c\uc2a4\ub9c8\ud2b8<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/atmokpo.com\/w\/42618\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[C# PL\/SQL] 17.C#\uacfc \uc624\ub77c\ud074 \ud504\ub85c\uc2dc\uc800\ub97c \uc774\uc6a9\ud55c \ub2e4\uc911 \uc0ac\uc6a9\uc790 \ub3d9\uc2dc \ucc98\ub9ac, \ub3d9\uc2dc\uc131 \uc81c\uc5b4, \uc7a0\uae08(locking) \uc804\ub7b5, C#\uc758 \ube44\ub3d9\uae30 \ud638\ucd9c. - \ub77c\uc774\ube0c\uc2a4\ub9c8\ud2b8\" \/>\n<meta property=\"og:description\" content=\"1. \uc11c\ub860 \uc18c\ud504\ud2b8\uc6e8\uc5b4 \uac1c\ubc1c\uc5d0\uc11c \ub2e4\uc911 \uc0ac\uc6a9\uc790 \ud658\uacbd\uc744 \uc9c0\uc6d0\ud558\ub294 \uac83\uc740 \ub9e4\uc6b0 \uc911\uc694\ud569\ub2c8\ub2e4. \ud2b9\ud788 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \uc0c1\ud638\uc791\uc6a9\ud558\ub294 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc758 \uacbd\uc6b0 \ub2e4\uc218\uc758 \uc0ac\uc6a9\uc790\uac00 \ub3d9\uc2dc\uc5d0 \ub370\uc774\ud130\ub97c \uc870\ud68c\ud558\uac70\ub098 \uc218\uc815\ud560 \uc218 \uc788\uc5b4\uc57c \ud569\ub2c8\ub2e4. \ubcf8 \uae00\uc5d0\uc11c\ub294 C#\uacfc \uc624\ub77c\ud074 ProC(Pro*C) \ud504\ub85c\uc2dc\uc800\ub97c \uc774\uc6a9\ud55c \ub2e4\uc911 \uc0ac\uc6a9\uc790 \ub3d9\uc2dc \ucc98\ub9ac\uc5d0 \ub300\ud574 \ub2e4\ub8e8\uace0, \ub3d9\uc2dc\uc131 \uc81c\uc5b4 \ubc0f \uc7a0\uae08 \uc804\ub7b5\uc744 \uc124\uba85\ud558\uba70, C#\uc758 \ube44\ub3d9\uae30 \ud638\ucd9c \ubc29\uc2dd\uc5d0 \ub300\ud574 \uc790\uc138\ud788 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. 2. \ub2e4\uc911 \uc0ac\uc6a9\uc790 \ub3d9\uc2dc … \ub354 \ubcf4\uae30 "[C# PL\/SQL] 17.C#\uacfc \uc624\ub77c\ud074 \ud504\ub85c\uc2dc\uc800\ub97c \uc774\uc6a9\ud55c \ub2e4\uc911 \uc0ac\uc6a9\uc790 \ub3d9\uc2dc \ucc98\ub9ac, \ub3d9\uc2dc\uc131 \uc81c\uc5b4, \uc7a0\uae08(locking) \uc804\ub7b5, C#\uc758 \ube44\ub3d9\uae30 \ud638\ucd9c."\" \/>\n<meta property=\"og:url\" content=\"https:\/\/atmokpo.com\/w\/42618\/\" \/>\n<meta property=\"og:site_name\" content=\"\ub77c\uc774\ube0c\uc2a4\ub9c8\ud2b8\" \/>\n<meta property=\"article:published_time\" content=\"2024-11-11T03:11:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-11-26T06:34:56+00:00\" \/>\n<meta name=\"author\" content=\"root\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@bebubo4\" \/>\n<meta name=\"twitter:site\" content=\"@bebubo4\" \/>\n<meta name=\"twitter:label1\" content=\"\uae00\uc4f4\uc774\" \/>\n\t<meta name=\"twitter:data1\" content=\"root\" \/>\n\t<meta name=\"twitter:label2\" content=\"\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04\" \/>\n\t<meta name=\"twitter:data2\" content=\"1\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/atmokpo.com\/w\/42618\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/atmokpo.com\/w\/42618\/\"},\"author\":{\"name\":\"root\",\"@id\":\"https:\/\/atmokpo.com\/w\/#\/schema\/person\/91b6b3b138fbba0efb4ae64b1abd81d7\"},\"headline\":\"[C# PL\/SQL] 17.C#\uacfc \uc624\ub77c\ud074 \ud504\ub85c\uc2dc\uc800\ub97c \uc774\uc6a9\ud55c \ub2e4\uc911 \uc0ac\uc6a9\uc790 \ub3d9\uc2dc \ucc98\ub9ac, \ub3d9\uc2dc\uc131 \uc81c\uc5b4, \uc7a0\uae08(locking) \uc804\ub7b5, C#\uc758 \ube44\ub3d9\uae30 \ud638\ucd9c.\",\"datePublished\":\"2024-11-11T03:11:00+00:00\",\"dateModified\":\"2024-11-26T06:34:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/atmokpo.com\/w\/42618\/\"},\"wordCount\":41,\"publisher\":{\"@id\":\"https:\/\/atmokpo.com\/w\/#organization\"},\"articleSection\":[\"csharp\"],\"inLanguage\":\"ko-KR\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/atmokpo.com\/w\/42618\/\",\"url\":\"https:\/\/atmokpo.com\/w\/42618\/\",\"name\":\"[C# PL\/SQL] 17.C#\uacfc \uc624\ub77c\ud074 \ud504\ub85c\uc2dc\uc800\ub97c \uc774\uc6a9\ud55c \ub2e4\uc911 \uc0ac\uc6a9\uc790 \ub3d9\uc2dc \ucc98\ub9ac, \ub3d9\uc2dc\uc131 \uc81c\uc5b4, \uc7a0\uae08(locking) \uc804\ub7b5, C#\uc758 \ube44\ub3d9\uae30 \ud638\ucd9c. - \ub77c\uc774\ube0c\uc2a4\ub9c8\ud2b8\",\"isPartOf\":{\"@id\":\"https:\/\/atmokpo.com\/w\/#website\"},\"datePublished\":\"2024-11-11T03:11:00+00:00\",\"dateModified\":\"2024-11-26T06:34:56+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/atmokpo.com\/w\/42618\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/atmokpo.com\/w\/42618\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/atmokpo.com\/w\/42618\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\ud648\",\"item\":\"https:\/\/atmokpo.com\/w\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[C# PL\/SQL] 17.C#\uacfc \uc624\ub77c\ud074 \ud504\ub85c\uc2dc\uc800\ub97c \uc774\uc6a9\ud55c \ub2e4\uc911 \uc0ac\uc6a9\uc790 \ub3d9\uc2dc \ucc98\ub9ac, \ub3d9\uc2dc\uc131 \uc81c\uc5b4, \uc7a0\uae08(locking) \uc804\ub7b5, C#\uc758 \ube44\ub3d9\uae30 \ud638\ucd9c.\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/atmokpo.com\/w\/#website\",\"url\":\"https:\/\/atmokpo.com\/w\/\",\"name\":\"\ub77c\uc774\ube0c\uc2a4\ub9c8\ud2b8\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/atmokpo.com\/w\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/atmokpo.com\/w\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ko-KR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/atmokpo.com\/w\/#organization\",\"name\":\"\ub77c\uc774\ube0c\uc2a4\ub9c8\ud2b8\",\"url\":\"https:\/\/atmokpo.com\/w\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/atmokpo.com\/w\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/atmokpo.com\/w\/wp-content\/uploads\/2024\/11\/logo.png\",\"contentUrl\":\"https:\/\/atmokpo.com\/w\/wp-content\/uploads\/2024\/11\/logo.png\",\"width\":400,\"height\":400,\"caption\":\"\ub77c\uc774\ube0c\uc2a4\ub9c8\ud2b8\"},\"image\":{\"@id\":\"https:\/\/atmokpo.com\/w\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/x.com\/bebubo4\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/atmokpo.com\/w\/#\/schema\/person\/91b6b3b138fbba0efb4ae64b1abd81d7\",\"name\":\"root\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/atmokpo.com\/w\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/708197b41fc6435a7ce22d951b25d4a47e9e904270cb1f04682d4f025066f80c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/708197b41fc6435a7ce22d951b25d4a47e9e904270cb1f04682d4f025066f80c?s=96&d=mm&r=g\",\"caption\":\"root\"},\"sameAs\":[\"http:\/\/atmokpo.com\/w\"],\"url\":\"https:\/\/atmokpo.com\/w\/author\/root\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[C# PL\/SQL] 17.C#\uacfc \uc624\ub77c\ud074 \ud504\ub85c\uc2dc\uc800\ub97c \uc774\uc6a9\ud55c \ub2e4\uc911 \uc0ac\uc6a9\uc790 \ub3d9\uc2dc \ucc98\ub9ac, \ub3d9\uc2dc\uc131 \uc81c\uc5b4, \uc7a0\uae08(locking) \uc804\ub7b5, C#\uc758 \ube44\ub3d9\uae30 \ud638\ucd9c. - \ub77c\uc774\ube0c\uc2a4\ub9c8\ud2b8","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/atmokpo.com\/w\/42618\/","og_locale":"ko_KR","og_type":"article","og_title":"[C# PL\/SQL] 17.C#\uacfc \uc624\ub77c\ud074 \ud504\ub85c\uc2dc\uc800\ub97c \uc774\uc6a9\ud55c \ub2e4\uc911 \uc0ac\uc6a9\uc790 \ub3d9\uc2dc \ucc98\ub9ac, \ub3d9\uc2dc\uc131 \uc81c\uc5b4, \uc7a0\uae08(locking) \uc804\ub7b5, C#\uc758 \ube44\ub3d9\uae30 \ud638\ucd9c. - \ub77c\uc774\ube0c\uc2a4\ub9c8\ud2b8","og_description":"1. \uc11c\ub860 \uc18c\ud504\ud2b8\uc6e8\uc5b4 \uac1c\ubc1c\uc5d0\uc11c \ub2e4\uc911 \uc0ac\uc6a9\uc790 \ud658\uacbd\uc744 \uc9c0\uc6d0\ud558\ub294 \uac83\uc740 \ub9e4\uc6b0 \uc911\uc694\ud569\ub2c8\ub2e4. \ud2b9\ud788 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \uc0c1\ud638\uc791\uc6a9\ud558\ub294 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc758 \uacbd\uc6b0 \ub2e4\uc218\uc758 \uc0ac\uc6a9\uc790\uac00 \ub3d9\uc2dc\uc5d0 \ub370\uc774\ud130\ub97c \uc870\ud68c\ud558\uac70\ub098 \uc218\uc815\ud560 \uc218 \uc788\uc5b4\uc57c \ud569\ub2c8\ub2e4. \ubcf8 \uae00\uc5d0\uc11c\ub294 C#\uacfc \uc624\ub77c\ud074 ProC(Pro*C) \ud504\ub85c\uc2dc\uc800\ub97c \uc774\uc6a9\ud55c \ub2e4\uc911 \uc0ac\uc6a9\uc790 \ub3d9\uc2dc \ucc98\ub9ac\uc5d0 \ub300\ud574 \ub2e4\ub8e8\uace0, \ub3d9\uc2dc\uc131 \uc81c\uc5b4 \ubc0f \uc7a0\uae08 \uc804\ub7b5\uc744 \uc124\uba85\ud558\uba70, C#\uc758 \ube44\ub3d9\uae30 \ud638\ucd9c \ubc29\uc2dd\uc5d0 \ub300\ud574 \uc790\uc138\ud788 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. 2. \ub2e4\uc911 \uc0ac\uc6a9\uc790 \ub3d9\uc2dc … \ub354 \ubcf4\uae30 \"[C# PL\/SQL] 17.C#\uacfc \uc624\ub77c\ud074 \ud504\ub85c\uc2dc\uc800\ub97c \uc774\uc6a9\ud55c \ub2e4\uc911 \uc0ac\uc6a9\uc790 \ub3d9\uc2dc \ucc98\ub9ac, \ub3d9\uc2dc\uc131 \uc81c\uc5b4, \uc7a0\uae08(locking) \uc804\ub7b5, C#\uc758 \ube44\ub3d9\uae30 \ud638\ucd9c.\"","og_url":"https:\/\/atmokpo.com\/w\/42618\/","og_site_name":"\ub77c\uc774\ube0c\uc2a4\ub9c8\ud2b8","article_published_time":"2024-11-11T03:11:00+00:00","article_modified_time":"2024-11-26T06:34:56+00:00","author":"root","twitter_card":"summary_large_image","twitter_creator":"@bebubo4","twitter_site":"@bebubo4","twitter_misc":{"\uae00\uc4f4\uc774":"root","\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04":"1\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/atmokpo.com\/w\/42618\/#article","isPartOf":{"@id":"https:\/\/atmokpo.com\/w\/42618\/"},"author":{"name":"root","@id":"https:\/\/atmokpo.com\/w\/#\/schema\/person\/91b6b3b138fbba0efb4ae64b1abd81d7"},"headline":"[C# PL\/SQL] 17.C#\uacfc \uc624\ub77c\ud074 \ud504\ub85c\uc2dc\uc800\ub97c \uc774\uc6a9\ud55c \ub2e4\uc911 \uc0ac\uc6a9\uc790 \ub3d9\uc2dc \ucc98\ub9ac, \ub3d9\uc2dc\uc131 \uc81c\uc5b4, \uc7a0\uae08(locking) \uc804\ub7b5, C#\uc758 \ube44\ub3d9\uae30 \ud638\ucd9c.","datePublished":"2024-11-11T03:11:00+00:00","dateModified":"2024-11-26T06:34:56+00:00","mainEntityOfPage":{"@id":"https:\/\/atmokpo.com\/w\/42618\/"},"wordCount":41,"publisher":{"@id":"https:\/\/atmokpo.com\/w\/#organization"},"articleSection":["csharp"],"inLanguage":"ko-KR"},{"@type":"WebPage","@id":"https:\/\/atmokpo.com\/w\/42618\/","url":"https:\/\/atmokpo.com\/w\/42618\/","name":"[C# PL\/SQL] 17.C#\uacfc \uc624\ub77c\ud074 \ud504\ub85c\uc2dc\uc800\ub97c \uc774\uc6a9\ud55c \ub2e4\uc911 \uc0ac\uc6a9\uc790 \ub3d9\uc2dc \ucc98\ub9ac, \ub3d9\uc2dc\uc131 \uc81c\uc5b4, \uc7a0\uae08(locking) \uc804\ub7b5, C#\uc758 \ube44\ub3d9\uae30 \ud638\ucd9c. - \ub77c\uc774\ube0c\uc2a4\ub9c8\ud2b8","isPartOf":{"@id":"https:\/\/atmokpo.com\/w\/#website"},"datePublished":"2024-11-11T03:11:00+00:00","dateModified":"2024-11-26T06:34:56+00:00","breadcrumb":{"@id":"https:\/\/atmokpo.com\/w\/42618\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/atmokpo.com\/w\/42618\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/atmokpo.com\/w\/42618\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\ud648","item":"https:\/\/atmokpo.com\/w\/en\/"},{"@type":"ListItem","position":2,"name":"[C# PL\/SQL] 17.C#\uacfc \uc624\ub77c\ud074 \ud504\ub85c\uc2dc\uc800\ub97c \uc774\uc6a9\ud55c \ub2e4\uc911 \uc0ac\uc6a9\uc790 \ub3d9\uc2dc \ucc98\ub9ac, \ub3d9\uc2dc\uc131 \uc81c\uc5b4, \uc7a0\uae08(locking) \uc804\ub7b5, C#\uc758 \ube44\ub3d9\uae30 \ud638\ucd9c."}]},{"@type":"WebSite","@id":"https:\/\/atmokpo.com\/w\/#website","url":"https:\/\/atmokpo.com\/w\/","name":"\ub77c\uc774\ube0c\uc2a4\ub9c8\ud2b8","description":"","publisher":{"@id":"https:\/\/atmokpo.com\/w\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/atmokpo.com\/w\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ko-KR"},{"@type":"Organization","@id":"https:\/\/atmokpo.com\/w\/#organization","name":"\ub77c\uc774\ube0c\uc2a4\ub9c8\ud2b8","url":"https:\/\/atmokpo.com\/w\/","logo":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/atmokpo.com\/w\/#\/schema\/logo\/image\/","url":"https:\/\/atmokpo.com\/w\/wp-content\/uploads\/2024\/11\/logo.png","contentUrl":"https:\/\/atmokpo.com\/w\/wp-content\/uploads\/2024\/11\/logo.png","width":400,"height":400,"caption":"\ub77c\uc774\ube0c\uc2a4\ub9c8\ud2b8"},"image":{"@id":"https:\/\/atmokpo.com\/w\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/bebubo4"]},{"@type":"Person","@id":"https:\/\/atmokpo.com\/w\/#\/schema\/person\/91b6b3b138fbba0efb4ae64b1abd81d7","name":"root","image":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/atmokpo.com\/w\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/708197b41fc6435a7ce22d951b25d4a47e9e904270cb1f04682d4f025066f80c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/708197b41fc6435a7ce22d951b25d4a47e9e904270cb1f04682d4f025066f80c?s=96&d=mm&r=g","caption":"root"},"sameAs":["http:\/\/atmokpo.com\/w"],"url":"https:\/\/atmokpo.com\/w\/author\/root\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/atmokpo.com\/w\/wp-json\/wp\/v2\/posts\/42618","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/atmokpo.com\/w\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/atmokpo.com\/w\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/atmokpo.com\/w\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/atmokpo.com\/w\/wp-json\/wp\/v2\/comments?post=42618"}],"version-history":[{"count":2,"href":"https:\/\/atmokpo.com\/w\/wp-json\/wp\/v2\/posts\/42618\/revisions"}],"predecessor-version":[{"id":42807,"href":"https:\/\/atmokpo.com\/w\/wp-json\/wp\/v2\/posts\/42618\/revisions\/42807"}],"wp:attachment":[{"href":"https:\/\/atmokpo.com\/w\/wp-json\/wp\/v2\/media?parent=42618"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/atmokpo.com\/w\/wp-json\/wp\/v2\/categories?post=42618"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/atmokpo.com\/w\/wp-json\/wp\/v2\/tags?post=42618"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}