Database.Guide

Skip to content

Beginners

  • What is a Database?
  • Database Tutorial

SQL

  • SQL Tutorial
  • SQL Reference
  • SQL Joins Tutorial
  • SQL Transactions Tutorial
  • Basic SQL Queries

Categories

  • Azure SQL Edge (17)
  • Database Concepts (99)
  • Database Tools (72)
  • DBMS (9)
  • DuckDB (152)
  • MariaDB (424)
  • Microsoft Access (17)
  • MongoDB (265)
  • MySQL (602)
  • NoSQL (8)
  • Oracle (301)
  • PostgreSQL (480)
  • Redis (210)
  • SQL (697)
  • SQL Server (1,170)
  • SQLite (299)

Tag: numeric functions

LN() Function in Oracle

Posted on July 18, 2021 by Ian

In Oracle, the LN() function returns the natural logarithm of its argument, where the argument is greater than 0.

In other words, it returns the base-e logarithm of its argument.

The number e, also known as Euler’s number, is a mathematical constant approximately equal to 2.71828.

Continue reading →
Oracle functions, numeric functions, what is

ATAN2() Function in Oracle

Posted on July 17, 2021 by Ian

In Oracle, the ATAN2() function returns the arctangent (inverse tangent) of its two arguments.

Continue reading →
Oracle functions, numeric functions, what is

ATAN() Function in Oracle

Posted on July 17, 2021 by Ian

In Oracle, the ATAN() function returns the arctangent (inverse tangent) of its argument.

In other words, it returns the value whose tangent is the argument.

Continue reading →
Oracle functions, numeric functions, what is

BITAND() Function in Oracle

Posted on July 16, 2021 by Ian

In Oracle, the BITAND() function returns a bitwise AND of its two arguments.

Continue reading →
Oracle functions, numeric functions, what is

ASIN() Function in Oracle

Posted on July 15, 2021July 16, 2021 by Ian

In Oracle, the ASIN() function returns the arcsine (inverse sine) of its argument.

In other words, it returns the value whose sine is the argument.

Continue reading →
Oracle functions, numeric functions, what is

ACOS() Function in Oracle

Posted on July 14, 2021July 16, 2021 by Ian

In Oracle, the ACOS() function returns the arccosine (inverse cosine) of its argument.

In other words, it returns the value whose cosine is the argument.

Continue reading →
Oracle functions, numeric functions, what is

ABS() Function in Oracle

Posted on July 13, 2021July 16, 2021 by Ian

In Oracle, the ABS() function returns the absolute value of its argument.

The absolute value is the non-negative value of a real number without regard to its sign. It describes the distance from zero that a number is on the number line, without considering direction.

Continue reading →
Oracle functions, numeric functions, what is

How OCT() Works in MariaDB

Posted on June 19, 2021 by Ian

In MariaDB, OCT() is a built-in function that returns a string representation of the octal value of its argument.

Continue reading →
MariaDB functions, numeric functions, what is

How TAN() Works in MariaDB

Posted on June 18, 2021 by Ian

In MariaDB, TAN() is a built-in numeric function that returns the tangent of its argument.

Continue reading →
MariaDB functions, numeric functions, what is

How SIGN() Works in MariaDB

Posted on June 17, 2021 by Ian

In MariaDB, SIGN() is a built-in function that returns the sign of its argument as -1, 0, or 1, depending on whether the argument is negative, zero, or positive.

Continue reading →
MariaDB functions, numeric functions, what is
  • «
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • …
  • 8
  • »

About Database.Guide | Privacy Policy