{"id":14700,"date":"2020-04-25T21:33:31","date_gmt":"2020-04-25T21:33:31","guid":{"rendered":"https:\/\/ittutorial.org\/?p=14700"},"modified":"2020-04-28T00:36:03","modified_gmt":"2020-04-28T00:36:03","slug":"pl-sql-number-functions","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/pl-sql-number-functions\/","title":{"rendered":"PL\/SQL – Number Functions"},"content":{"rendered":"

Hi Folks,<\/p>\n

 <\/p>\n

Functions are similar to operators in that they manipulate data items and return a result. Functions differ from operators in the format of their arguments. This format enables them to operate on zero, one, two, or more arguments. SQL functions are built into Oracle Database and are available for use in various appropriate SQL statements.<\/p>\n

Numeric functions accept numeric input and return numeric values. Most numeric functions that return\u00a0NUMBER\u00a0values that are accurate to 38 decimal digits. The transcendental functions\u00a0COS,\u00a0COSH,\u00a0EXP,\u00a0LN,\u00a0LOG,\u00a0SIN,\u00a0SINH,\u00a0SQRT,\u00a0TAN, and\u00a0TANH\u00a0are accurate to 36 decimal digits. The transcendental functions\u00a0ACOS,\u00a0ASIN,\u00a0ATAN, and\u00a0ATAN2\u00a0are accurate to 30 decimal digits.<\/p>\n

 <\/p>\n

Most Used Functions<\/h2>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
SYNTAX<\/td>\nDESCRIPTION<\/td>\n<\/tr>\n
ABS(n)<\/td>\nABS returns the absolute value of n.<\/td>\n<\/tr>\n
CEIL(n)<\/td>\nCEIL returns smallest integer greater than or equal to n.<\/td>\n<\/tr>\n
EXP(n)<\/td>\nEXP returns e raised to the nth power, where e = 2.71828183<\/td>\n<\/tr>\n
FLOOR(n)<\/td>\nFLOOR returns largest integer equal to or less than n.<\/td>\n<\/tr>\n
LN(n)<\/td>\nLN returns the natural logarithm of n, where n is greater than 0.<\/td>\n<\/tr>\n
LOG(n2, n1)<\/td>\nLOG returns the logarithm, base n2, of n1<\/td>\n<\/tr>\n
MOD(n2, n1)<\/td>\nMOD returns the remainder of n2 divided by n1. Returns n2 if n1 is 0.<\/td>\n<\/tr>\n
POWER(n2, n1)<\/td>\nPOWER returns n2 raised to the n1 power.<\/td>\n<\/tr>\n
REMAINDER(n2, n1)<\/td>\nREMAINDER returns the remainder of n2 divided by n1.<\/td>\n<\/tr>\n
ROUND(n, interger)<\/td>\nROUND returns n rounded to integer places to the right of the decimal point. If you omit integer, then n is rounded to 0 places.<\/td>\n<\/tr>\n
SIGN(n)<\/td>\nSIGN returns -1 if n<0, 0 if n=0, and 1 if n>0<\/td>\n<\/tr>\n
SQRT(n)<\/td>\nSQRT returns the square root of n.<\/td>\n<\/tr>\n
TRUNC(n1, n2)<\/td>\nThe TRUNC (number) function returns n1 truncated to n2 decimal places. If n2 is omitted, then n1 is truncated to 0 places.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
SELECT\r\n      ABS(-15) \"Absolute\"\r\n    , CEIL(268651.8) \"CEIL\"\r\n    , EXP(4) \"e to the 4th power\"\r\n    , FLOOR(15.7) \"Floor\"\r\n    , LN(95) \"Natural log of 95\" \r\n    , LOG(10,100) \"Log base 10 of 100\"\r\n    , MOD(11,4) \"Modulus\" \r\n    , POWER(3,2) \"Raised\"\r\n    , REMAINDER(21.23, 1) \"Remainder\"\r\n    , ROUND(15.193,1) \"Round\"\r\n    , SIGN(-15) \"Sign\"\r\n    , SQRT(25) \"Square root\"\r\n    , TRUNC(15.79,1) \"Truncate\" \r\nFROM DUAL;<\/pre>\n
\"\"<\/p>\n
<\/h2>\n
Trigonometric Functions<\/h2>\n\n\n\n\n\n\n\n\n\n\n\n\n\n
SYNTAX<\/td>\nDESCRIPTION<\/td>\n<\/tr>\n
ACOS(n)<\/td>\nACOS returns the arc cosine of n.<\/td>\n<\/tr>\n
ASIN(n)<\/td>\nASIN returns the arc sine of n.<\/td>\n<\/tr>\n
ATAN(n)<\/td>\nATAN returns the arc tangent of n.<\/td>\n<\/tr>\n
ATAN(n1, n2)<\/td>\nATAN2 returns the arc tangent of n1 and n2.<\/td>\n<\/tr>\n
COS(n)<\/td>\nCOS returns the cosine of n (an angle expressed in radians).<\/td>\n<\/tr>\n
COSH(n)<\/td>\nCOSH returns the hyperbolic cosine of n.<\/td>\n<\/tr>\n
SIN(n)<\/td>\nSIN returns the sine of n (an angle expressed in radians).<\/td>\n<\/tr>\n
SINH(n)<\/td>\nSINH returns the hyperbolic sine of n.<\/td>\n<\/tr>\n
TAN(n)<\/td>\nTAN returns the tangent of n (an angle expressed in radians).<\/td>\n<\/tr>\n
TANH(n)<\/td>\nTANH returns the hyperbolic tangent of n.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
SELECT\r\n      ACOS(.3)\"Arc_Cosine\"\r\n    , ASIN(.3) \"Arc_Sine\"\r\n    , ATAN(.3) \"Arc_Tangent\"\r\n    , ATAN2(.3, .2) \"Arc_Tangent2\"\r\n    , COS(180 * 3.14159265359\/180) \"COS\"\r\nFROM DUAL;<\/pre>\n
\"\"<\/p>\n
 <\/p>\n
SELECT \r\n      COSH(0) \"Hyperbolic cosine of 0\"\r\n    , SIN(30 * 3.14159265359\/180) \"Sine of 30 degrees\"\r\n    , SINH(1) \"Hyperbolic sine of 1\"\r\n    , TAN(135 * 3.14159265359\/180)  \"Tangent of 135 degrees\"\r\n    , TANH(.5) \"Hyperbolic tangent of .5\"\r\nFROM DUAL;<\/pre>\n
\"\"<\/p>\n
 <\/p>\n
Please write down in the comments any further questions you may have. I’ll be happy to help you.<\/p>\n","protected":false},"excerpt":{"rendered":"
Hi Folks,   Functions are similar to operators in that they manipulate data items and return a result. Functions differ from operators in the format of their arguments. This format enables them to operate on zero, one, two, or more arguments. SQL functions are built into Oracle Database and are available for use in various …<\/p>\n","protected":false},"author":10477,"featured_media":14709,"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,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1994,3019,3647],"tags":[3617,9290,3717,9294,9292,9291,9293],"class_list":["post-14700","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle","category-oracle-sql","category-pl-sql","tag-oracle-pl-sql","tag-oracle-pl-sql-number-functions","tag-oracle-plsql","tag-oracle-trigonometric-functions","tag-pl-sql-functions","tag-pl-sql-number-functions","tag-pl-sql-trigonometric-functions"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/ittutorial.org\/wp-content\/uploads\/2020\/04\/PLSQL_ICO.png","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/14700","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/users\/10477"}],"replies":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/comments?post=14700"}],"version-history":[{"count":6,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/14700\/revisions"}],"predecessor-version":[{"id":14710,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/14700\/revisions\/14710"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media\/14709"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=14700"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=14700"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=14700"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}