{"id":78165,"date":"2025-05-14T16:46:50","date_gmt":"2025-05-14T16:46:50","guid":{"rendered":"http:\/\/bangla.sitestree.com\/?p=78165"},"modified":"2025-05-14T16:49:26","modified_gmt":"2025-05-14T16:49:26","slug":"oracle-pl-sql-concepts","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=78165","title":{"rendered":"Oracle PL\/SQL Concepts"},"content":{"rendered":"\n<p>Oracle PL\/SQL Concepts<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>BLOCK\n<ul class=\"wp-block-list\">\n<li>declare &#8230;. Begin&#8230;End.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Cursor<\/li>\n\n\n\n<li>Trigger<\/li>\n\n\n\n<li>Programming Clauses:\n<ul class=\"wp-block-list\">\n<li>if..then&#8230;else, case when, loops (for, while) <\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Stored Procedure<\/li>\n\n\n\n<li>Function<\/li>\n\n\n\n<li>Advanced SQLs and Analytics Functions\n<ul class=\"wp-block-list\">\n<li>GROUP BY ROLLUP(), GROUP BY CUBE()<\/li>\n\n\n\n<li>RANK(), DENSE_RANK(), ROW_NUMBER()<\/li>\n\n\n\n<li>PARTITION_BY, ORDER BY X NULLS Last, ORDER BY X NULLS FIRST, RANGE BETWEEN INTERVAL 30 DAY PRECEDING AND INTERVAL \u201830\u2019 DAY Following<\/li>\n\n\n\n<li>Hierarchical: Connect Prior<\/li>\n\n\n\n<li>Windowing Functions: RANGE BETWEEN INTERVAL 30 DAY PRECEDING AND INTERVAL \u201830\u2019 DAY Following<\/li>\n\n\n\n<li>Grouping Sets<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Oracle PL\/SQL Concepts<\/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-78165","post","type-post","status-publish","format-standard","hentry","category-root","item-wrap"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":75826,"url":"http:\/\/bangla.sitestree.com\/?p=75826","url_meta":{"origin":78165,"position":0},"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":76061,"url":"http:\/\/bangla.sitestree.com\/?p=76061","url_meta":{"origin":78165,"position":1},"title":"Oracle: Error management and exception handling in PL\/SQL","author":"Sayed","date":"May 13, 2024","format":false,"excerpt":"Raise Error in Oracle RAISE VALUE_ERROR; Raise Application Error in Oracle Create custom exception and raise it. Handle Exception You could also insert into error log table and RAISE Reference: https:\/\/blogs.oracle.com\/connect\/post\/error-management","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-34.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":69241,"url":"http:\/\/bangla.sitestree.com\/?p=69241","url_meta":{"origin":78165,"position":2},"title":"Oracle Fundamental Concepts #40","author":"Author-Check- Article-or-Video","date":"August 15, 2021","format":false,"excerpt":"TermsDatabase: In oracle, the term database refers to the files required for the operation of Oracle. These files include:data files, temporary data files, redo log files, control files, and parameter filesInstance: All the processes and memory structures required to operate the databaseUsers: Users are accounts that can be used to\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":76047,"url":"http:\/\/bangla.sitestree.com\/?p=76047","url_meta":{"origin":78165,"position":3},"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":69239,"url":"http:\/\/bangla.sitestree.com\/?p=69239","url_meta":{"origin":78165,"position":4},"title":"Oracle 11g: Basic PL\/SQL #40","author":"Author-Check- Article-or-Video","date":"August 15, 2021","format":false,"excerpt":"Database objects: table view sequence Index synonym stored procedure Will be continued From: http:\/\/sitestree.com\/?p=4967 Categories:40Tags: Post Data:2011-09-05 21:55:20 Shop Online: <a href='https:\/\/www.ShopForSoul.com\/' target='new' rel=\"noopener\">https:\/\/www.ShopForSoul.com\/<\/a> (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http:\/\/Training.SitesTree.com' target='new' rel=\"noopener\"> http:\/\/Training.SitesTree.com<\/a> In Bengali: <a href='http:\/\/Bangla.SaLearningSchool.com' target='new' rel=\"noopener\">http:\/\/Bangla.SaLearningSchool.com<\/a> <a href='http:\/\/SitesTree.com' target='new' rel=\"noopener\">http:\/\/SitesTree.com<\/a> 8112223 Canada Inc.\/JustEtc: <a\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":70215,"url":"http:\/\/bangla.sitestree.com\/?p=70215","url_meta":{"origin":78165,"position":5},"title":"Must Read: Database Driven Software Development #106","author":"Author-Check- Article-or-Video","date":"August 29, 2021","format":false,"excerpt":"If you are developing database driven applications, you must need to know and clearly understand the following concepts. Yes, you also need to apply them in your design and implementation. If you do not follow proper database design strategies, many complexities will arise, adjusting new requirements may become cumbersome to\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\/78165","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=78165"}],"version-history":[{"count":2,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/78165\/revisions"}],"predecessor-version":[{"id":78168,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/78165\/revisions\/78168"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=78165"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=78165"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=78165"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}