Author Archives: admin

SQL Formatter

Our FREE Online SQL Formatter Tool will make your SQL query more readable, you will probably separate keywords from tables and column names more easily. The SQL Formatter Tool can be used by some programmers as an SQL syntax beautifier. … Continue reading

Posted in SQL | Comments Off on SQL Formatter

Oracle TO_NUMBER

Function Description Oracle function TO_NUMBER returns argument x in NUMBER datatype. Optional input arguments are Oracle format elements and nls language. Here¬†you will find Oracle format elements with examples. Examples SELECT TO_NUMBER(‘555’) FROM dual; Result: 555 SELECT TO_NUMBER(‘555.12’) FROM dual; … Continue reading

Posted in Oracle SQL Functions | Leave a comment

Oracle POWER

Function Description Function POWER returns x raised to the y power. If argument x is negative then argument x MUST be an integer. Examples SELECT POWER(2, 2) FROM dual; Result: 4 SELECT POWER(-2, 3) FROM dual; Result: -8 SELECT POWER(2, … Continue reading

Posted in Oracle SQL Functions | Leave a comment

Oracle MOD

Function Description Function MOD returns the remainder of argument x divided by argument y. Oracle function MOD is calculated as x – y * FLOOR(x/y) Examples SELECT MOD(10, 2) FROM dual; Result: 0 SELECT MOD(10, 3) FROM dual; Result: 1 … Continue reading

Posted in Oracle SQL Functions | Leave a comment

Oracle LOG

Function Description Function LOG returns the logarithm of x base y. Argument x MUST be greater than 0 or 1. Examples SELECT LOG(2, 10) FROM dual; Result: 3,32192809488736 SELECT LOG(10, 10) FROM dual; Result: 1 SELECT LOG(10, 250) FROM dual; … Continue reading

Posted in Oracle SQL Functions | Leave a comment

Oracle LN

Function Description Function LN returns the natural logarithm of argument. Argument MUST be greater than 0. Examples SELECT LN(2.4) FROM dual; Result: 0,8754687373539 SELECT LN(40) FROM dual; Result: 3,68887945411394 SELECT LN(0.1) FROM dual; Result: -2,30258509299405

Posted in Oracle SQL Functions | Leave a comment

Oracle FLOOR

Function Description Function FLOOR returns largest integer equal to or less than argument. Examples SELECT FLOOR(2.4) FROM dual; Result: 2 SELECT FLOOR(2.9) FROM dual; Result: 2 SELECT FLOOR(2) FROM dual; Result: 2

Posted in Oracle SQL Functions | Leave a comment

Function EXP

Function Description Function EXP returns e to the nth power, where e = 2,718281828. Examples SELECT EXP(2) FROM dual; Result: 7,38905609893065 SELECT EXP(1) FROM dual; Result: 2,71828182845905 SELECT EXP(-2.5) FROM dual; Result: 0,0820849986238988

Posted in Oracle SQL Functions | Leave a comment

Oracle COS

Function Description Function COS returns the cosine of the argument n. The function returns the same datatype as the argument. Examples SELECT COS(-1) FROM dual; Result: 0,54030230586814 SELECT COS(-0.5) FROM dual; Result: 0,877582561890373 SELECT COS(2) FROM dual; Result: -0,416146836547142

Posted in Oracle SQL Functions | Leave a comment

Oracle CEIL

Function Description Function CEIL returns smallest integer greater than or equal to argument. Examples SELECT CEIL(10) FROM dual; Result: 10 SELECT CEIL(10.2) FROM dual; Result: 11 SELECT CEIL(10.9) FROM dual; Result: 11

Posted in Oracle SQL Functions | Leave a comment