{"id":76662,"date":"2025-03-26T01:36:22","date_gmt":"2025-03-26T01:36:22","guid":{"rendered":"http:\/\/bangla.sitestree.com\/?p=76662"},"modified":"2025-03-26T01:36:22","modified_gmt":"2025-03-26T01:36:22","slug":"pl-sql-function-syntax-in-oracle","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=76662","title":{"rendered":"PL\/SQL Function Syntax in Oracle"},"content":{"rendered":"\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"685\" height=\"79\" src=\"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2025\/03\/image-2.png?resize=685%2C79\" alt=\"\" class=\"wp-image-76663\" srcset=\"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2025\/03\/image-2.png?w=685 685w, https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2025\/03\/image-2.png?resize=300%2C35 300w\" sizes=\"auto, (max-width: 685px) 100vw, 685px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\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=\"682\" height=\"487\" src=\"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2025\/03\/image-3.png?resize=682%2C487\" alt=\"\" class=\"wp-image-76664\" style=\"width:840px;height:auto\" srcset=\"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2025\/03\/image-3.png?w=682 682w, https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2025\/03\/image-3.png?resize=300%2C214 300w\" sizes=\"auto, (max-width: 682px) 100vw, 682px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>REF: <a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/12.2\/lnpls\/CREATE-FUNCTION-statement.html\">https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/12.2\/lnpls\/CREATE-FUNCTION-statement.html<\/a> <\/p>\n","protected":false},"excerpt":{"rendered":"<p>REF: https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/12.2\/lnpls\/CREATE-FUNCTION-statement.html<\/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-76662","post","type-post","status-publish","format-standard","hentry","category-root","item-wrap"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":76097,"url":"http:\/\/bangla.sitestree.com\/?p=76097","url_meta":{"origin":76662,"position":0},"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":76047,"url":"http:\/\/bangla.sitestree.com\/?p=76047","url_meta":{"origin":76662,"position":1},"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":76662,"position":2},"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":76659,"url":"http:\/\/bangla.sitestree.com\/?p=76659","url_meta":{"origin":76662,"position":3},"title":"Stored Procedure in Oracle","author":"Sayed","date":"March 26, 2025","format":false,"excerpt":"Ref: https:\/\/docs.oracle.com\/database\/121\/LNPLS\/create_procedure.htm#LNPLS01373","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-1.png?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2025\/03\/image-1.png?resize=350%2C200 1x, https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2025\/03\/image-1.png?resize=525%2C300 1.5x, https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2025\/03\/image-1.png?resize=700%2C400 2x"},"classes":[]},{"id":76092,"url":"http:\/\/bangla.sitestree.com\/?p=76092","url_meta":{"origin":76662,"position":4},"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":76035,"url":"http:\/\/bangla.sitestree.com\/?p=76035","url_meta":{"origin":76662,"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\/76662","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=76662"}],"version-history":[{"count":1,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/76662\/revisions"}],"predecessor-version":[{"id":76665,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/76662\/revisions\/76665"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=76662"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=76662"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=76662"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}