Tech Honey

The #1 Website for Oracle PL/SQL, OA Framework and HTML

ASIN Function in Oracle SQL – PLSQL

by

The ASIN function in Oracle SQL / PLSQL is used to get arc sine of a number.

Syntax for the ASIN function in Oracle SQL / PLSQL is:

SELECT ASIN(N)
FROM table;

N is the number whose arc sine is to be determined.

Example 1:

SELECT ASIN(0.4)
FROM DUAL;

Will return “0.411516846067488”

Example 2:

SELECT ASIN(0)
 FROM DUAL;

Will return “0”

Example 3:

SELECT ASIN(-0.4)
 FROM DUAL;

Will return “-0.411516846067488”

SIGN Function in Oracle SQL – PLSQL

by

The SIGN function in Oracle SQL / PLSQL is used to get a value which indicates the sign of a number.

Syntax for the SIGN function in Oracle SQL / PLSQL is:

SELECT SIGN(N)
FROM table_name;

  • N is the number whose SIGN is to be determined.
  • If N >0 then 1 is returned
  • If N = 0 then 0 is returned
  • If N< 0 then -1 is returned

Example 1:

SELECT SIGN(1.23456)
FROM DUAL;

Will return “1”

Example 2:

SELECT SIGN(0)
FROM DUAL;

Will return “0”

Example 3:

SELECT SIGN(-2.051)
FROM DUAL;

Will return “-1”

FLOOR Function in Oracle SQL – PLSQL

by

The FLOOR function in Oracle SQL / PLSQL is used to get a largest integer number which is less than or equal to the number passed to the function.

Syntax for the FLOOR function in Oracle SQL / PLSQL is:

SELECT FLOOR(N)
FROM table_name;

  • N is the number passed

Example 1:

SELECT FLOOR(1.23456)
FROM DUAL;

Will return “1”

Example 2:

SELECT FLOOR(2.2)
FROM DUAL;

Will return “2”

Example 3:

SELECT FLOOR(2.051)
FROM DUAL;

Will return “2”

Example 4:

SELECT FLOOR(-2.051)
FROM DUAL;

Will return “-3”

CEIL Function in Oracle SQL – PLSQL

by

The CEIL function in Oracle SQL / PLSQL is used to get a smallest integer number which is greater than or equal to the number passed to the function.

Syntax for the CEIL function in Oracle SQL / PLSQL is:

SELECT CEIL(N)
FROM table_name;

  • N is the number passed

Example 1:

SELECT CEIL(1.23456)
FROM DUAL;

Will return “2”

Example 2:

SELECT CEIL(2.2)
FROM DUAL;

Will return “3”

Example 3:

SELECT CEIL(2.051)
FROM DUAL;

Will return “3”

Example 4:

SELECT CEIL(-2.051)
FROM DUAL;

Will return “-2”

TRUNC Function in Oracle SQL – PLSQL

by

The TRUNC function in Oracle SQL / PLSQL is used to get a number truncated to specific number of decimal places.

Syntax for the TRUNC function in Oracle SQL / PLSQL is:

SELECT TRUNC(N,D)
FROM table_name;

  • N is the number to be truncated
  • D is the decimal places up to which N is to be truncated

Example 1:

SELECT TRUNC(1.23456,4)
FROM DUAL;

Will return “1.2345”

Example 2:

SELECT TRUNC(1.23456,3)
FROM DUAL;

Will return “1.234”

Example 3:

SELECT TRUNC(1.23456,2)
FROM DUAL;

Will return “1.23”

Example 4:

SELECT TRUNC(-1.23456,3)
FROM DUAL;

Will return “-1.234”

Example 5:

SELECT TRUNC(1.23456)
FROM DUAL;

Will return “1”