{"id":76659,"date":"2025-03-26T01:33:49","date_gmt":"2025-03-26T01:33:49","guid":{"rendered":"http:\/\/bangla.sitestree.com\/?p=76659"},"modified":"2025-03-26T01:33:49","modified_gmt":"2025-03-26T01:33:49","slug":"stored-procedure-in-oracle","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=76659","title":{"rendered":"Stored Procedure in Oracle"},"content":{"rendered":"\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"744\" height=\"260\" src=\"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2025\/03\/image-1.png?resize=744%2C260\" alt=\"\" class=\"wp-image-76660\" style=\"width:840px;height:auto\" srcset=\"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2025\/03\/image-1.png?w=744 744w, https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2025\/03\/image-1.png?resize=300%2C105 300w\" sizes=\"auto, (max-width: 744px) 100vw, 744px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>Ref: <a href=\"https:\/\/docs.oracle.com\/database\/121\/LNPLS\/create_procedure.htm#LNPLS01373\">https:\/\/docs.oracle.com\/database\/121\/LNPLS\/create_procedure.htm#LNPLS01373<\/a> <\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ref: https:\/\/docs.oracle.com\/database\/121\/LNPLS\/create_procedure.htm#LNPLS01373<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-76659","post","type-post","status-publish","format-standard","hentry","category-root","item-wrap"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":76092,"url":"http:\/\/bangla.sitestree.com\/?p=76092","url_meta":{"origin":76659,"position":0},"title":"Oracle Stored Procedure: Create a simple stored procedure","author":"Sayed","date":"May 20, 2024","format":false,"excerpt":"Ref: https:\/\/docs.oracle.com\/database\/121\/LNPLS\/create_procedure.htm#LNPLS01373","rel":"","context":"In &quot;\u09ac\u09cd\u09b2\u0997 \u0964 Blog&quot;","block_context":{"text":"\u09ac\u09cd\u09b2\u0997 \u0964 Blog","link":"http:\/\/bangla.sitestree.com\/?cat=182"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/05\/image-46.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":76662,"url":"http:\/\/bangla.sitestree.com\/?p=76662","url_meta":{"origin":76659,"position":1},"title":"PL\/SQL Function Syntax in Oracle","author":"Sayed","date":"March 26, 2025","format":false,"excerpt":"REF: https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/12.2\/lnpls\/CREATE-FUNCTION-statement.html","rel":"","context":"In &quot;Root&quot;","block_context":{"text":"Root","link":"http:\/\/bangla.sitestree.com\/?cat=1"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2025\/03\/image-3.png?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2025\/03\/image-3.png?resize=350%2C200 1x, https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2025\/03\/image-3.png?resize=525%2C300 1.5x"},"classes":[]},{"id":76047,"url":"http:\/\/bangla.sitestree.com\/?p=76047","url_meta":{"origin":76659,"position":2},"title":"Oracle PL\/SQL: If-Then-Else, For Loop, While Loop","author":"Sayed","date":"May 12, 2024","format":false,"excerpt":"How it works: if, elsif, else (then) (Click on the images to see them clearly) Ref: https:\/\/docs.oracle.com\/cd\/B13789_01\/appdev.101\/b10807\/13_elems024.htm Example: Ref: https:\/\/docs.oracle.com\/cd\/B13789_01\/appdev.101\/b10807\/13_elems024.htm Oracle: CASE, WHEN, THEN Simple: Searched: '' Else: Reverse For Loop Ref: For Loop Examples in Oracle https:\/\/docs.oracle.com\/cd\/E11882_01\/appdev.112\/e25519\/controlstatements.htm#BABEFFDC Oracle While Loop While loop example from the referenced url DECLARE done\u2026","rel":"","context":"In &quot;\u09ac\u09cd\u09b2\u0997 \u0964 Blog&quot;","block_context":{"text":"\u09ac\u09cd\u09b2\u0997 \u0964 Blog","link":"http:\/\/bangla.sitestree.com\/?cat=182"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/05\/image-28.png?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/05\/image-28.png?resize=350%2C200 1x, https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/05\/image-28.png?resize=525%2C300 1.5x"},"classes":[]},{"id":75826,"url":"http:\/\/bangla.sitestree.com\/?p=75826","url_meta":{"origin":76659,"position":3},"title":"Some Topics to Know and Understand to prepare for a DBMS related Job Interview","author":"Sayed","date":"June 25, 2023","format":false,"excerpt":"Some Topics to Know and Understand to prepare for a DBMS related Job Interview ACID ACID: https:\/\/www.geeksforgeeks.org\/acid-properties-in-dbms Database Normalization 1NF: No repeating groups possible for a cell, PK identified, dependencies mapped 2NF: No Partial Dependence. Non key attributes must have to depend on the full key 3NF: No transitive dependency.\u2026","rel":"","context":"In &quot;\u09ac\u09cd\u09b2\u0997 \u0964 Blog&quot;","block_context":{"text":"\u09ac\u09cd\u09b2\u0997 \u0964 Blog","link":"http:\/\/bangla.sitestree.com\/?cat=182"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":76097,"url":"http:\/\/bangla.sitestree.com\/?p=76097","url_meta":{"origin":76659,"position":4},"title":"Oracle Functions","author":"Sayed","date":"May 20, 2024","format":false,"excerpt":"Click on Image to see them clearly Example: CREATE FUNCTION get_bal(acc_no IN NUMBER) RETURN NUMBER IS acc_bal NUMBER(11,2); BEGIN SELECT order_total INTO acc_bal FROM orders WHERE customer_id = acc_no; RETURN(acc_bal); END; \/ Ref: https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/12.2\/lnpls\/CREATE-FUNCTION-statement.html","rel":"","context":"In &quot;\u09ac\u09cd\u09b2\u0997 \u0964 Blog&quot;","block_context":{"text":"\u09ac\u09cd\u09b2\u0997 \u0964 Blog","link":"http:\/\/bangla.sitestree.com\/?cat=182"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/05\/image-49.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":76035,"url":"http:\/\/bangla.sitestree.com\/?p=76035","url_meta":{"origin":76659,"position":5},"title":"Oracle Data types, ROWID, PLS_INTEGER vs INTEGER","author":"Sayed","date":"May 12, 2024","format":false,"excerpt":"Data Types Ref: https:\/\/docs.oracle.com\/cd\/A97630_01\/server.920\/a96524\/c13datyp.htm (Click on the image to see it properly) Why PLS_Integer: https:\/\/docs.oracle.com\/cd\/B13789_01\/appdev.101\/b10807\/03_types.htm \u201cYou use the PLS_INTEGER datatype to store signed integers. Its magnitude range is -231 .. 231. PLS_INTEGER values require less storage than NUMBER values. Also, PLS_INTEGER operations use machine arithmetic, so they are faster than\u2026","rel":"","context":"In &quot;\u09ac\u09cd\u09b2\u0997 \u0964 Blog&quot;","block_context":{"text":"\u09ac\u09cd\u09b2\u0997 \u0964 Blog","link":"http:\/\/bangla.sitestree.com\/?cat=182"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/05\/image-16.png?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/05\/image-16.png?resize=350%2C200 1x, https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/05\/image-16.png?resize=525%2C300 1.5x"},"classes":[]}],"_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/76659","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=76659"}],"version-history":[{"count":1,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/76659\/revisions"}],"predecessor-version":[{"id":76661,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/76659\/revisions\/76661"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=76659"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=76659"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=76659"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}