{"id":3946,"date":"2024-03-13T07:42:58","date_gmt":"2024-03-13T07:42:58","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-assign-values-to-the-decimal-type-in-oracle\/"},"modified":"2025-07-30T23:15:35","modified_gmt":"2025-07-30T23:15:35","slug":"how-to-assign-values-to-the-decimal-type-in-oracle","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-assign-values-to-the-decimal-type-in-oracle\/","title":{"rendered":"Oracle DECIMAL Assignment Guide"},"content":{"rendered":"<p>In Oracle, the DECIMAL type typically refers to the NUMBER type, and you can assign values to the DECIMAL type in the following way.<\/p>\n<ol>\n<li>Assign values directly using numbers.<\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">DECLARE<\/span>\r\n    decimal_number <span class=\"hljs-type\">DECIMAL<\/span>(<span class=\"hljs-number\">10<\/span>,<span class=\"hljs-number\">2<\/span>);\r\n<span class=\"hljs-keyword\">BEGIN<\/span>\r\n    decimal_number :<span class=\"hljs-operator\">=<\/span> <span class=\"hljs-number\">123.45<\/span>;\r\n<span class=\"hljs-keyword\">END<\/span>;\r\n<\/code><\/pre>\n<ol>\n<li>Assigning values to variables:<\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">DECLARE<\/span>\r\n    decimal_number <span class=\"hljs-type\">DECIMAL<\/span>(<span class=\"hljs-number\">10<\/span>,<span class=\"hljs-number\">2<\/span>);\r\n    some_variable NUMBER :<span class=\"hljs-operator\">=<\/span> <span class=\"hljs-number\">678.90<\/span>;\r\n<span class=\"hljs-keyword\">BEGIN<\/span>\r\n    decimal_number :<span class=\"hljs-operator\">=<\/span> some_variable;\r\n<span class=\"hljs-keyword\">END<\/span>;\r\n<\/code><\/pre>\n<ol>\n<li>Assign values using the SELECT statement.<\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">DECLARE<\/span>\r\n    decimal_number <span class=\"hljs-type\">DECIMAL<\/span>(<span class=\"hljs-number\">10<\/span>,<span class=\"hljs-number\">2<\/span>);\r\n<span class=\"hljs-keyword\">BEGIN<\/span>\r\n    <span class=\"hljs-keyword\">SELECT<\/span> <span class=\"hljs-number\">456.78<\/span> <span class=\"hljs-keyword\">INTO<\/span> decimal_number <span class=\"hljs-keyword\">FROM<\/span> dual;\r\n<span class=\"hljs-keyword\">END<\/span>;\r\n<\/code><\/pre>\n<p>In Oracle, the DECIMAL type is typically implemented using the NUMBER type, where DECIMAL(precision, scale) specifies the total length of the number and the number of digits to the right of the decimal point.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In Oracle, the DECIMAL type typically refers to the NUMBER type, and you can assign values to the DECIMAL type in the following way. Assign values directly using numbers. DECLARE decimal_number DECIMAL(10,2); BEGIN decimal_number := 123.45; END; Assigning values to variables: DECLARE decimal_number DECIMAL(10,2); some_variable NUMBER := 678.90; BEGIN decimal_number := some_variable; END; Assign values [&hellip;]<\/p>\n","protected":false},"author":9,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[2959,2961,2938,2960,2962],"class_list":["post-3946","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-number-type","tag-oracle-assignment","tag-oracle-decimal","tag-pl-sql-variables","tag-select-into"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Oracle DECIMAL Assignment Guide - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Learn how to assign values to DECIMAL\/NUMBER in Oracle PL\/SQL with direct declarations, variables, and SELECT statements.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/blog\/how-to-assign-values-to-the-decimal-type-in-oracle\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle DECIMAL Assignment Guide\" \/>\n<meta property=\"og:description\" content=\"Learn how to assign values to DECIMAL\/NUMBER in Oracle PL\/SQL with direct declarations, variables, and SELECT statements.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-assign-values-to-the-decimal-type-in-oracle\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-13T07:42:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-07-30T23:15:35+00:00\" \/>\n<meta name=\"author\" content=\"Ava Mitchell\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Ava Mitchell\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-assign-values-to-the-decimal-type-in-oracle\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-assign-values-to-the-decimal-type-in-oracle\/\"},\"author\":{\"name\":\"Ava Mitchell\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/a3e2658c2cb9fb2be95ae0a8861f4a64\"},\"headline\":\"Oracle DECIMAL Assignment Guide\",\"datePublished\":\"2024-03-13T07:42:58+00:00\",\"dateModified\":\"2025-07-30T23:15:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-assign-values-to-the-decimal-type-in-oracle\/\"},\"wordCount\":78,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"NUMBER type\",\"Oracle assignment\",\"Oracle decimal\",\"PL\/SQL variables\",\"SELECT INTO\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-assign-values-to-the-decimal-type-in-oracle\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-assign-values-to-the-decimal-type-in-oracle\/\",\"name\":\"Oracle DECIMAL Assignment Guide - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-13T07:42:58+00:00\",\"dateModified\":\"2025-07-30T23:15:35+00:00\",\"description\":\"Learn how to assign values to DECIMAL\/NUMBER in Oracle PL\/SQL with direct declarations, variables, and SELECT statements.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-assign-values-to-the-decimal-type-in-oracle\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-assign-values-to-the-decimal-type-in-oracle\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-assign-values-to-the-decimal-type-in-oracle\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle DECIMAL Assignment Guide\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/a3e2658c2cb9fb2be95ae0a8861f4a64\",\"name\":\"Ava Mitchell\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g\",\"caption\":\"Ava Mitchell\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/avamitchell\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Oracle DECIMAL Assignment Guide - Blog - Silicon Cloud","description":"Learn how to assign values to DECIMAL\/NUMBER in Oracle PL\/SQL with direct declarations, variables, and SELECT statements.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/blog\/how-to-assign-values-to-the-decimal-type-in-oracle\/","og_locale":"en_US","og_type":"article","og_title":"Oracle DECIMAL Assignment Guide","og_description":"Learn how to assign values to DECIMAL\/NUMBER in Oracle PL\/SQL with direct declarations, variables, and SELECT statements.","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-assign-values-to-the-decimal-type-in-oracle\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-13T07:42:58+00:00","article_modified_time":"2025-07-30T23:15:35+00:00","author":"Ava Mitchell","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Ava Mitchell","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-to-assign-values-to-the-decimal-type-in-oracle\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-assign-values-to-the-decimal-type-in-oracle\/"},"author":{"name":"Ava Mitchell","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/a3e2658c2cb9fb2be95ae0a8861f4a64"},"headline":"Oracle DECIMAL Assignment Guide","datePublished":"2024-03-13T07:42:58+00:00","dateModified":"2025-07-30T23:15:35+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-assign-values-to-the-decimal-type-in-oracle\/"},"wordCount":78,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["NUMBER type","Oracle assignment","Oracle decimal","PL\/SQL variables","SELECT INTO"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-assign-values-to-the-decimal-type-in-oracle\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-assign-values-to-the-decimal-type-in-oracle\/","name":"Oracle DECIMAL Assignment Guide - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-13T07:42:58+00:00","dateModified":"2025-07-30T23:15:35+00:00","description":"Learn how to assign values to DECIMAL\/NUMBER in Oracle PL\/SQL with direct declarations, variables, and SELECT statements.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-assign-values-to-the-decimal-type-in-oracle\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-assign-values-to-the-decimal-type-in-oracle\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-assign-values-to-the-decimal-type-in-oracle\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle DECIMAL Assignment Guide"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/a3e2658c2cb9fb2be95ae0a8861f4a64","name":"Ava Mitchell","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/15c63cd0564b4a2e07d611bcdffa296f6ea80e8db07c3091f43a84010514899d?s=96&d=mm&r=g","caption":"Ava Mitchell"},"url":"https:\/\/www.silicloud.com\/blog\/author\/avamitchell\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/3946","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=3946"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/3946\/revisions"}],"predecessor-version":[{"id":148606,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/3946\/revisions\/148606"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=3946"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=3946"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=3946"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}