{"id":76038,"date":"2024-05-12T16:34:08","date_gmt":"2024-05-12T20:34:08","guid":{"rendered":"http:\/\/bangla.sitestree.com\/?p=76038"},"modified":"2024-05-12T16:34:08","modified_gmt":"2024-05-12T20:34:08","slug":"misc-oracle-data-types-why-a-data-type","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=76038","title":{"rendered":"Misc. Oracle: Data Types: Why a Data Type."},"content":{"rendered":"<p><a href=\"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/05\/image-17.png\" rel=\"attachment wp-att-76039\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/05\/image-17.png?resize=750%2C750\" alt=\"\" title=\"image-17-png\" width=\"750\" height=\"750\" class=\"alignnone size-full wp-image-76039\" \/><\/a><\/p>\n<p>Ref: <a href=\"https:\/\/docs.oracle.com\/cd\/B13789_01\/appdev.101\/b10807\/02_funds.htm\">https:\/\/docs.oracle.com\/cd\/B13789_01\/appdev.101\/b10807\/02_funds.htm<\/a><\/p>\n<p><a href=\"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/05\/image-18.png\" rel=\"attachment wp-att-76040\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/05\/image-18.png?resize=750%2C750\" alt=\"\" title=\"image-18-png\" width=\"750\" height=\"750\" class=\"alignnone size-full wp-image-76040\" \/><\/a><\/p>\n<p><a href=\"https:\/\/stackoverflow.com\/questions\/7425153\/reason-why-oracle-is-case-sensitive\">https:\/\/stackoverflow.com\/questions\/7425153\/reason-why-oracle-is-case-sensitive<\/a><\/p>\n<p><strong>Oracle Data Types and Allowed Sizes:<\/strong><\/p>\n<p><a href=\"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/05\/image-19.png\" rel=\"attachment wp-att-76041\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/05\/image-19.png?resize=750%2C750\" alt=\"\" title=\"image-19-png\" width=\"750\" height=\"750\" class=\"alignnone size-full wp-image-76041\" \/><\/a><\/p>\n<p><a href=\"https:\/\/docs.oracle.com\/cd\/E11882_01\/appdev.112\/e25519\/datatypes.htm#LNPLS99943\">https:\/\/docs.oracle.com\/cd\/E11882_01\/appdev.112\/e25519\/datatypes.htm#LNPLS99943<\/a><\/p>\n<p>Oracle <code>SIMPLE_FLOAT<\/code> vs <code>SIMPLE_DOUBLE<\/code><br \/>\n<a href=\"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/05\/image-20.png\" rel=\"attachment wp-att-76042\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/05\/image-20.png?resize=750%2C750\" alt=\"\" title=\"image-20-png\" width=\"750\" height=\"750\" class=\"alignnone size-full wp-image-76042\" \/><\/a><\/p>\n<p>Ref: <a href=\"https:\/\/docs.oracle.com\/cd\/B28359_01\/appdev.111\/b28370\/datatypes.htm#CJAEAEJG\">https:\/\/docs.oracle.com\/cd\/B28359_01\/appdev.111\/b28370\/datatypes.htm#CJAEAEJG<\/a><\/p>\n<p>PLS_Integer vs Number<\/p>\n<p>&quot;The <code>PLS_INTEGER<\/code> data type has these advantages over the <code>NUMBER<\/code> data type and <code>NUMBER<\/code> subtypes:<\/p>\n<ul>\n<li><code>PLS_INTEGER<\/code> values require less storage.<\/li>\n<li><code>PLS_INTEGER<\/code> operations use hardware arithmetic, so they are faster than <code>NUMBER<\/code> operations,<\/li>\n<\/ul>\n<p>&quot;<\/p>\n<p>Ref: <a href=\"https:\/\/docs.oracle.com\/cd\/E11882_01\/appdev.112\/e25519\/datatypes.htm#LNPLS319\">https:\/\/docs.oracle.com\/cd\/E11882_01\/appdev.112\/e25519\/datatypes.htm#LNPLS319<\/a><\/p>\n<p>Hardly anything is by me. All are from external sources. Credit belongs to them.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 &quot;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 operations, &quot; Ref: https:\/\/docs.oracle.com\/cd\/E11882_01\/appdev.112\/e25519\/datatypes.htm#LNPLS319 Hardly &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"http:\/\/bangla.sitestree.com\/?p=76038\">Continue reading<\/a><\/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-76038","post","type-post","status-publish","format-standard","hentry","category---blog","item-wrap"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":76044,"url":"http:\/\/bangla.sitestree.com\/?p=76044","url_meta":{"origin":76038,"position":0},"title":"Oracle Sub Types for Data Types: Exception Block","author":"Sayed","date":"May 12, 2024","format":false,"excerpt":"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 \"DOUBLE PRECISION\" 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","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":76035,"url":"http:\/\/bangla.sitestree.com\/?p=76035","url_meta":{"origin":76038,"position":1},"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":[]},{"id":69241,"url":"http:\/\/bangla.sitestree.com\/?p=69241","url_meta":{"origin":76038,"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":69233,"url":"http:\/\/bangla.sitestree.com\/?p=69233","url_meta":{"origin":76038,"position":3},"title":"Oracle Database Objects #40","author":"Author-Check- Article-or-Video","date":"August 15, 2021","format":false,"excerpt":"Oracle Database ObjectsSchema ObjectsClustersConstraintsDatabase linksDatabase triggersDimensionsExternal procedure librariesIndex-organized tablesIndexesIndextypesJava classes, Java resources, Java sourcesMaterialized viewsMaterialized view logsObject tablesObject typesObject viewsOperatorsPackagesSequencesStored functions, stored proceduresSynonymsTablesViewsNonschema Objects Contexts Directories Parameter files (PFILEs) and server parameter files (SPFILEs) Profiles Roles Rollback segments Tablespaces UsersWhat are schema objects? A collection of logical structures of data,\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":67714,"url":"http:\/\/bangla.sitestree.com\/?p=67714","url_meta":{"origin":76038,"position":4},"title":"Oracle WebCenter Sites Features (OWCS) #CMS","author":"Author-Check- Article-or-Video","date":"July 27, 2021","format":false,"excerpt":"Easy-To-Use Content Authoring and Design Tools For Business Users Sophisticated Customer Segment-Based Targeting and Predictive Targeting via Oracle Real-Time Decisions Integration Granular Analytics for Optimizing Web Content, Promotions, and Offers User-Generated Content and Personalized,Customizable Gadgets with Enterprise Moderation, Including Comments, Ratings, Reviews, and Blogs Highly Scalable Web Content Management (WCM)\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":76651,"url":"http:\/\/bangla.sitestree.com\/?p=76651","url_meta":{"origin":76038,"position":5},"title":"Oracle ISOLATION Levels","author":"Sayed","date":"March 14, 2025","format":false,"excerpt":"Isolation => I in ACID Supported two types: Read Committed Serializable However, there are other levels of ISOLATION such as: Read Uncommitted Repeated READ -- Note: in Read Committed, dirty data is locked until committed. In Repeated Read, A row (being modified) is locked until committed. In Serializable, A block\/dataset\/table\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":[]}],"_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/76038","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=76038"}],"version-history":[{"count":1,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/76038\/revisions"}],"predecessor-version":[{"id":76043,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/76038\/revisions\/76043"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=76038"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=76038"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=76038"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}