{"id":2806,"date":"2026-04-30T16:57:54","date_gmt":"2026-04-30T08:57:54","guid":{"rendered":"https:\/\/tekno.bali-island.com\/?p=2806"},"modified":"2026-04-30T16:57:58","modified_gmt":"2026-04-30T08:57:58","slug":"penjelasan-prosedur-tersimpan-dan-kursor-pada-pangkalan-data","status":"publish","type":"post","link":"https:\/\/tekno.bali-island.com\/ms\/articles\/penjelasan-prosedur-tersimpan-dan-kursor-pada-pangkalan-data\/","title":{"rendered":"Penjelasan Prosedur Tersimpan dan Kursor pada Pangkalan Data"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\"><strong>Prosedur Tersimpan (Stored Procedure)<\/strong><\/h2>\n\n\n\n<p>Prosedur tersimpan merupakan kumpulan perintah-perintah SQL atau boleh dikatakan sebagai sub program dengan nama tertentu yang disimpan pada pangkalan data. Proses yang dilakukan prosedur tersimpan ialah menerima input parameter dan kemudian mengembalikan nilai-nilai dalam bentuk parameter output kepada pemanggilnya serta melakukan operasi pemprosesan data pada pangkalan data yang dijalankan oleh suatu program seperti pencetus (trigger) atau prosedur tersimpan yang lain. Penggunaan prosedur tersimpan mempunyai kelebihan, iaitu<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Meningkatkan prestasi pada aplikasi, kerana prosedur tersimpan yang telah dibuat berjalan lebih cepat daripada perintah SQL yang dihantar aplikasi dan belum dikompilasi,<\/li>\n\n\n\n<li>Menurunkan trafik rangkaian dari pangkalan data dan aplikasi, kerana tidak perlu menghantar SQL yang belum dikompilasi,<\/li>\n\n\n\n<li>Dapat digunakan secara berulang dan telus pada semua aplikasi.<\/li>\n<\/ul>\n\n\n\n<p>Walaupun demikian, penggunaan prosedur tersimpan juga terdapat kelemahan, iaitu<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Tidak dapat dilakukan debug,<\/li>\n\n\n\n<li>Membebankan perkakasan pelayan bertambah,<\/li>\n\n\n\n<li>Penulisannya tidak mudah dan memerlukan pengetahuan yang spesifik.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Sintaks pada Prosedur Tersimpan<\/strong><\/h3>\n\n\n\n<p>Sintaks yang terdapat pada prosedur tersimpan<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Sintaks penulisan prosedur tersimpan<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">DELIMITER \/\/\n\nCREATE PROCEDURE nama_prosedur()\n\nBEGIN\n\npertanyaan sql\n\nEND \/\/\n\nDELIMITER ;<\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Sintaks memanggil prosedur tersimpan<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">CALL nama_prosedur()<\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Sintaks deklarasi pemboleh ubah prosedur tersimpan<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">DECLARE nama_pembolehubah jenisdatapanjang) DEFAULT nilai;<\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Sintaks prosedur tersimpan dengan parameter<\/li>\n<\/ul>\n\n\n\n<p>Terdapat tiga mode untuk parameternya iaitu<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>IN, iaitu bentuk default parameter yang mana semua perubahan pada prosedur tersimpan tidak akan mempengaruhi parameter<\/li>\n\n\n\n<li>OUT, iaitu mode yang akan mengubah nilai parameter lalu menghantar balik kepada pemanggilnya<\/li>\n\n\n\n<li>INOUT, iaitu mode gabungan IN dan OUT.<\/li>\n<\/ul>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>Contoh sintaks mendefinisikan prosedur tersimpan dengan parameter :<\/p>\n\n\n\n<p><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">DELIMITER \/\/\n\nCREATE PROCEDURE nama_prosedur([mode] [parameter]\n[jenis_data])\n\nBEGIN\n\npertanyaan sql\n\nEND \/\/\n\nDELIMITER ;<\/pre>\n\n\n\n<p>Contoh sintaks memanggil prosedur tersimpan dengan parameter :<\/p>\n\n\n\n<p><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">CALL nama_prosedur([nilai_parameter])<\/pre>\n<\/blockquote>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Kursor<\/strong><\/h2>\n\n\n\n<p>Kursor merupakan objek pada pangkalan data yang digunakan untuk menampung pemprosesan pernyataan SQL yang bersifat spesifik atau boleh dikatakan sebagai pemboleh ubah penampung hasil pertanyaan yang mengandungi lebih daripada satu baris atau rekod. Kursor dapat melakukan lelaran sebanyak baris data pada jadual. Terdapat beberapa sifat kursor, iaitu :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Tidak dapat dilakukan kemas kini (hanya baca)<\/li>\n\n\n\n<li>Kursor hanya berjalan pada satu arah (tidak boleh skrol)<\/li>\n\n\n\n<li>Tidak disarankan untuk melakukan kemas kini pada jadual yang dirujuk oleh kursor kerana dapat memberikan hasil yang tidak diingini (asensitif)<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Sintaks pada Prosedur Tersimpan (untuk Kursor)<\/strong><\/h3>\n\n\n\n<p>Sintaks yang terdapat pada kursor<\/p>\n\n\n\n<p>Pada kursor terdapat beberapa tahap dalam pembuatannya iaitu :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Declare, iaitu tahap untuk mendeklarasikan kursor, dengan sintaksnya :<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">DECLARE nama_kursor CURSOR FOR\npernyataan_SELECT;<\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Open, iaitu tahap membuka atau mengaktifkan kursor, dengan sintaksnya :<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">OPEN nama_kursor;<\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Fetch, iaitu tahap mengambil data dari kursor dan kemudian menampungnya pada sebuah pemboleh ubah, dengan sintaksnya :<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">FETCH nama_kursor INTO senarai_pembolehubah<\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Close, iaitu tahap untuk menonaktifkan kursor, dengan sintaksnya :<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">CLOSE nama_kursor<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Perbezaan Prosedur Tersimpan dan Kursor<\/strong><\/h2>\n\n\n\n<p>Perbezaan prosedur tersimpan dengan kursor adalah prosedur tersimpan hanya menampung perintah-perintah deklarasi dari MySQL manakala kursor menampung hasil pertanyaan sekaligus sebagai penunjuk (pointer) kepada hasil pertanyaan tersebut. Hal ini membolehkan kursor melakukan perintah yang kompleks yang tidak dapat dilakukan oleh prosedur tersimpan. Salah satunya adalah melakukan lelaran pada rekod.<\/p>\n\n\n\n<p><br><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Prosedur Tersimpan (Stored Procedure) Prosedur tersimpan merupakan kumpulan perintah-perintah SQL atau boleh dikatakan sebagai sub program dengan nama tertentu yang disimpan pada pangkalan data. Proses yang dilakukan prosedur tersimpan ialah menerima input parameter dan kemudian mengembalikan nilai-nilai dalam bentuk parameter output kepada pemanggilnya serta melakukan operasi pemprosesan data pada pangkalan data yang dijalankan oleh suatu program seperti pencetus (trigger) atau prosedur tersimpan yang lain. Penggunaan prosedur tersimpan mempunyai kelebihan, iaitu Walaupun demikian, penggunaan prosedur tersimpan juga terdapat kelemahan, iaitu Sintaks pada Prosedur Tersimpan Sintaks yang terdapat pada prosedur tersimpan DELIMITER \/\/ CREATE PROCEDURE nama_prosedur() BEGIN pertanyaan sql END \/\/ DELIMITER ; CALL nama_prosedur() DECLARE nama_pembolehubah jenisdatapanjang) DEFAULT nilai; Terdapat tiga mode untuk parameternya iaitu Contoh sintaks mendefinisikan prosedur tersimpan dengan parameter : DELIMITER \/\/ CREATE PROCEDURE nama_prosedur([mode] [parameter] [jenis_data]) BEGIN pertanyaan sql END \/\/ DELIMITER ; Contoh sintaks memanggil prosedur tersimpan dengan parameter : CALL nama_prosedur([nilai_parameter]) Kursor Kursor merupakan objek pada pangkalan data yang digunakan untuk menampung pemprosesan pernyataan SQL yang bersifat spesifik atau boleh dikatakan sebagai pemboleh ubah penampung hasil pertanyaan yang mengandungi lebih daripada satu baris atau rekod. Kursor dapat melakukan lelaran sebanyak baris data pada jadual. Terdapat beberapa sifat kursor, iaitu : Sintaks pada Prosedur Tersimpan (untuk &hellip;<\/p>\n","protected":false},"author":1,"featured_media":2790,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[99],"tags":[],"class_list":["post-2806","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-programming"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Penjelasan Prosedur Tersimpan dan Kursor pada Pangkalan Data<\/title>\n<meta name=\"description\" content=\"Penjelasan lengkap mengenai prosedur tersimpan dan kursor, mulai dari pengertian, contoh sintaks dan perbezaan keduanya.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/tekno.bali-island.com\/ms\/articles\/penjelasan-prosedur-tersimpan-dan-kursor-pada-pangkalan-data\/\" \/>\n<meta property=\"og:locale\" content=\"ms_MY\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Penjelasan Prosedur Tersimpan dan Kursor pada Pangkalan Data\" \/>\n<meta property=\"og:description\" content=\"Penjelasan lengkap mengenai prosedur tersimpan dan kursor, mulai dari pengertian, contoh sintaks dan perbezaan keduanya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/tekno.bali-island.com\/ms\/articles\/penjelasan-prosedur-tersimpan-dan-kursor-pada-pangkalan-data\/\" \/>\n<meta property=\"og:site_name\" content=\"Bali Island Tekno\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/people\/Wilanpedia\/61575048527927\/\" \/>\n<meta property=\"article:published_time\" content=\"2026-04-30T08:57:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-04-30T08:57:58+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/tekno.bali-island.com\/wp-content\/uploads\/2026\/04\/Stored-Procedure-Cursor.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Wilan\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Wilan\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/articles\\\/penjelasan-prosedur-tersimpan-dan-kursor-pada-pangkalan-data\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/articles\\\/penjelasan-prosedur-tersimpan-dan-kursor-pada-pangkalan-data\\\/\"},\"author\":{\"name\":\"Wilan\",\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/#\\\/schema\\\/person\\\/945426dbaeb9dc9d603797b51b1b7e42\"},\"headline\":\"Penjelasan Prosedur Tersimpan dan Kursor pada Pangkalan Data\",\"datePublished\":\"2026-04-30T08:57:54+00:00\",\"dateModified\":\"2026-04-30T08:57:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/articles\\\/penjelasan-prosedur-tersimpan-dan-kursor-pada-pangkalan-data\\\/\"},\"wordCount\":433,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/articles\\\/penjelasan-prosedur-tersimpan-dan-kursor-pada-pangkalan-data\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/tekno.bali-island.com\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/Stored-Procedure-Cursor.webp\",\"articleSection\":[\"Programming\"],\"inLanguage\":\"ms-MY\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/articles\\\/penjelasan-prosedur-tersimpan-dan-kursor-pada-pangkalan-data\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/articles\\\/penjelasan-prosedur-tersimpan-dan-kursor-pada-pangkalan-data\\\/\",\"url\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/articles\\\/penjelasan-prosedur-tersimpan-dan-kursor-pada-pangkalan-data\\\/\",\"name\":\"Penjelasan Prosedur Tersimpan dan Kursor pada Pangkalan Data\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/articles\\\/penjelasan-prosedur-tersimpan-dan-kursor-pada-pangkalan-data\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/articles\\\/penjelasan-prosedur-tersimpan-dan-kursor-pada-pangkalan-data\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/tekno.bali-island.com\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/Stored-Procedure-Cursor.webp\",\"datePublished\":\"2026-04-30T08:57:54+00:00\",\"dateModified\":\"2026-04-30T08:57:58+00:00\",\"description\":\"Penjelasan lengkap mengenai prosedur tersimpan dan kursor, mulai dari pengertian, contoh sintaks dan perbezaan keduanya.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/articles\\\/penjelasan-prosedur-tersimpan-dan-kursor-pada-pangkalan-data\\\/#breadcrumb\"},\"inLanguage\":\"ms-MY\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/articles\\\/penjelasan-prosedur-tersimpan-dan-kursor-pada-pangkalan-data\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ms-MY\",\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/articles\\\/penjelasan-prosedur-tersimpan-dan-kursor-pada-pangkalan-data\\\/#primaryimage\",\"url\":\"https:\\\/\\\/tekno.bali-island.com\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/Stored-Procedure-Cursor.webp\",\"contentUrl\":\"https:\\\/\\\/tekno.bali-island.com\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/Stored-Procedure-Cursor.webp\",\"width\":1920,\"height\":1080,\"caption\":\"Stored Procedure & Cursor\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/articles\\\/penjelasan-prosedur-tersimpan-dan-kursor-pada-pangkalan-data\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Penjelasan Prosedur Tersimpan dan Kursor pada Pangkalan Data\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/#website\",\"url\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/\",\"name\":\"Bali Island Tekno\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ms-MY\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/#organization\",\"name\":\"Bali Island Tekno\",\"url\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ms-MY\",\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/tekno.bali-island.com\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/Logo-Tekno-Bali-Island.webp\",\"contentUrl\":\"https:\\\/\\\/tekno.bali-island.com\\\/wp-content\\\/uploads\\\/2026\\\/04\\\/Logo-Tekno-Bali-Island.webp\",\"width\":512,\"height\":512,\"caption\":\"Bali Island Tekno\"},\"image\":{\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/people\\\/Wilanpedia\\\/61575048527927\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/tekno.bali-island.com\\\/ms\\\/#\\\/schema\\\/person\\\/945426dbaeb9dc9d603797b51b1b7e42\",\"name\":\"Wilan\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ms-MY\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b88f244258181b0b6313e5bf915a4aa9f133283d33124cb16947eb1389dc4bc5?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b88f244258181b0b6313e5bf915a4aa9f133283d33124cb16947eb1389dc4bc5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/b88f244258181b0b6313e5bf915a4aa9f133283d33124cb16947eb1389dc4bc5?s=96&d=mm&r=g\",\"caption\":\"Wilan\"},\"sameAs\":[\"https:\\\/\\\/tekno.bali-island.com\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Penjelasan Prosedur Tersimpan dan Kursor pada Pangkalan Data","description":"Penjelasan lengkap mengenai prosedur tersimpan dan kursor, mulai dari pengertian, contoh sintaks dan perbezaan keduanya.","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:\/\/tekno.bali-island.com\/ms\/articles\/penjelasan-prosedur-tersimpan-dan-kursor-pada-pangkalan-data\/","og_locale":"ms_MY","og_type":"article","og_title":"Penjelasan Prosedur Tersimpan dan Kursor pada Pangkalan Data","og_description":"Penjelasan lengkap mengenai prosedur tersimpan dan kursor, mulai dari pengertian, contoh sintaks dan perbezaan keduanya.","og_url":"https:\/\/tekno.bali-island.com\/ms\/articles\/penjelasan-prosedur-tersimpan-dan-kursor-pada-pangkalan-data\/","og_site_name":"Bali Island Tekno","article_publisher":"https:\/\/www.facebook.com\/people\/Wilanpedia\/61575048527927\/","article_published_time":"2026-04-30T08:57:54+00:00","article_modified_time":"2026-04-30T08:57:58+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/tekno.bali-island.com\/wp-content\/uploads\/2026\/04\/Stored-Procedure-Cursor.webp","type":"image\/webp"}],"author":"Wilan","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Wilan","Est. reading time":"3 minit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/tekno.bali-island.com\/ms\/articles\/penjelasan-prosedur-tersimpan-dan-kursor-pada-pangkalan-data\/#article","isPartOf":{"@id":"https:\/\/tekno.bali-island.com\/ms\/articles\/penjelasan-prosedur-tersimpan-dan-kursor-pada-pangkalan-data\/"},"author":{"name":"Wilan","@id":"https:\/\/tekno.bali-island.com\/ms\/#\/schema\/person\/945426dbaeb9dc9d603797b51b1b7e42"},"headline":"Penjelasan Prosedur Tersimpan dan Kursor pada Pangkalan Data","datePublished":"2026-04-30T08:57:54+00:00","dateModified":"2026-04-30T08:57:58+00:00","mainEntityOfPage":{"@id":"https:\/\/tekno.bali-island.com\/ms\/articles\/penjelasan-prosedur-tersimpan-dan-kursor-pada-pangkalan-data\/"},"wordCount":433,"commentCount":0,"publisher":{"@id":"https:\/\/tekno.bali-island.com\/ms\/#organization"},"image":{"@id":"https:\/\/tekno.bali-island.com\/ms\/articles\/penjelasan-prosedur-tersimpan-dan-kursor-pada-pangkalan-data\/#primaryimage"},"thumbnailUrl":"https:\/\/tekno.bali-island.com\/wp-content\/uploads\/2026\/04\/Stored-Procedure-Cursor.webp","articleSection":["Programming"],"inLanguage":"ms-MY","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/tekno.bali-island.com\/ms\/articles\/penjelasan-prosedur-tersimpan-dan-kursor-pada-pangkalan-data\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/tekno.bali-island.com\/ms\/articles\/penjelasan-prosedur-tersimpan-dan-kursor-pada-pangkalan-data\/","url":"https:\/\/tekno.bali-island.com\/ms\/articles\/penjelasan-prosedur-tersimpan-dan-kursor-pada-pangkalan-data\/","name":"Penjelasan Prosedur Tersimpan dan Kursor pada Pangkalan Data","isPartOf":{"@id":"https:\/\/tekno.bali-island.com\/ms\/#website"},"primaryImageOfPage":{"@id":"https:\/\/tekno.bali-island.com\/ms\/articles\/penjelasan-prosedur-tersimpan-dan-kursor-pada-pangkalan-data\/#primaryimage"},"image":{"@id":"https:\/\/tekno.bali-island.com\/ms\/articles\/penjelasan-prosedur-tersimpan-dan-kursor-pada-pangkalan-data\/#primaryimage"},"thumbnailUrl":"https:\/\/tekno.bali-island.com\/wp-content\/uploads\/2026\/04\/Stored-Procedure-Cursor.webp","datePublished":"2026-04-30T08:57:54+00:00","dateModified":"2026-04-30T08:57:58+00:00","description":"Penjelasan lengkap mengenai prosedur tersimpan dan kursor, mulai dari pengertian, contoh sintaks dan perbezaan keduanya.","breadcrumb":{"@id":"https:\/\/tekno.bali-island.com\/ms\/articles\/penjelasan-prosedur-tersimpan-dan-kursor-pada-pangkalan-data\/#breadcrumb"},"inLanguage":"ms-MY","potentialAction":[{"@type":"ReadAction","target":["https:\/\/tekno.bali-island.com\/ms\/articles\/penjelasan-prosedur-tersimpan-dan-kursor-pada-pangkalan-data\/"]}]},{"@type":"ImageObject","inLanguage":"ms-MY","@id":"https:\/\/tekno.bali-island.com\/ms\/articles\/penjelasan-prosedur-tersimpan-dan-kursor-pada-pangkalan-data\/#primaryimage","url":"https:\/\/tekno.bali-island.com\/wp-content\/uploads\/2026\/04\/Stored-Procedure-Cursor.webp","contentUrl":"https:\/\/tekno.bali-island.com\/wp-content\/uploads\/2026\/04\/Stored-Procedure-Cursor.webp","width":1920,"height":1080,"caption":"Stored Procedure & Cursor"},{"@type":"BreadcrumbList","@id":"https:\/\/tekno.bali-island.com\/ms\/articles\/penjelasan-prosedur-tersimpan-dan-kursor-pada-pangkalan-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/tekno.bali-island.com\/ms\/"},{"@type":"ListItem","position":2,"name":"Penjelasan Prosedur Tersimpan dan Kursor pada Pangkalan Data"}]},{"@type":"WebSite","@id":"https:\/\/tekno.bali-island.com\/ms\/#website","url":"https:\/\/tekno.bali-island.com\/ms\/","name":"Bali Island Tekno","description":"","publisher":{"@id":"https:\/\/tekno.bali-island.com\/ms\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/tekno.bali-island.com\/ms\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ms-MY"},{"@type":"Organization","@id":"https:\/\/tekno.bali-island.com\/ms\/#organization","name":"Bali Island Tekno","url":"https:\/\/tekno.bali-island.com\/ms\/","logo":{"@type":"ImageObject","inLanguage":"ms-MY","@id":"https:\/\/tekno.bali-island.com\/ms\/#\/schema\/logo\/image\/","url":"https:\/\/tekno.bali-island.com\/wp-content\/uploads\/2026\/04\/Logo-Tekno-Bali-Island.webp","contentUrl":"https:\/\/tekno.bali-island.com\/wp-content\/uploads\/2026\/04\/Logo-Tekno-Bali-Island.webp","width":512,"height":512,"caption":"Bali Island Tekno"},"image":{"@id":"https:\/\/tekno.bali-island.com\/ms\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/people\/Wilanpedia\/61575048527927\/"]},{"@type":"Person","@id":"https:\/\/tekno.bali-island.com\/ms\/#\/schema\/person\/945426dbaeb9dc9d603797b51b1b7e42","name":"Wilan","image":{"@type":"ImageObject","inLanguage":"ms-MY","@id":"https:\/\/secure.gravatar.com\/avatar\/b88f244258181b0b6313e5bf915a4aa9f133283d33124cb16947eb1389dc4bc5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/b88f244258181b0b6313e5bf915a4aa9f133283d33124cb16947eb1389dc4bc5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b88f244258181b0b6313e5bf915a4aa9f133283d33124cb16947eb1389dc4bc5?s=96&d=mm&r=g","caption":"Wilan"},"sameAs":["https:\/\/tekno.bali-island.com"]}]}},"_links":{"self":[{"href":"https:\/\/tekno.bali-island.com\/ms\/wp-json\/wp\/v2\/posts\/2806","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tekno.bali-island.com\/ms\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tekno.bali-island.com\/ms\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tekno.bali-island.com\/ms\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tekno.bali-island.com\/ms\/wp-json\/wp\/v2\/comments?post=2806"}],"version-history":[{"count":1,"href":"https:\/\/tekno.bali-island.com\/ms\/wp-json\/wp\/v2\/posts\/2806\/revisions"}],"predecessor-version":[{"id":2807,"href":"https:\/\/tekno.bali-island.com\/ms\/wp-json\/wp\/v2\/posts\/2806\/revisions\/2807"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tekno.bali-island.com\/ms\/wp-json\/wp\/v2\/media\/2790"}],"wp:attachment":[{"href":"https:\/\/tekno.bali-island.com\/ms\/wp-json\/wp\/v2\/media?parent=2806"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tekno.bali-island.com\/ms\/wp-json\/wp\/v2\/categories?post=2806"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tekno.bali-island.com\/ms\/wp-json\/wp\/v2\/tags?post=2806"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}