{"id":76044,"date":"2024-05-12T16:58:32","date_gmt":"2024-05-12T20:58:32","guid":{"rendered":"http:\/\/bangla.sitestree.com\/?p=76044"},"modified":"2024-05-12T16:58:32","modified_gmt":"2024-05-12T20:58:32","slug":"oracle-sub-types-for-data-types-exception-block","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=76044","title":{"rendered":"Oracle Sub Types for Data Types: Exception Block"},"content":{"rendered":"<p>An unconstrained subtype has the same set of values as its base type, so it is only another name for the base type.<\/p>\n<p>Syntax:<\/p>\n<pre dir=\"ltr\">SUBTYPE subtype_name IS base_type<\/pre>\n<pre>Example:<\/pre>\n<pre> <\/pre>\n<pre dir=\"ltr\">SUBTYPE &quot;DOUBLE PRECISION&quot; IS FLOAT<\/pre>\n<pre dir=\"ltr\">SUBTYPE Balance IS NUMBER;<\/pre>\n<pre>\n<\/pre>\n<pre>Constrained SubType<\/pre>\n<pre> <\/pre>\n<pre dir=\"ltr\">SUBTYPE Balance IS NUMBER(8,2);<\/pre>\n<p>Oracle Exception Block Example:<\/p>\n<pre>\n<\/pre>\n<pre>\n<\/pre>\n<pre>Ref: <a href=\"https:\/\/docs.oracle.com\/cd\/B13789_01\/appdev.101\/b10807\/07_errs.htm\">https:\/\/docs.oracle.com\/cd\/B13789_01\/appdev.101\/b10807\/07_errs.htm<\/a><\/pre>\n<pre>\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>An unconstrained subtype has the same set of values as its base type, so it is only another name for the base type. Syntax: SUBTYPE subtype_name IS base_type Example: SUBTYPE &quot;DOUBLE PRECISION&quot; IS FLOAT SUBTYPE Balance IS NUMBER; Constrained SubType SUBTYPE Balance IS NUMBER(8,2); Oracle Exception Block Example: Ref: https:\/\/docs.oracle.com\/cd\/B13789_01\/appdev.101\/b10807\/07_errs.htm<\/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-76044","post","type-post","status-publish","format-standard","hentry","category---blog","item-wrap"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":65844,"url":"http:\/\/bangla.sitestree.com\/?p=65844","url_meta":{"origin":76044,"position":0},"title":"Java : SCJP: Important Resources #Java Short Notes #SCJP","author":"Sayed","date":"July 16, 2021","format":false,"excerpt":"How to use generics to avoid runtime errors. More Generics Class casting in Java: How to avoid runtime exception - ClassCastException: overloading, overriding, variable and method hiding Java HotSpot virtual machine What Java Technology can do? Offers from Java Technology Java:Common Problems (and Their Solutions) Benefits of OOP: Modularity, Information-hiding,\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":76038,"url":"http:\/\/bangla.sitestree.com\/?p=76038","url_meta":{"origin":76044,"position":1},"title":"Misc. Oracle: Data Types: Why a Data Type.","author":"Sayed","date":"May 12, 2024","format":false,"excerpt":"Ref: https:\/\/docs.oracle.com\/cd\/B13789_01\/appdev.101\/b10807\/02_funds.htm https:\/\/stackoverflow.com\/questions\/7425153\/reason-why-oracle-is-case-sensitive Oracle Data Types and Allowed Sizes: https:\/\/docs.oracle.com\/cd\/E11882_01\/appdev.112\/e25519\/datatypes.htm#LNPLS99943 Oracle SIMPLE_FLOAT vs SIMPLE_DOUBLE Ref: https:\/\/docs.oracle.com\/cd\/B28359_01\/appdev.111\/b28370\/datatypes.htm#CJAEAEJG PLS_Integer vs Number \"The PLS_INTEGER data type has these advantages over the NUMBER data type and NUMBER subtypes: PLS_INTEGER values require less storage. PLS_INTEGER operations use hardware arithmetic, so they are faster than NUMBER\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-19.png?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/05\/image-19.png?resize=350%2C200 1x, https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/05\/image-19.png?resize=525%2C300 1.5x, https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/05\/image-19.png?resize=700%2C400 2x, https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/05\/image-19.png?resize=1050%2C600 3x"},"classes":[]},{"id":69920,"url":"http:\/\/bangla.sitestree.com\/?p=69920","url_meta":{"origin":76044,"position":2},"title":"Basics of Exception Handling in .Net #19","author":"Author-Check- Article-or-Video","date":"August 22, 2021","format":false,"excerpt":"Basics of Exception Handling in .Net Why exception handling? In your applications, unexpected error situations may occur that are out of your appication scope and your application logic. These are actually external to your application. For example, while you are reading a file from hard drive, the file may not\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":70311,"url":"http:\/\/bangla.sitestree.com\/?p=70311","url_meta":{"origin":76044,"position":3},"title":"Basic Information on Exception Handling in .Net #.Net Web Applications","author":"Author-Check- Article-or-Video","date":"September 1, 2021","format":false,"excerpt":"Brought from our old site: http:\/\/salearningschool.com\/displayArticle.php?table=Articles&articleID=1356&title=Basics%20of%20Exception%20Handling%20in%20.Net Basic Information on Exception Handling in .Net Why exception handling? In your applications, unexpected error situations may occur that are out of your application scope and your application logic. These are actually external to your application. For example, while you are reading a file\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":76061,"url":"http:\/\/bangla.sitestree.com\/?p=76061","url_meta":{"origin":76044,"position":4},"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":76035,"url":"http:\/\/bangla.sitestree.com\/?p=76035","url_meta":{"origin":76044,"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\/76044","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=76044"}],"version-history":[{"count":1,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/76044\/revisions"}],"predecessor-version":[{"id":76046,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/76044\/revisions\/76046"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=76044"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=76044"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=76044"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}