{"id":99243,"date":"2025-02-27T02:31:50","date_gmt":"2025-02-26T23:01:50","guid":{"rendered":"https:\/\/nabfollower.com\/blog\/%d8%ac%d9%85%d8%b9-%d8%a2%d9%88%d8%b1%db%8c-%d9%88-%d9%be%db%8c%d8%b4-%d8%a8%db%8c%d9%86%db%8c-%d8%af%d8%b1-%f0%9f%8e%afpl-sql-%da%86%db%8c%d8%b3%d8%aa%d8%9f-%da%86%d9%87-%d8%b2%d9%85%d8%a7%d9%86\/"},"modified":"2025-02-27T02:31:50","modified_gmt":"2025-02-26T23:01:50","slug":"%d8%ac%d9%85%d8%b9-%d8%a2%d9%88%d8%b1%db%8c-%d9%88-%d9%be%db%8c%d8%b4-%d8%a8%db%8c%d9%86%db%8c-%d8%af%d8%b1-%f0%9f%8e%afpl-sql-%da%86%db%8c%d8%b3%d8%aa%d8%9f-%da%86%d9%87-%d8%b2%d9%85%d8%a7%d9%86","status":"publish","type":"post","link":"https:\/\/nabfollower.com\/blog\/%d8%ac%d9%85%d8%b9-%d8%a2%d9%88%d8%b1%db%8c-%d9%88-%d9%be%db%8c%d8%b4-%d8%a8%db%8c%d9%86%db%8c-%d8%af%d8%b1-%f0%9f%8e%afpl-sql-%da%86%db%8c%d8%b3%d8%aa%d8%9f-%da%86%d9%87-%d8%b2%d9%85%d8%a7%d9%86\/","title":{"rendered":"\u062c\u0645\u0639 \u0622\u0648\u0631\u06cc \u0648 \u067e\u06cc\u0634 \u0628\u06cc\u0646\u06cc \u062f\u0631 \ud83c\udfafpl\/sql \u0686\u06cc\u0633\u062a\u061f \u0686\u0647 \u0632\u0645\u0627\u0646\u06cc \u0627\u0632 \u0622\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f\u061f"},"content":{"rendered":"<div data-article-id=\"2299850\" id=\"article-body\">\n<p>\u062c\u0645\u0639 \u0622\u0648\u0631\u06cc \u0648 \u067e\u06cc\u0634\u0631\u0648 \u062f\u0631 PL\/SQL \u0686\u06cc\u0633\u062a\u061f \u0686\u0647 \u0632\u0645\u0627\u0646\u06cc \u0627\u0632 \u0622\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f\u061f<\/p>\n<p>\u0647\u0646\u06af\u0627\u0645 \u06a9\u0627\u0631 \u0628\u0631 \u0631\u0648\u06cc \u0645\u062c\u0645\u0648\u0639\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0628\u0632\u0631\u06af \u0628\u0627 PL\/SQL \u060c \u0645\u06cc \u062a\u0648\u0627\u0646 \u0627\u0632 \u062c\u0645\u0639 \u0622\u0648\u0631\u06cc \u0641\u0644\u0647 \u0648 \u067e\u06cc\u0634\u0627\u0646\u06cc \u0628\u0631\u0627\u06cc \u0628\u0647\u0628\u0648\u062f \u0639\u0645\u0644\u06a9\u0631\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0631\u062f. \u0627\u06cc\u0646 \u0633\u0627\u062e\u062a\u0627\u0631\u0647\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0641\u0631\u0622\u06cc\u0646\u062f \u062f\u0627\u062f\u0647 \u062c\u0645\u0639\u06cc \u0628\u0647 \u062c\u0627\u06cc \u067e\u0631\u062f\u0627\u0632\u0634 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u062e\u0637 \u060c \u0647\u0632\u06cc\u0646\u0647 \u0647\u0627\u06cc CPU \u0648 I\/O \u0631\u0627 \u06a9\u0627\u0647\u0634 \u0645\u06cc \u062f\u0647\u0646\u062f.<\/p>\n<p>\u062f\u0631 \u0645\u0635\u0627\u062d\u0628\u0647 PL\/SQL \u060c &#8220;\u0686\u0647 \u0641\u0644\u0647 \u0627\u06cc \u062c\u0645\u0639 \u0622\u0648\u0631\u06cc \u0648 \u0627\u0632 \u0628\u06cc\u0646 \u0645\u06cc \u0631\u0648\u062f\u061f \u0686\u0647 \u0632\u0645\u0627\u0646\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f\u061f \u060c \u062a\u0641\u0627\u0648\u062a \u062f\u0631 \u0639\u0645\u0644\u06a9\u0631\u062f \u0686\u06cc\u0633\u062a\u061f&#8221; \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0628\u0627 \u0633\u0624\u0627\u0644\u0627\u062a\u06cc \u0645\u0627\u0646\u0646\u062f.<\/p>\n<p>\u062f\u0631 \u0627\u06cc\u0646 \u0645\u0642\u0627\u0644\u0647 \u060c \u0645\u0627 \u0628\u0631\u0631\u0633\u06cc \u062e\u0648\u0627\u0647\u06cc\u0645 \u06a9\u0631\u062f \u06a9\u0647 \u062c\u0645\u0639 \u0622\u0648\u0631\u06cc \u0648 \u067e\u06cc\u0634 \u0628\u06cc\u0646\u06cc \u0647\u0627\u06cc \u0641\u0644\u0647 \u060c \u0646\u062d\u0648\u0647 \u0639\u0645\u0644\u06a9\u0631\u062f \u0622\u0646 \u0648 \u062a\u0623\u062b\u06cc\u0631 \u0639\u0645\u0644\u06a9\u0631\u062f \u0686\u06cc\u0633\u062a.<\/p>\n<ol>\n<li>\u062c\u0645\u0639 \u0622\u0648\u0631\u06cc \u0648 \u067e\u06cc\u0634 \u0628\u06cc\u0646\u06cc \u0641\u0644\u0647 \u0686\u06cc\u0633\u062a\u061f<\/li>\n<\/ol>\n<p>collect \u062c\u0645\u0639 \u0622\u0648\u0631\u06cc \u0641\u0644\u0647: \u062a\u0639\u062f\u0627\u062f \u0632\u06cc\u0627\u062f\u06cc \u0627\u0632 \u062e\u0637\u0648\u0637 \u0631\u0627 \u0628\u0647 \u0635\u0648\u0631\u062a \u062c\u0645\u0639\u06cc \u0628\u0647 \u06cc\u06a9 \u0645\u062c\u0645\u0648\u0639\u0647 (\u0622\u0631\u0627\u06cc\u0647) \u062c\u0630\u0628 \u0645\u06cc \u06a9\u0646\u062f.<br \/>\ud83d\udccc Forel: \u062a\u0645\u0627\u0645 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u062f\u0631 \u06cc\u06a9 \u0645\u062c\u0645\u0648\u0639\u0647 \u0628\u0627 \u06cc\u06a9 \u0641\u0631\u0622\u06cc\u0646\u062f DML (\u062f\u0631\u062c \u060c \u0628\u0631\u0648\u0632\u0631\u0633\u0627\u0646\u06cc \u060c \u062d\u0630\u0641) \u0628\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u0631\u0633\u0627\u0644 \u0645\u06cc \u06a9\u0646\u062f.<\/p>\n<p>\u0627\u06cc\u0646 \u062f\u0648 \u0633\u0627\u062e\u062a\u0627\u0631 \u0628\u0627 \u062a\u0628\u062f\u06cc\u0644 \u0631\u0648\u06cc\u06a9\u0631\u062f \u067e\u0631\u062f\u0627\u0632\u0634 \u0645\u0628\u062a\u0646\u06cc \u0628\u0631 \u062e\u0637 PL\/SQL \u0628\u0647 \u067e\u0631\u062f\u0627\u0632\u0634 \u062c\u0645\u0639\u06cc \u060c \u0628\u0647\u0631\u0647 \u0648\u0631\u06cc \u0631\u0627 \u0627\u0641\u0632\u0627\u06cc\u0634 \u0645\u06cc \u062f\u0647\u0646\u062f.<\/p>\n<ol>\n<li>\u062c\u0645\u0639 \u0622\u0648\u0631\u06cc \u0627\u0646\u0628\u0648\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647<\/li>\n<\/ol>\n<p>\u062c\u0645\u0639 \u0622\u0648\u0631\u06cc \u0641\u0644\u0647 \u062f\u0631 \u0639\u0645\u0644\u06cc\u0627\u062a \u062e\u0648\u0627\u0646\u062f\u0646 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f. \u0628\u0647 \u062c\u0627\u06cc \u062e\u0648\u0627\u0646\u062f\u0646 \u06cc\u06a9 \u0631\u062f\u06cc\u0641 \u060c \u062a\u0645\u0627\u0645 \u062e\u0637\u0648\u0637 \u0631\u0627 \u0628\u0647 \u0635\u0648\u0631\u062a \u062c\u0645\u0639\u06cc \u0628\u0627\u0631\u06af\u0630\u0627\u0631\u06cc \u0645\u06cc \u06a9\u0646\u062f.<\/p>\n<p>\u0645\u0631\u0627\u062d\u0644 \u0627\u0633\u062a\u0641\u0627\u062f\u0647:<br \/>1\u20e3 \u0645\u062c\u0645\u0648\u0639\u0647 \u062a\u0639\u0631\u06cc\u0641 \u0634\u062f\u0647 \u0627\u0633\u062a (\u0646\u0648\u0639 &#8230; \u062c\u062f\u0648\u0644 &#8230;)<br \/>2\u20e3 \u0641\u0644\u0647 \u0631\u0627 \u062c\u0645\u0639 \u0622\u0648\u0631\u06cc \u0648 \u0646\u062a\u06cc\u062c\u0647 \u0631\u0627 \u062a\u0627 \u0645\u062c\u0645\u0648\u0639\u0647 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f<br \/>3\u20e3 \u0641\u0631\u0622\u06cc\u0646\u062f \u0633\u0631\u06cc\u0639\u062a\u0631 \u0627\u0646\u062c\u0627\u0645 \u0645\u06cc \u0634\u0648\u062f<br \/>\ud83d\udd39 \u062c\u0645\u0639 \u0622\u0648\u0631\u06cc \u0641\u0644\u0647 &#8211; \u0645\u062b\u0627\u0644<\/p>\n<p><code>DECLARE<br \/>TYPE t_hasta IS TABLE OF hastalar%ROWTYPE;  -- Koleksiyon t\u00fcr\u00fc tan\u0131mla<br \/>v_hastalar t_hasta;  -- Koleksiyon de\u011fi\u015fkeni<br \/>BEGIN<br \/>-- BULK COLLECT ile toplu veri \u00e7ekme<br \/>SELECT * BULK COLLECT INTO v_hastalar FROM hastalar;<br \/>-- Koleksiyon i\u00e7indeki verileri i\u015fleme<br \/>FOR i IN 1 .. v_hastalar.COUNT LOOP<br \/>DBMS_OUTPUT.PUT_LINE(v_hastalar(i).ad || ' ' || v_hastalar(i).soyad);<br \/>END LOOP;<br \/>END;<\/code><\/p>\n<p>\ud83d\udccc \u062a\u0648\u0636\u06cc\u062d\u0627\u062a:<br \/>\u2714 \u062c\u0645\u0639 \u0622\u0648\u0631\u06cc \u0641\u0644\u0647 \u062f\u0631 \u2192 \u0647\u0645\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u062f\u0631 \u0645\u062c\u0645\u0648\u0639\u0647 \u0628\u0627\u0631\u06af\u0630\u0627\u0631\u06cc \u0645\u06cc \u06a9\u0646\u062f.<br \/>\u2714 v_hastalar.count \u2192 \u0646\u0634\u0627\u0646 \u0645\u06cc \u062f\u0647\u062f \u06a9\u0647 \u0686\u0646\u062f \u062e\u0637 \u0628\u0627\u0631\u06af\u06cc\u0631\u06cc \u0645\u06cc \u0634\u0648\u0646\u062f.<br \/>\u2714 \u0633\u0631\u06cc\u0639\u062a\u0631 \u06a9\u0627\u0631 \u0645\u06cc \u06a9\u0646\u062f \u0632\u06cc\u0631\u0627 \u0628\u0647 \u0635\u0648\u0631\u062a \u062c\u062f\u0627\u06af\u0627\u0646\u0647 \u0627\u0646\u062c\u0627\u0645 \u0646\u0645\u06cc \u0634\u0648\u062f.<\/p>\n<ol>\n<li>\u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 forll<\/li>\n<\/ol>\n<p>Forall \u0628\u0631\u0627\u06cc \u0633\u0631\u0639\u062a \u0628\u062e\u0634\u06cc\u062f\u0646 \u0628\u0647 \u0639\u0645\u0644\u06cc\u0627\u062a DML (\u062f\u0631\u062c \u060c \u0628\u0647 \u0631\u0648\u0632\u0631\u0633\u0627\u0646\u06cc \u060c \u062d\u0630\u0641) \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f.<br \/>\u0628\u0647 \u062c\u0627\u06cc \u0627\u0646\u062c\u0627\u0645 \u0639\u0645\u0644\u06cc\u0627\u062a DML \u062f\u0631 \u0647\u0631 \u062e\u0637 \u0628\u0627 \u062d\u0644\u0642\u0647 \u0645\u0639\u0645\u0648\u0644\u06cc \u060c \u06a9\u0644 \u0645\u062c\u0645\u0648\u0639\u0647 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06cc\u06a9 \u0641\u0631\u0622\u06cc\u0646\u062f \u0648\u0627\u062d\u062f \u0628\u0647 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0627\u0631\u0633\u0627\u0644 \u0645\u06cc \u0634\u0648\u062f.<\/p>\n<p>\u0645\u0631\u0627\u062d\u0644 \u0627\u0633\u062a\u0641\u0627\u062f\u0647:<br \/>1\u20e3 \u0645\u062c\u0645\u0648\u0639\u0647 \u062a\u0639\u0631\u06cc\u0641 \u0634\u062f\u0647 \u0627\u0633\u062a<br \/>2\u20e3 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u062c\u0645\u0639 \u0622\u0648\u0631\u06cc \u0628\u0627 FORTL \u067e\u0631\u062f\u0627\u0632\u0634 \u0645\u06cc \u0634\u0648\u0646\u062f<br \/>\ud83d\udd39 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0642\u0644\u0639\u0647 &#8211; \u0645\u062b\u0627\u0644 (\u0641\u0631\u0622\u06cc\u0646\u062f \u062f\u0631\u062c \u062c\u0645\u0639\u06cc)<\/p>\n<p><code>DECLARE<br \/>TYPE t_hasta IS TABLE OF hastalar%ROWTYPE;  <br \/>v_hastalar t_hasta;<br \/>BEGIN<br \/>-- BULK COLLECT ile hastalar\u0131 koleksiyona al<br \/>SELECT * BULK COLLECT INTO v_hastalar FROM hastalar WHERE id &lt; 100;<br \/>-- FORALL ile yeni tabloya toplu ekleme<br \/>FORALL i IN 1 .. v_hastalar.COUNT<br \/>INSERT INTO hastalar_yedek VALUES v_hastalar(i);<br \/>COMMIT;<br \/>END;<\/code><\/p>\n<p>\ud83d\udccc \u062a\u0648\u0636\u06cc\u062d\u0627\u062a:<br \/>\u2714 forll&#39;s 1. v_hastalar.<br \/>\u2714 \u0628\u0631\u0627\u06cc \u0647\u0631 \u062e\u0637 \u062c\u062f\u0627\u06af\u0627\u0646\u0647 \u0627\u062c\u0631\u0627 \u0646\u0645\u06cc \u0634\u0648\u062f \u060c \u06cc\u06a9\u0628\u0627\u0631\u0647 \u06a9\u0627\u0631 \u0645\u06cc \u06a9\u0646\u062f.<br \/>\u2714 \u0639\u0645\u0644\u06a9\u0631\u062f \u0631\u0627 \u0628\u0647\u0628\u0648\u062f \u0645\u06cc \u0628\u062e\u0634\u062f \u0632\u06cc\u0631\u0627 \u0627\u0646\u062a\u0642\u0627\u0644 \u0627\u0632 \u0645\u0648\u062a\u0648\u0631 PL\/SQL \u0628\u0647 SQL \u0631\u0627 \u06a9\u0627\u0647\u0634 \u0645\u06cc \u062f\u0647\u062f.<\/p>\n<ol>\n<li>\u062c\u0645\u0639 \u0622\u0648\u0631\u06cc \u0641\u0644\u0647 \u0648 \u0645\u0642\u0627\u06cc\u0633\u0647 \u0639\u0645\u0644\u06a9\u0631\u062f \u0634\u0631\u0648\u0631<\/li>\n<\/ol>\n<p><img decoding=\"async\" src=\"https:\/\/media2.dev.to\/dynamic\/image\/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto\/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fewvafi086wg5o237f7b9.png\" alt=\"\u0634\u0631\u062d \u062a\u0635\u0648\u06cc\u0631\" loading=\"lazy\" width=\"735\" height=\"172\" title=\"\"><\/p>\n<p>\ud83d\udce2 \u0686\u0631\u0627 \u0633\u0631\u06cc\u0639\u062a\u0631\u061f<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight plaintext\"><code>Normal FOR LOOP i\u00e7inde SELECT yap\u0131ld\u0131\u011f\u0131nda, her sat\u0131r i\u00e7in SQL motoruna gidip geliriz.\nBULK COLLECT ile tek seferde veri \u00e7ekilir.\nFORALL ile tek seferde DML i\u015flemi yap\u0131l\u0131r.\nBu sayede, PL\/SQL ve SQL motoru aras\u0131ndaki ba\u011flat\u0131lar azal\u0131r ve performans artar. \ud83d\ude80\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<ol>\n<li>\u0633\u0648\u0627\u0644\u0627\u062a \u0645\u0631\u0628\u0648\u0637 \u0628\u0647 \u062c\u0645\u0639 \u0622\u0648\u0631\u06cc \u0648 \u067e\u06cc\u0634 \u0628\u06cc\u0646\u06cc \u062f\u0631 \u0645\u0635\u0627\u062d\u0628\u0647 \u0647\u0627\u06cc PL\/SQL<\/li>\n<\/ol>\n<p>\u062f\u0631 \u0645\u0635\u0627\u062d\u0628\u0647 \u0647\u0627\u06cc PL\/SQL \u060c \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0628\u0627 \u0633\u0624\u0627\u0644\u0627\u062a \u0632\u06cc\u0631 \u062f\u0631 \u0645\u0648\u0631\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062c\u0645\u0639 \u0622\u0648\u0631\u06cc \u0641\u0644\u0647 \u0648 \u067e\u06cc\u0634 \u0628\u06cc\u0646\u06cc \u0634\u062f\u0647 \u0631\u0648\u0628\u0631\u0648 \u0634\u0648\u06cc\u062f:<br \/>\u0633\u0648\u0627\u0644 1: \u062a\u0641\u0627\u0648\u062a \u0641\u0644\u0647 \u0648 \u062a\u0641\u0627\u0648\u062a Forall \u0686\u06cc\u0633\u062a\u061f<\/p>\n<p>\u067e\u0627\u0633\u062e:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight plaintext\"><code>BULK COLLECT, toplu veri okumak i\u00e7in kullan\u0131l\u0131r.\nFORALL, toplu veri yazmak i\u00e7in kullan\u0131l\u0131r.\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0633\u0648\u0627\u0644 2: \u0645\u0632\u06cc\u062a \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062c\u0645\u0639 \u0622\u0648\u0631\u06cc \u0641\u0644\u0647 \u0686\u06cc\u0633\u062a\u061f<\/p>\n<p>\u067e\u0627\u0633\u062e:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight plaintext\"><code>Tek tek FETCH yapmak yerine, t\u00fcm veriyi bir koleksiyona al\u0131r.\nPL\/SQL ve SQL motoru aras\u0131ndaki ileti\u015fimi azaltarak performans\u0131 art\u0131r\u0131r.\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0633\u0648\u0627\u0644 3: \u0686\u0631\u0627 \u0628\u0627\u06cc\u062f \u0628\u0647 \u062c\u0627\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 Fancel \u060c \u062d\u0644\u0642\u0647 \u0631\u0627 \u062a\u0631\u062c\u06cc\u062d \u062f\u0647\u06cc\u0645\u061f<\/p>\n<p>\u067e\u0627\u0633\u062e:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight plaintext\"><code>FOR LOOP i\u00e7inde DML i\u015flemi her sat\u0131r i\u00e7in tek tek \u00e7al\u0131\u015f\u0131r.\nFORALL ise t\u00fcm i\u015flemi SQL motoruna tek seferde g\u00f6nderir, bu da performans\u0131 art\u0131r\u0131r.\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<ol>\n<li>\u062c\u0645\u0639 \u0622\u0648\u0631\u06cc \u0648 \u0641\u0644\u0647 \u0627\u06cc \u06a9\u0647 \u0647\u0646\u06af\u0627\u0645 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u062f\u0631 \u0646\u0638\u0631 \u0645\u06cc \u06af\u06cc\u0631\u062f<\/li>\n<\/ol>\n<p>\ud83d\udccc \u0647\u0646\u06af\u0627\u0645 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062c\u0645\u0639 \u0622\u0648\u0631\u06cc \u0641\u0644\u0647:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight plaintext\"><code>\u00c7ok b\u00fcy\u00fck veri setleri bellekte fazla yer kaplayabilir!\n\u00c7ekilecek veri miktar\u0131na g\u00f6re LIMIT kullanabilirsin.\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>Fetch cursor_adi \u0641\u0644\u0647 \u062c\u0645\u0639 \u0622\u0648\u0631\u06cc \u062f\u0631 Collection_Name Limit 1000 \u061b<\/p>\n<p>\ud83d\udccc \u0647\u0646\u06af\u0627\u0645 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 Fortal:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight plaintext\"><code>S\u0131ral\u0131 bir koleksiyon kullan\u0131lmal\u0131d\u0131r.\nE\u011fer bir hata olursa, t\u00fcm i\u015flemler iptal olur.\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p><code>FORALL i IN 1 .. v_hastalar.COUNT SAVE EXCEPTIONS<br \/>INSERT INTO hastalar_yedek VALUES v_hastalar(i);<\/code><\/p>\n<p>\ud83d\udce2 \u0634\u0645\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0627\u0633\u062a\u062b\u0646\u0627\u0626\u0627\u062a \u0630\u062e\u06cc\u0631\u0647 \u0627\u0634\u062a\u0628\u0627\u0647\u0627\u062a \u0631\u0627 \u0636\u0628\u0637 \u06a9\u0646\u06cc\u062f!<\/p>\n<ol>\n<li>\u067e\u0627\u06cc\u0627\u0646<\/li>\n<\/ol>\n<p>\u0628\u0647 \u0637\u0648\u0631 \u062e\u0644\u0627\u0635\u0647:<br \/>\u2705 \u062c\u0645\u0639 \u0622\u0648\u0631\u06cc \u0641\u0644\u0647 \u0628\u0631\u0627\u06cc \u062e\u0648\u0627\u0646\u062f\u0646 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u062c\u0645\u0639\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f.<br \/>forll \u0628\u0631\u0627\u06cc \u0646\u0648\u0634\u062a\u0646 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u062c\u0645\u0639\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f.<br \/>\u2705 \u0628\u0627 \u06a9\u0627\u0647\u0634 \u0639\u0645\u0644\u06cc\u0627\u062a \u063a\u06cc\u0631 \u0636\u0631\u0648\u0631\u06cc \u0628\u06cc\u0646 PL\/SQL \u0648 SQL \u0645\u0648\u062a\u0648\u0631 \u060c \u0639\u0645\u0644\u06a9\u0631\u062f \u0631\u0627 \u0628\u0647\u0628\u0648\u062f \u0645\u06cc \u0628\u062e\u0634\u062f.<\/p>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u062c\u0645\u0639 \u0622\u0648\u0631\u06cc \u0648 \u067e\u06cc\u0634\u0631\u0648 \u062f\u0631 PL\/SQL \u0686\u06cc\u0633\u062a\u061f \u0686\u0647 \u0632\u0645\u0627\u0646\u06cc \u0627\u0632 \u0622\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f\u061f \u0647\u0646\u06af\u0627\u0645 \u06a9\u0627\u0631 \u0628\u0631 \u0631\u0648\u06cc \u0645\u062c\u0645\u0648\u0639\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0628\u0632\u0631\u06af \u0628\u0627 PL\/SQL \u060c \u0645\u06cc \u062a\u0648\u0627\u0646 \u0627\u0632 \u062c\u0645\u0639 \u0622\u0648\u0631\u06cc \u0641\u0644\u0647 \u0648 \u067e\u06cc\u0634\u0627\u0646\u06cc \u0628\u0631\u0627\u06cc \u0628\u0647\u0628\u0648\u062f \u0639\u0645\u0644\u06a9\u0631\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0631\u062f. \u0627\u06cc\u0646 \u0633\u0627\u062e\u062a\u0627\u0631\u0647\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0641\u0631\u0622\u06cc\u0646\u062f \u062f\u0627\u062f\u0647 \u062c\u0645\u0639\u06cc \u0628\u0647 \u062c\u0627\u06cc \u067e\u0631\u062f\u0627\u0632\u0634 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u062e\u0637 \u060c \u0647\u0632\u06cc\u0646\u0647 \u0647\u0627\u06cc &hellip;<\/p>\n","protected":false},"author":2,"featured_media":99244,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/media2.dev.to\/dynamic\/image\/width=1000,height=500,fit=cover,gravity=auto,format=auto\/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fgsuvrobp0i8alpajl1c9.png","fifu_image_alt":"","footnotes":""},"categories":[339],"tags":[],"class_list":["post-99243","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dev"],"_links":{"self":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/99243","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/comments?post=99243"}],"version-history":[{"count":0,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/99243\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media\/99244"}],"wp:attachment":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media?parent=99243"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/categories?post=99243"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/tags?post=99243"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}