SELECT ACOS(0.5) AS RESULT FROM DUAL;\nResult: 1.0471\n\n\nSELECT ACOS(-0.25) AS RESULT FROM DUAL; \nResult: 1.8235<\/pre>\nASIN Function in Oracle<\/h3>\n Returns the arc sine value of the numerical value.<\/p>\n
SELECT ASIN(0.5) AS RESULT FROM DUAL;\nResult: 0.5236\n\n\nSELECT ASIN(-0.3) AS RESULT FROM DUAL; \nResult: -0.3047<\/pre>\nATAN Function in Oracle<\/h3>\n Returns the arc tangent of the numerical value.<\/p>\n
SELECT ATAN(0.2) AS RESULT FROM DUAL;\nResult: 0.1974<\/pre>\nATAN2 Function in Oracle<\/h3>\n Returns the arc tangent of two numerical value.<\/p>\n
SELECT ATAN2(0.2,0.3) AS RESULT FROM DUAL; \nResult: 0.5880<\/pre>\nAVG Function in Oracle<\/h3>\n Calculates and returns the avarage value of an expression.<\/p>\n
select avg(salary) from salary;\nselect job, avg(salary) from salary group by job;<\/pre>\nBITAND Function in Oracle<\/h3>\n This function implements “With AND” operation to numerical values \u200b\u200bgiven as parameters and returns an integer.<\/p>\n
SELECT BITAND(7, 2) AS RESULT FROM DUAL;\nResult: 2<\/pre>\nCEIL Function in Oracle<\/h3>\n Rounds the numerical value to next bigger integer value.<\/p>\n
SELECT CEIL(99.4) AS RESULT FROM DUAL;\nResult: 100\n\nSELECT CEIL(-99.4) AS RESULT FROM DUAL;\nResult: -98<\/pre>\nCOS Function in Oracle<\/h3>\n Returns the cosine value of the numerical value.<\/p>\n
SELECT COS(0.5) AS RESULT FROM DUAL;\nResult: 0.87758256<\/pre>\nCOSH Function in Oracle<\/h3>\n Returns the hyperbolic cosine value of the numerical value.<\/p>\n
SELECT COSH(0.5) AS RESULT FROM DUAL;\nResult: 1.1276<\/pre>\nEXP Function in Oracle<\/h3>\n Returns e raised to the nth power, where e = 2.71828183.<\/p>\n
SELECT EXP(2) AS RESULT FROM DUAL;\nResult: 7.3890<\/pre>\nFLOOR Function in Oracle<\/h3>\n Rounds the numerical value to next smaller integer value.<\/p>\n
SELECT FLOOR(99.4) AS RESULT FROM DUAL; \nResult: 98 \n\nSELECT FLOOR(-99.4) AS RESULT FROM DUAL; \nResult: -100<\/pre>\nGREATEST Function in Oracle<\/h3>\n Returns the largest value in expressions given as parameters.<\/p>\n
SELECT GREATEST(1, 5, 0, -3) AS RESULT FROM DUAL;\nResult: 5<\/pre>\nSELECT GREATEST('yusuf1', 'yusuf3', 'yusuf0') AS Result FROM DUAL;\nResult: yusuf3<\/pre>\nLEAST Function in Oracle<\/h3>\n Returns the smallest value in expressions given as parameters.<\/p>\n
SELECT LEAST(1, 5, 0, -3) AS RESULT FROM DUAL;\nResult: -3<\/pre>\nSELECT LEAST('yusuf1', 'yusuf3', 'yusuf0') AS Result FROM DUAL;\nResult: yusuf0<\/pre>\nSELECT LEAST('yusuf2', 'yusuf13', 'yusuf3') AS Result FROM DUAL;\nResult: yusuf13<\/pre>\nLN Function in Oracle<\/h3>\n Returns the natural logarithm of the numerical value.<\/p>\n
SELECT LN(20) AS Result FROM DUAL;\nResult: 2.9957<\/pre>\nLOG Function in Oracle<\/h3>\n Returns the logarithm of a base b.<\/p>\n
SELECT LOG(a,b) AS Result FROM DUAL;\n\nSELECT LOG(10, 100) AS Result FROM DUAL;\nResult:2<\/pre>\nMAX Function in Oracle<\/h3>\n Returns the maximum value of an expression.<\/p>\n
select MAX(salary) from salary;\nselect job, MAX(salary) from salary group by job;<\/pre>\nMIN Function in Oracle<\/h3>\n Returns the minimum value of an expression.<\/p>\n
select MIN(salary) from salary;\nselect job, MIN(salary) from salary group by job;<\/pre>\nMEDIAN Function in Oracle<\/h3>\n Returns the median of an expression.<\/p>\n
select MEDIAN(salary) from salary;<\/pre>\nMOD Function in Oracle<\/h3>\n Returns the remainder of a divided by\u00a0b.<\/p>\n
SELECT MOD(a,b) AS Result FROM DUAL; \n\nSELECT MOD(27, 4) AS Result FROM DUAL; \nResult:3<\/pre>\nPOWER Function in Oracle<\/h3>\n Returns a raised to the bth power.<\/p>\n
SELECT POWER(a,b) AS Result FROM DUAL; \n\nSELECT POWER(2, 3) AS Result FROM DUAL; \nResult:8\n\nSELECT POWER(3, 3) AS Result FROM DUAL; \nResult:27<\/pre>\n\u00a0ROUND Function in Oracle<\/h3>\n The parameters of the function are as follows.<\/p>\n
ROUND(number,decimal_places)<\/p>\n
number\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0->\u00a0 number will be rounded<\/p>\n
decimal_places\u00a0 \u00a0 \u00a0-> This parameter is optinal. If you do not specify this parameter, functions removes ol decimal places from the number. If you set this parameter, it will round decimal places as much as this parameters value.<\/p>\n
SELECT ROUND(12.3657) AS Result FROM DUAL;\nResult: 12\n\nSELECT ROUND(12.3657,2) AS Result FROM DUAL; \nResult:12.37\n\nSELECT ROUND(12.312,2) AS Result FROM DUAL; \nResult:12.31\n<\/pre>\nSIGN Function in Oracle<\/h3>\n Returns the sign of the numerical value.<\/p>\n
SELECT SIGN(-12) AS RESULT FROM DUAL;\nResult: -1\n\nSELECT SIGN(-0.123) AS RESULT FROM DUAL;\nResult: -1\n\nSELECT SIGN(1) AS RESULT FROM DUAL;\nResult: 1\n\nSELECT SIGN(0.1111) AS RESULT FROM DUAL;\nResult: 1\n\nSELECT SIGN(0) AS RESULT FROM DUAL;\nResult: 0<\/pre>\nSIN Function in Oracle<\/h3>\n Returns the sine of the numerical value.<\/p>\n
SELECT SIN(5) AS RESULT FROM DUAL;\nResult: -0.95892427<\/pre>\nSINH Function in Oracle<\/h3>\n Returns the hyperbolic sine of the numerical value.<\/p>\n
SELECT SINH(5) AS RESULT FROM DUAL;\nResult: 74.2032<\/pre>\nSQRT Function in Oracle<\/h3>\n Returns the square root of the numerical value.<\/p>\n
SELECT SQRT(25) AS RESULT FROM DUAL;\nResult: 5\n\nSELECT SQRT(5) AS RESULT FROM DUAL; \nResult: 2.2360<\/pre>\nSUM Function in Oracle<\/h3>\n Returns the summed value of the numerical value.<\/p>\n
select SUM(salary) from salary; \nselect job, SUM(salary) from salary group by job;\nselect job, SUM(salary+bonus) from salary group by job;<\/pre>\nTAN Function in Oracle<\/h3>\n Returns the tangent of the numerical value.<\/p>\n
SELECT TAN(0.5) AS RESULT FROM DUAL;\nResult: 0.54630249<\/pre>\nTANH Function in Oracle<\/h3>\n Returns the hyperbolic tangent of the numerical value.<\/p>\n
SELECT TANH(0.5) AS RESULT FROM DUAL;\nResult: 0.4621<\/pre>\nTRUNC Function in Oracle<\/h3>\n This functions truncates the decimal places on a decimal value. If you specify second parameter which is optinal, it truncates the decimal places according to this parameter.<\/p>\n
Examples:<\/strong><\/p>\nSELECT TRUNC(35.234) AS RESULT FROM DUAL;\nResult: 35\n\nSELECT TRUNC(35.234, 0) AS RESULT FROM DUAL;\nResult: 35\n\nSELECT TRUNC(35.234, 1) AS RESULT FROM DUAL;\nResult: 35.2\n\nSELECT TRUNC(35.234, 2) AS RESULT FROM DUAL;\nResult: 35.23\n\nSELECT TRUNC(35.234, 3) AS RESULT FROM DUAL;\nResult: 35.234<\/pre>\n<\/div>\n
<\/path><\/svg><\/i> <\/div>\n","protected":false},"excerpt":{"rendered":"
This article contains information about oracle numeric\/math functions and their usage. Numeric\/Math Functions Oracle has several functions for processing numerical data. ABS Function in Oracle Returns the absolute value of the numerical value. SELECT ABS(-15) AS RESULT FROM DUAL; Result: 15 SELECT ABS(-15.24) AS RESULT FROM DUAL; Result: 15.24 ACOS Function in Oracle Returns the …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> <\/div>\n","protected":false},"author":485,"featured_media":14930,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[4],"tags":[8360,8361,8362,8363,8364,8365,8419,8366,8368,8367,8369,8370,8377,8378,8374,8375,8389,8376,8371,8372,8373,8390,8392,8393,8391,8394,8396,8395,8397,8398,8399,8400,8401,8402,8403,8407,8410,8408,8409,8404,8406,8468,8465,8405,8411,8413,8412,8415,8425,8416,8431,8430,8418,8417,8426,8429,8427,8428,8432,8414,8381,8387,8420,8421,8386,8382,8383,8379,8380,8388,8384,8385,8357,8358,8422,8423,8356,8359,8471,8424,8470,8448,8452,8450,8449,8451,8453,8454,8455,8457,8456,8459,8458,8462,8460,8461,8466,8467,8463,8464,8469],"class_list":["post-14918","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle","tag-abs-function-in-oracle","tag-abs-function-in-oracle-example","tag-abs-function-in-oracle-sql-example","tag-acos-function-in-oracle","tag-acos-function-in-oracle-sql","tag-acos-function-in-pl-sql","tag-analytic-function-oracle-max","tag-asin-function-in-oracle","tag-asin-function-in-oracle-example","tag-asin-function-in-oracle-sql","tag-atan-function-in-oracle","tag-atan2-function-in-oracle","tag-average-function-in-oracle-sql","tag-average-function-in-pl-sql","tag-avg-function-in-oracle","tag-avg-function-in-oracle-sql","tag-avg-function-in-oracle-with-example","tag-avg-function-in-pl-sql","tag-bitand-function-in-oracle","tag-bitand-function-in-oracle-example","tag-bitand-function-in-pl-sql","tag-ceil-function-in-oracle","tag-ceil-function-in-oracle-example","tag-ceil-function-in-oracle-query","tag-ceil-function-in-oracle-sql","tag-cos-function-in-oracle","tag-cos-function-in-oracle-example","tag-cos-function-in-oracle-sql","tag-cosh-function-in-oracle","tag-exp-function-in-oracle","tag-exp-function-in-oracle-example","tag-exp-function-in-oracle-sql","tag-exponential-function-in-oracle","tag-exponential-function-in-oracle-sql","tag-exponential-function-in-pl-sql","tag-floor-function-in-oracle","tag-floor-function-in-oracle-example","tag-floor-function-in-oracle-plsql","tag-floor-function-in-oracle-sql","tag-greatest-function-in-oracle","tag-greatest-function-in-oracle-sql","tag-how-do-you-sum-in-oracle","tag-how-to-use-sum-in-pl-sql","tag-least-and-greatest-function-in-oracle","tag-ln-function-in-oracle","tag-ln-function-in-oracle-sql","tag-ln-function-in-pl-sql","tag-log-function-in-oracle","tag-max-analytic-function-in-oracle","tag-max-function-in-oracle","tag-max-function-in-oracle-example","tag-max-function-in-oracle-sql","tag-max-function-in-oracle-where-clause","tag-max-function-in-oracle-with-example","tag-max-function-in-pl-sql","tag-max-function-on-varchar2-in-oracle","tag-min-and-max-function-in-pl-sql","tag-min-and-max-functions-in-oracle-sql","tag-min-function-in-oracle","tag-natural-logarithm-function-in-oracle","tag-oracle-abs-function","tag-oracle-acos-function","tag-oracle-analytic-function-max","tag-oracle-analytic-function-max-date","tag-oracle-asin-function","tag-oracle-atan-function","tag-oracle-atan2-function","tag-oracle-avg-function","tag-oracle-avg-function-example","tag-oracle-avg-function-group-by","tag-oracle-bitand-function","tag-oracle-bitor-function","tag-oracle-math-functions","tag-oracle-mathematical-functions","tag-oracle-max-date","tag-oracle-max-date-group-by","tag-oracle-numeric-functions","tag-oracle-numeric-math-functions","tag-oracle-numerical-functions","tag-oracle-sql-max-date-row","tag-oracle-trunc-example","tag-sign-function-in-oracle-example","tag-sign-function-in-oracle-pl-sql","tag-sign-function-in-oracle-plsql","tag-sign-function-in-oracle-sql","tag-sign-function-in-oracle-with-example","tag-sin-function-in-oracle","tag-sinh-function-in-oracle","tag-sqrt-function-in-oracle","tag-sqrt-function-in-oracle-example","tag-sqrt-function-in-oracle-sql","tag-sqrt-function-in-pl-sql","tag-sqrt-function-in-plsql","tag-sum-analytic-function-in-oracle","tag-sum-function-in-oracle","tag-sum-function-in-oracle-example","tag-sum-function-in-oracle-query","tag-sum-function-in-oracle-with-multiple-columns","tag-sum-function-in-pl-sql","tag-sum-group-by-oracle","tag-trunc-function-in-oracle"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":240,"today_views":0},"yoast_head":"\n
Oracle Numeric\/Math Functions - Database Tutorials<\/title>\n<meta name=\"description\" content=\"Oracle Numeric\/Math Functions\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2020\/02\/07\/oracle-numeric-math-functions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle Numeric\/Math Functions - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"Oracle Numeric\/Math Functions\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2020\/02\/07\/oracle-numeric-math-functions\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2020-02-07T06:44:21+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-02-07T06:47:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/02\/Ads\u0131z-5.png\" \/>\n\t<meta property=\"og:image:width\" content=\"474\" \/>\n\t<meta property=\"og:image:height\" content=\"296\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Yusuf SEZER\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Yusuf SEZER\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/02\/07\/oracle-numeric-math-functions\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/02\/07\/oracle-numeric-math-functions\/\"},\"author\":{\"name\":\"Yusuf SEZER\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/be8bf54494b6a89e626cbed2c940599a\"},\"headline\":\"Oracle Numeric\/Math Functions\",\"datePublished\":\"2020-02-07T06:44:21+00:00\",\"dateModified\":\"2020-02-07T06:47:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/02\/07\/oracle-numeric-math-functions\/\"},\"wordCount\":464,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/02\/07\/oracle-numeric-math-functions\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/02\/Ads\u0131z-5.png\",\"keywords\":[\"ABS Function in Oracle\",\"abs function in oracle example\",\"abs function in oracle sql example\",\"ACOS Function in Oracle\",\"acos function in oracle sql\",\"acos function in pl sql\",\"analytic function oracle max\",\"ASIN Function in Oracle\",\"asin function in oracle example\",\"asin function in oracle sql\",\"ATAN Function in Oracle\",\"ATAN2 Function in Oracle\",\"average function in oracle sql\",\"average function in pl sql\",\"AVG Function in Oracle\",\"avg function in oracle sql\",\"avg function in oracle with example\",\"avg function in pl sql\",\"BITAND Function in Oracle\",\"bitand function in oracle example\",\"bitand function in pl sql\",\"ceil function in oracle\",\"ceil function in oracle example\",\"ceil function in oracle query\",\"ceil function in oracle sql\",\"COS Function in Oracle\",\"cos function in oracle example\",\"cos function in oracle sql\",\"COSH Function in Oracle\",\"EXP Function in Oracle\",\"exp function in oracle example\",\"exp function in oracle sql\",\"exponential function in oracle\",\"exponential function in oracle sql\",\"exponential function in pl sql\",\"floor function in oracle\",\"floor function in oracle example\",\"floor function in oracle plsql\",\"floor function in oracle sql\",\"GREATEST Function in Oracle\",\"greatest function in oracle sql\",\"How do you sum in Oracle?\",\"how to use sum in pl sql\",\"least and greatest function in oracle\",\"LN Function in Oracle\",\"ln function in oracle sql\",\"ln function in pl sql\",\"LOG Function in Oracle\",\"max analytic function in oracle\",\"MAX Function in Oracle\",\"max function in oracle example\",\"max function in oracle sql\",\"max function in oracle where clause\",\"max function in oracle with example\",\"max function in pl sql\",\"max function on varchar2 in oracle\",\"min and max function in pl\/sql\",\"min and max functions in oracle sql\",\"min function in oracle\",\"natural logarithm function in oracle\",\"oracle abs function\",\"oracle acos function\",\"oracle analytic function max\",\"oracle analytic function max date\",\"oracle asin function\",\"oracle atan function\",\"oracle atan2 function\",\"oracle avg function\",\"oracle avg function example\",\"oracle avg function group by\",\"oracle bitand function\",\"oracle bitor function\",\"Oracle Math Functions\",\"Oracle Mathematical Functions\",\"oracle max date\",\"oracle max date group by\",\"Oracle Numeric Functions\",\"oracle numeric\/math functions\",\"oracle numerical functions\",\"oracle sql max date row\",\"oracle trunc example\",\"sign function in oracle example\",\"sign function in oracle pl sql\",\"sign function in oracle plsql\",\"sign function in oracle sql\",\"sign function in oracle with example\",\"SIN Function in Oracle\",\"SINH Function in Oracle\",\"SQRT Function in Oracle\",\"sqrt function in oracle example\",\"sqrt function in oracle sql\",\"sqrt function in pl\/sql\",\"sqrt function in plsql\",\"sum analytic function in oracle\",\"SUM Function in Oracle\",\"sum function in oracle example\",\"sum function in oracle query\",\"sum function in oracle with multiple columns\",\"sum function in pl sql\",\"sum group by oracle\",\"TRUNC Function in Oracle\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/02\/07\/oracle-numeric-math-functions\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/02\/07\/oracle-numeric-math-functions\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2020\/02\/07\/oracle-numeric-math-functions\/\",\"name\":\"Oracle Numeric\/Math Functions - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/02\/07\/oracle-numeric-math-functions\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/02\/07\/oracle-numeric-math-functions\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/02\/Ads\u0131z-5.png\",\"datePublished\":\"2020-02-07T06:44:21+00:00\",\"dateModified\":\"2020-02-07T06:47:22+00:00\",\"description\":\"Oracle Numeric\/Math Functions\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/02\/07\/oracle-numeric-math-functions\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/02\/07\/oracle-numeric-math-functions\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/02\/07\/oracle-numeric-math-functions\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/02\/Ads\u0131z-5.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/02\/Ads\u0131z-5.png\",\"width\":474,\"height\":296},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/02\/07\/oracle-numeric-math-functions\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle Numeric\/Math Functions\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/be8bf54494b6a89e626cbed2c940599a\",\"name\":\"Yusuf SEZER\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/19675b3db2d4ce370af047187123e2055a2b254ede3f0e7d9bc934da478146f7?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/19675b3db2d4ce370af047187123e2055a2b254ede3f0e7d9bc934da478146f7?s=96&d=mm&r=g\",\"caption\":\"Yusuf SEZER\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/yusufsezer\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Oracle Numeric\/Math Functions - Database Tutorials","description":"Oracle Numeric\/Math Functions","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:\/\/dbtut.com\/index.php\/2020\/02\/07\/oracle-numeric-math-functions\/","og_locale":"en_US","og_type":"article","og_title":"Oracle Numeric\/Math Functions - Database Tutorials","og_description":"Oracle Numeric\/Math Functions","og_url":"https:\/\/dbtut.com\/index.php\/2020\/02\/07\/oracle-numeric-math-functions\/","og_site_name":"Database Tutorials","article_published_time":"2020-02-07T06:44:21+00:00","article_modified_time":"2020-02-07T06:47:22+00:00","og_image":[{"width":474,"height":296,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/02\/Ads\u0131z-5.png","type":"image\/png"}],"author":"Yusuf SEZER","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Yusuf SEZER","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2020\/02\/07\/oracle-numeric-math-functions\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/02\/07\/oracle-numeric-math-functions\/"},"author":{"name":"Yusuf SEZER","@id":"https:\/\/dbtut.com\/#\/schema\/person\/be8bf54494b6a89e626cbed2c940599a"},"headline":"Oracle Numeric\/Math Functions","datePublished":"2020-02-07T06:44:21+00:00","dateModified":"2020-02-07T06:47:22+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/02\/07\/oracle-numeric-math-functions\/"},"wordCount":464,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/02\/07\/oracle-numeric-math-functions\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/02\/Ads\u0131z-5.png","keywords":["ABS Function in Oracle","abs function in oracle example","abs function in oracle sql example","ACOS Function in Oracle","acos function in oracle sql","acos function in pl sql","analytic function oracle max","ASIN Function in Oracle","asin function in oracle example","asin function in oracle sql","ATAN Function in Oracle","ATAN2 Function in Oracle","average function in oracle sql","average function in pl sql","AVG Function in Oracle","avg function in oracle sql","avg function in oracle with example","avg function in pl sql","BITAND Function in Oracle","bitand function in oracle example","bitand function in pl sql","ceil function in oracle","ceil function in oracle example","ceil function in oracle query","ceil function in oracle sql","COS Function in Oracle","cos function in oracle example","cos function in oracle sql","COSH Function in Oracle","EXP Function in Oracle","exp function in oracle example","exp function in oracle sql","exponential function in oracle","exponential function in oracle sql","exponential function in pl sql","floor function in oracle","floor function in oracle example","floor function in oracle plsql","floor function in oracle sql","GREATEST Function in Oracle","greatest function in oracle sql","How do you sum in Oracle?","how to use sum in pl sql","least and greatest function in oracle","LN Function in Oracle","ln function in oracle sql","ln function in pl sql","LOG Function in Oracle","max analytic function in oracle","MAX Function in Oracle","max function in oracle example","max function in oracle sql","max function in oracle where clause","max function in oracle with example","max function in pl sql","max function on varchar2 in oracle","min and max function in pl\/sql","min and max functions in oracle sql","min function in oracle","natural logarithm function in oracle","oracle abs function","oracle acos function","oracle analytic function max","oracle analytic function max date","oracle asin function","oracle atan function","oracle atan2 function","oracle avg function","oracle avg function example","oracle avg function group by","oracle bitand function","oracle bitor function","Oracle Math Functions","Oracle Mathematical Functions","oracle max date","oracle max date group by","Oracle Numeric Functions","oracle numeric\/math functions","oracle numerical functions","oracle sql max date row","oracle trunc example","sign function in oracle example","sign function in oracle pl sql","sign function in oracle plsql","sign function in oracle sql","sign function in oracle with example","SIN Function in Oracle","SINH Function in Oracle","SQRT Function in Oracle","sqrt function in oracle example","sqrt function in oracle sql","sqrt function in pl\/sql","sqrt function in plsql","sum analytic function in oracle","SUM Function in Oracle","sum function in oracle example","sum function in oracle query","sum function in oracle with multiple columns","sum function in pl sql","sum group by oracle","TRUNC Function in Oracle"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2020\/02\/07\/oracle-numeric-math-functions\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2020\/02\/07\/oracle-numeric-math-functions\/","url":"https:\/\/dbtut.com\/index.php\/2020\/02\/07\/oracle-numeric-math-functions\/","name":"Oracle Numeric\/Math Functions - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/02\/07\/oracle-numeric-math-functions\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/02\/07\/oracle-numeric-math-functions\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/02\/Ads\u0131z-5.png","datePublished":"2020-02-07T06:44:21+00:00","dateModified":"2020-02-07T06:47:22+00:00","description":"Oracle Numeric\/Math Functions","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/02\/07\/oracle-numeric-math-functions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2020\/02\/07\/oracle-numeric-math-functions\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2020\/02\/07\/oracle-numeric-math-functions\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/02\/Ads\u0131z-5.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/02\/Ads\u0131z-5.png","width":474,"height":296},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2020\/02\/07\/oracle-numeric-math-functions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Oracle Numeric\/Math Functions"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/be8bf54494b6a89e626cbed2c940599a","name":"Yusuf SEZER","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/19675b3db2d4ce370af047187123e2055a2b254ede3f0e7d9bc934da478146f7?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/19675b3db2d4ce370af047187123e2055a2b254ede3f0e7d9bc934da478146f7?s=96&d=mm&r=g","caption":"Yusuf SEZER"},"url":"https:\/\/dbtut.com\/index.php\/author\/yusufsezer\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/14918","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/485"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=14918"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/14918\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/14930"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=14918"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=14918"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=14918"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}