{"id":76509,"date":"2024-12-25T03:16:17","date_gmt":"2024-12-25T03:16:17","guid":{"rendered":"http:\/\/bangla.sitestree.com\/?p=76509"},"modified":"2024-12-25T03:17:55","modified_gmt":"2024-12-25T03:17:55","slug":"how-to-see-constraints-in-oracle-sql-developer","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=76509","title":{"rendered":"How to See  Constraints in Oracle SQL Developer"},"content":{"rendered":"\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"527\" src=\"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/12\/image-52.png?resize=750%2C527\" alt=\"\" class=\"wp-image-76510\" srcset=\"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/12\/image-52.png?resize=1024%2C719 1024w, https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/12\/image-52.png?resize=300%2C211 300w, https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/12\/image-52.png?resize=768%2C539 768w, https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/12\/image-52.png?resize=750%2C527 750w, https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/12\/image-52.png?w=1041 1041w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/figure>\n\n\n\n<p>Ref: <a href=\"https:\/\/dataedo.com\/kb\/tools\/oracle-sql-developer\/view-table-foreign-keys-old\">https:\/\/dataedo.com\/kb\/tools\/oracle-sql-developer\/view-table-foreign-keys-old<\/a><\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"523\" height=\"392\" src=\"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/12\/image-54.png?resize=523%2C392\" alt=\"\" class=\"wp-image-76512\" style=\"width:735px;height:auto\" srcset=\"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/12\/image-54.png?w=523 523w, https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/12\/image-54.png?resize=300%2C225 300w\" sizes=\"auto, (max-width: 523px) 100vw, 523px\" \/><\/figure>\n\n\n\n<p>Ref: <a href=\"https:\/\/stackoverflow.com\/questions\/1143728\/how-can-i-find-which-tables-reference-a-given-table-in-oracle-sql-developer\">https:\/\/stackoverflow.com\/questions\/1143728\/how-can-i-find-which-tables-reference-a-given-table-in-oracle-sql-developer<\/a> <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ref: https:\/\/dataedo.com\/kb\/tools\/oracle-sql-developer\/view-table-foreign-keys-old Ref: https:\/\/stackoverflow.com\/questions\/1143728\/how-can-i-find-which-tables-reference-a-given-table-in-oracle-sql-developer<\/p>\n","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-76509","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":76047,"url":"http:\/\/bangla.sitestree.com\/?p=76047","url_meta":{"origin":76509,"position":0},"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":70215,"url":"http:\/\/bangla.sitestree.com\/?p=70215","url_meta":{"origin":76509,"position":1},"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":69237,"url":"http:\/\/bangla.sitestree.com\/?p=69237","url_meta":{"origin":76509,"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":76594,"url":"http:\/\/bangla.sitestree.com\/?p=76594","url_meta":{"origin":76509,"position":3},"title":"Case Statement in Oracle PL\/SQL","author":"Sayed","date":"January 19, 2025","format":false,"excerpt":"Write a SQL block that will categorize Employee Salaries. If the Salary is higher than average, it will show 'Above Average' to the output. If the Salary is lower than the average it will show 'Below average' to the output. Use HR.Employees Table. Also, utilize CASE statement. SELECT employee_id, CASE\u2026","rel":"","context":"In &quot;Root&quot;","block_context":{"text":"Root","link":"http:\/\/bangla.sitestree.com\/?cat=1"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":76662,"url":"http:\/\/bangla.sitestree.com\/?p=76662","url_meta":{"origin":76509,"position":4},"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":76591,"url":"http:\/\/bangla.sitestree.com\/?p=76591","url_meta":{"origin":76509,"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\/76509","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=76509"}],"version-history":[{"count":1,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/76509\/revisions"}],"predecessor-version":[{"id":76513,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/76509\/revisions\/76513"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=76509"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=76509"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=76509"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}