Category: PL/SQL

Oracle PL/SQL From_Tz Function The From_Tz function converts a TIMESTAMP value (given a TIME ZONE) to a TIMESTAMP WITH TIME ZONE value. The From_Tz Function syntax: from_tz( timestamp_value, time_zone_value ) Example: select from_tz(TIMESTAMP '2010-09-11 01:30:25', '6:00')from dual; 11-SEP-10 01.30.25.000000000 AM +06:00...

Oracle PL/SQL Floor Function The Floor function allows you to round down any number to the nearest integer. The Floor Function syntax: floor( number ) Example: Select floor(98.97) From dual; 98 Select floor(-98.97) From dual; -99 Select floor(17.2) From dual; 17...

Oracle PL/SQL Extract Function The Extract function extracts a value from a date or interval value. The Extract Function syntax: Valid extractions: YEAR, MONTH, DAY,HOUR, MINUTE,SECOND,TIMEZONE_HOUR, TIMEZONE_MINUTE, TIMEZONE_REGION, TIMEZONE_ABBR. Example: Select extract(YEAR FROM DATE '2008-04-21') From dual; 2008 Select extract(MONTH FROM...

Oracle PL/SQL Exp Function The Exp function returns the exponent value of the given input or Exp returns e raised to the nth Power,where e=2.71828183. The Exp Function syntax: exp( number ) Example: Select exp(2) From dual; 7.38905609893065 Select exp(2.1) From...

Oracle PL/SQL Dump Function The Dump Function syntax: dump( expression, [return_format], [start_position], [length] ) Example: select dump('test') from dual; Typ=96 Len=4: 116,101,115,116 select dump('test',10) from dual; Typ=96 Len=4: 116,101,115,116 select dump('test',16) from dual; Typ=96 Len=4: 74,65,73,74 select dump('test',1016) from dual; Typ=96...