Category Archives: Oracle SQL Functions

Function Description Function ATAN returns the arc tangent of the argument n, which can be in an unbounded range. The function returns a value in the range of -pi/2 to pi/2 in radians. Examples SELECT ATAN(0.5) FROM dual; Result: 0,463647609000806 … Continue reading →

Function DescriptionWatch movie online The Transporter Refueled (2015) Function ASIN returns the arc sine of the argument n, which must be in the range of -1 to 1. The function returns a value in the range of -pi/2 to pi/2 … Continue reading →

Function Description Function ACOS returns the arc cosine of the argument n, which must be in the range of -1 to 1. The function returns a value in the range of 0 to pi in radians. Examples SELECT ACOS(0.5) FROM … Continue reading →

Function Description Function ABS returns the absolute value of number. Examples SELECT ABS(-100) FROM dual; Result: 100 SELECT ABS(200) FROM dual; Result: 200

Function Description Function UPPER returns char in uppercase for all letters. Examples SELECT ‘John’, UPPER(‘John’) FROM dual; Result: John JOHN

Function Description Function SYSTIMESTAMP returns the system date, with fractional seconds and time zone of the operating system on which database runs. Examples SELECT SYSTIMESTAMP FROM dual; Result: 17.10.2010 12:47:09,711189 +08:00

Function Description Function SYSDATE returns date of current date and time of the operating system on which database runs comprar viagra sin receta en farmacia. Note You can change value of NLS_DATE_FORMAT parameter to change returned format of SYSDATE:Watch Full … Continue reading →

Function Description Function SYS_EXTRACT_UTC extracts the UTC or GMT time from a datetime value. Examples SELECT SYS_EXTRACT_UTC(TIMESTAMP ‘2011-11-16 11:30:00 -08:00’) FROM dual; Result: 16.11.2011 19:30:00,000000000 SELECT SYS_EXTRACT_UTC(TIMESTAMP ‘2011-11-16 11:30:00 US/Samoa’) FROM dual; Result: 16.11.2011 22:30:00,000000000

Function Description Function SESSIONTIMEZONE returns the current session time zone. Examples <!– Crayon Syntax Highlighter v_2.7 la viagra se vende sin receta.2_beta –> Oracle PL/SQL SELECT SESSIONTIMEZONE FROM dual; Result: +08:00 1 2 3 4 SELECT SESSIONTIMEZONE   FROM dual;   … Continue reading →

Function Description Function ROUND (date) returns the date rounded to the unit specified by the date format model. If date format model is omited then date will be rounded to the nearest day. Examples SELECT ROUND(TO_DATE(‘30.11.2011′),’MONTH’) AS “ROUND DATE” FROM … Continue reading →