{"id":76092,"date":"2024-05-20T21:54:42","date_gmt":"2024-05-21T01:54:42","guid":{"rendered":"http:\/\/bangla.sitestree.com\/?p=76092"},"modified":"2024-05-20T21:54:42","modified_gmt":"2024-05-21T01:54:42","slug":"oracle-stored-procedure-create-a-simple-stored-procedure","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=76092","title":{"rendered":"Oracle Stored Procedure: Create a simple stored procedure"},"content":{"rendered":"\n\t\t<style type=\"text\/css\">\n\t\t\t#gallery-1 {\n\t\t\t\tmargin: auto;\n\t\t\t}\n\t\t\t#gallery-1 .gallery-item {\n\t\t\t\tfloat: left;\n\t\t\t\tmargin-top: 10px;\n\t\t\t\ttext-align: center;\n\t\t\t\twidth: 33%;\n\t\t\t}\n\t\t\t#gallery-1 img {\n\t\t\t\tborder: 2px solid #cfcfcf;\n\t\t\t}\n\t\t\t#gallery-1 .gallery-caption {\n\t\t\t\tmargin-left: 0;\n\t\t\t}\n\t\t\t\/* see gallery_shortcode() in wp-includes\/media.php *\/\n\t\t<\/style>\n\t\t<div id='gallery-1' class='gallery galleryid-76092 gallery-columns-3 gallery-size-thumbnail'><dl class='gallery-item'>\n\t\t\t<dt class='gallery-icon landscape'>\n\t\t\t\t<a href='http:\/\/bangla.sitestree.com\/?attachment_id=76093'><img loading=\"lazy\" decoding=\"async\" width=\"150\" height=\"79\" src=\"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/05\/image-46.png?resize=150%2C79\" class=\"attachment-thumbnail size-thumbnail\" alt=\"\" srcset=\"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/05\/image-46.png?resize=150%2C79 150w, https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/05\/image-46.png?zoom=2&amp;resize=150%2C79 300w, https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/05\/image-46.png?zoom=3&amp;resize=150%2C79 450w\" sizes=\"auto, (max-width: 150px) 100vw, 150px\" \/><\/a>\n\t\t\t<\/dt><\/dl><dl class='gallery-item'>\n\t\t\t<dt class='gallery-icon landscape'>\n\t\t\t\t<a href='http:\/\/bangla.sitestree.com\/?attachment_id=76094'><img loading=\"lazy\" decoding=\"async\" width=\"150\" height=\"150\" src=\"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/05\/image-47.png?resize=150%2C150\" class=\"attachment-thumbnail size-thumbnail\" alt=\"\" srcset=\"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/05\/image-47.png?resize=150%2C150 150w, https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/05\/image-47.png?zoom=2&amp;resize=150%2C150 300w, https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/05\/image-47.png?zoom=3&amp;resize=150%2C150 450w\" sizes=\"auto, (max-width: 150px) 100vw, 150px\" \/><\/a>\n\t\t\t<\/dt><\/dl><dl class='gallery-item'>\n\t\t\t<dt class='gallery-icon landscape'>\n\t\t\t\t<a href='http:\/\/bangla.sitestree.com\/?attachment_id=76095'><img loading=\"lazy\" decoding=\"async\" width=\"150\" height=\"150\" src=\"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/05\/image-48.png?resize=150%2C150\" class=\"attachment-thumbnail size-thumbnail\" alt=\"\" srcset=\"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/05\/image-48.png?resize=150%2C150 150w, https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/05\/image-48.png?zoom=2&amp;resize=150%2C150 300w, https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/05\/image-48.png?zoom=3&amp;resize=150%2C150 450w\" sizes=\"auto, (max-width: 150px) 100vw, 150px\" \/><\/a>\n\t\t\t<\/dt><\/dl><br style=\"clear: both\" \/>\n\t\t<\/div>\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","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":[182],"tags":[],"class_list":["post-76092","post","type-post","status-publish","format-standard","hentry","category---blog","item-wrap"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":69099,"url":"http:\/\/bangla.sitestree.com\/?p=69099","url_meta":{"origin":76092,"position":0},"title":"Stored Procedure in MySql #5","author":"Author-Check- Article-or-Video","date":"August 12, 2021","format":false,"excerpt":"Starting from MySQL 5, you get Stored Procedure in Mysql What is a stored procedure: A stored procedure is simply a procedure that is stored on the database server like MySQL. In programming languages, you write procedures to execute a function\/logic. You can write similar procedure in SQL and store\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":75827,"url":"http:\/\/bangla.sitestree.com\/?p=75827","url_meta":{"origin":76092,"position":1},"title":"MS SQL Server Dynamic SQl, T-SQL","author":"Sayed","date":"June 25, 2023","format":false,"excerpt":"MS SQL Server Dynamic SQl, T-SQL Mostly: Dynamic SQL Stored Procedure Trigger Cursor Function Sayed Ahmed What are the Most Important Most Used Design ERD Convert ERD to database Normalization Indexing SQL Stored Procedure Dynamic SQL These will come, not too frequent Function, User Defined Data Types, Temporary Table Trigger,\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":75975,"url":"http:\/\/bangla.sitestree.com\/?p=75975","url_meta":{"origin":76092,"position":2},"title":"SQL Server: Dynamic SQL, Stored Procedure, Cursor, SQL Injection, and similar","author":"Sayed","date":"April 27, 2024","format":false,"excerpt":"SQL Server: Dynamic SQL, Stored Procedure, Cursor, SQL Injection, and similar https:\/\/youtu.be\/uje72uNAT6I?list=PLUA7SYgJYDFoharKbJxz2Hxw6xQITXvBn","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":70095,"url":"http:\/\/bangla.sitestree.com\/?p=70095","url_meta":{"origin":76092,"position":3},"title":"Stored Procedure: PHP &amp; MySQL #16","author":"Author-Check- Article-or-Video","date":"August 25, 2021","format":false,"excerpt":"Stored Procedure: PHP & MySQL. Stored Procedures are new additions to MySQL 5. PHP has supports for Store Procedure as well (with some limitations). Using Stored procedure with mySQL and PHP CODE TUTORIAL: MySql Stored Procedures PHP Resources at JustETC MySQL Resources at JustETC From: http:\/\/sitestree.com\/?p=5263 Categories:16Tags: Post Data:2009-10-27 05:05:14\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":65942,"url":"http:\/\/bangla.sitestree.com\/?p=65942","url_meta":{"origin":76092,"position":4},"title":"JDBC: Stored Procedure #Java Short Notes","author":"Author-Check- Article-or-Video","date":"July 18, 2021","format":false,"excerpt":"Sample stored procedure call using JDBC:Call stored procedure to change\/set a value in the database\/\/set birthday - supply professor nametry{ String professor= \"dylan thomas\"; CallableStatement proc = connection.prepareCall(\"{ call set_birth_date(?, ?) }\"); proc.setString(1, professor); proc.setString(2, '1950-01-01'); cs.execute();}catch (SQLException e){ \/\/ ....}Stored procedures can also return result\/data to the caller: like\/\/return\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":69426,"url":"http:\/\/bangla.sitestree.com\/?p=69426","url_meta":{"origin":76092,"position":5},"title":"Firebird Stored procedure delphi #2","author":"Author-Check- Article-or-Video","date":"August 20, 2021","format":false,"excerpt":"In firebird, the syntax to create TRIGGERs and Stored Procedures is as below:---SET TERM !! ; CREATE TRIGGER auto_update_1 FOR DBPATHS after INSERT POSITION 0 AS BEGIN insert into commission values (100,100); END !! SET TERM ; !! ---SET TERM !! ;CREATE PROCEDURE CountTo10 RETURNS (Cnt INTEGER) AS BEGIN Cnt\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/76092","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=76092"}],"version-history":[{"count":1,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/76092\/revisions"}],"predecessor-version":[{"id":76096,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/76092\/revisions\/76096"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=76092"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=76092"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=76092"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}