{"id":76500,"date":"2024-12-25T03:08:22","date_gmt":"2024-12-25T03:08:22","guid":{"rendered":"http:\/\/bangla.sitestree.com\/?p=76500"},"modified":"2024-12-25T03:17:55","modified_gmt":"2024-12-25T03:17:55","slug":"joins-in-oracle-with-pictures","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=76500","title":{"rendered":"Joins in Oracle: With Pictures"},"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=\"379\" height=\"288\" src=\"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/12\/image-45.png?resize=379%2C288\" alt=\"\" class=\"wp-image-76501\" style=\"width:745px;height:auto\" srcset=\"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/12\/image-45.png?w=379 379w, https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/12\/image-45.png?resize=300%2C228 300w\" sizes=\"auto, (max-width: 379px) 100vw, 379px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"378\" height=\"290\" src=\"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/12\/image-46.png?resize=378%2C290\" alt=\"\" class=\"wp-image-76502\" srcset=\"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/12\/image-46.png?w=378 378w, https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/12\/image-46.png?resize=300%2C230 300w\" sizes=\"auto, (max-width: 378px) 100vw, 378px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"382\" height=\"318\" src=\"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/12\/image-47.png?resize=382%2C318\" alt=\"\" class=\"wp-image-76503\" srcset=\"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/12\/image-47.png?w=382 382w, https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/12\/image-47.png?resize=300%2C250 300w\" sizes=\"auto, (max-width: 382px) 100vw, 382px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"396\" height=\"285\" src=\"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/12\/image-48.png?resize=396%2C285\" alt=\"\" class=\"wp-image-76504\" style=\"width:698px;height:auto\" srcset=\"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/12\/image-48.png?w=396 396w, https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/12\/image-48.png?resize=300%2C216 300w\" sizes=\"auto, (max-width: 396px) 100vw, 396px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"377\" height=\"316\" src=\"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/12\/image-49.png?resize=377%2C316\" alt=\"\" class=\"wp-image-76505\" style=\"width:592px;height:auto\" srcset=\"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/12\/image-49.png?w=377 377w, https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/12\/image-49.png?resize=300%2C251 300w\" sizes=\"auto, (max-width: 377px) 100vw, 377px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"370\" height=\"265\" src=\"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/12\/image-50.png?resize=370%2C265\" alt=\"\" class=\"wp-image-76506\" style=\"width:698px;height:auto\" srcset=\"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/12\/image-50.png?w=370 370w, https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/12\/image-50.png?resize=300%2C215 300w\" sizes=\"auto, (max-width: 370px) 100vw, 370px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"382\" height=\"304\" src=\"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/12\/image-51.png?resize=382%2C304\" alt=\"\" class=\"wp-image-76507\" style=\"width:674px;height:auto\" srcset=\"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/12\/image-51.png?w=382 382w, https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/12\/image-51.png?resize=300%2C239 300w\" sizes=\"auto, (max-width: 382px) 100vw, 382px\" \/><\/figure>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1970,1],"tags":[],"class_list":["post-76500","post","type-post","status-publish","format-standard","hentry","category-oracle-sql-developer","category-root","item-wrap"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":70215,"url":"http:\/\/bangla.sitestree.com\/?p=70215","url_meta":{"origin":76500,"position":0},"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":[]},{"id":76662,"url":"http:\/\/bangla.sitestree.com\/?p=76662","url_meta":{"origin":76500,"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":69237,"url":"http:\/\/bangla.sitestree.com\/?p=69237","url_meta":{"origin":76500,"position":2},"title":"Oracle: Application Developer : Certification : Topics #40","author":"Author-Check- Article-or-Video","date":"August 15, 2021","format":false,"excerpt":"OCP:Application Developer:1Z0-007:topics PL\/SQL:OCP:Application Developer:1Z0-001:topics SQL Expert:OCP:Application Developer:1Z0-047:topics Program with PL\/SQL:topics Oracle Forms:Certification:Topics From: http:\/\/sitestree.com\/?p=4895 Categories:40Tags: Post Data:2010-12-18 23:31:34 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":5903,"url":"http:\/\/bangla.sitestree.com\/?p=5903","url_meta":{"origin":76500,"position":3},"title":"SQL (\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2) Joins","author":"Author-Check- Article-or-Video","date":"January 30, 2015","format":false,"excerpt":"SQL (\u098f\u09b8\u0995\u09bf\u0989\u098f\u09b2) UNIQUE \u0995\u09a8\u09b8\u09cd\u099f\u09cd\u09b0\u09c7\u0987\u09a8\u09cd\u099f Author: Protap Chandra | sincerely.yours2512[at]gmail.com UNIQUE \u0985\u09b0\u09cd\u09a5 \u0985\u09a8\u09a8\u09cd\u09af \u09ac\u09be \u0985\u09a6\u09cd\u09ac\u09bf\u09a4\u09c0\u09df\u0964 \u0985\u09b0\u09cd\u09a5\u09be\u09a4 \u098f\u0995\u0987 \u099c\u09bf\u09a8\u09bf\u09b8 \u09a6\u09c1\u099f\u09bf \u09b9\u09a4\u09c7 \u09aa\u09be\u09b0\u09ac\u09c7 \u09a8\u09be\u0964 \u098f\u0995\u099f\u09bf \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c \u099f\u09c7\u09ac\u09bf\u09b2\u09c7 \u0987\u0989\u09a8\u09bf\u0995 \u09a1\u09be\u099f\u09be \u09b8\u09cd\u099f\u09cb\u09b0 \u0995\u09b0\u09be \u09b9\u09df \u09a1\u09be\u099f\u09be \u09b8\u09be\u09b0\u09cd\u099a \u0995\u09b0\u09be\u09b0 \u09b8\u09ae\u09df \u09ac\u09bf\u09ad\u09cd\u09b0\u09be\u09a8\u09cd\u09a4\u09bf \u098f\u09dc\u09be\u09a4\u09c7\u0964 \u09af\u09c7 \u0995\u09b2\u09be\u09ae\u09c7\u09b0 \u09a1\u09be\u099f\u09be \u0987\u0989\u09a8\u09bf\u0995 \u09b9\u09bf\u09b8\u09c7\u09ac\u09c7 \u0998\u09cb\u09b7\u09a3\u09be \u0995\u09b0\u09be \u09b9\u09ac\u09c7 \u09b8\u09c7\u0987 \u0995\u09b2\u09be\u09ae\u09c7\u09b0 \u098f\u0995\u099f\u09bf \u09b0\u09c7\u0995\u09b0\u09cd\u09a1\u09c7\u09b0 \u09b8\u0999\u09cd\u0997\u09c7 \u0985\u09a8\u09cd\u09af \u09b0\u09c7\u0995\u09b0\u09cd\u09a1\u09c7\u09b0\u2026","rel":"","context":"In &quot;\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001&quot;","block_context":{"text":"\u098f\u09b8 \u0995\u09bf\u0989 \u098f\u09b2 - \u09e6\u09e6\u09e7 \u0964 SQL - 001","link":"http:\/\/bangla.sitestree.com\/?cat=155"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":69241,"url":"http:\/\/bangla.sitestree.com\/?p=69241","url_meta":{"origin":76500,"position":4},"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":76591,"url":"http:\/\/bangla.sitestree.com\/?p=76591","url_meta":{"origin":76500,"position":5},"title":"Variable Declaration Conventions in Oracle PL\/SQL","author":"Sayed","date":"January 15, 2025","format":false,"excerpt":"Ref: https:\/\/trivadis.github.io\/plsql-and-sql-coding-guidelines\/v4.1\/2-naming-conventions\/naming-conventions\/","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\/01\/image-19.png?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2025\/01\/image-19.png?resize=350%2C200 1x, https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2025\/01\/image-19.png?resize=525%2C300 1.5x"},"classes":[]}],"_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/76500","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\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=76500"}],"version-history":[{"count":1,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/76500\/revisions"}],"predecessor-version":[{"id":76508,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/76500\/revisions\/76508"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=76500"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=76500"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=76500"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}