Category: PL/SQL

Oracle PL/SQL SessionTimeZone Function The SessionTimeZone returns the time zone of the current session. The SessionTimeZone Function syntax: sessiontimezone Example Select sessiontimezone From dual;...

Oracle PL/SQL Rtrim Function The Rtrim function removes all specified characters from the right-hand side of a string. The Rtrim Function syntax: rtrim( string, [ trim_text ] ) String is the string to trim the characters from the right-hand side. Trim_text...

Oracle PL/SQL Rpad Function The Rpad function pads the right-side of a string with a specific set of characters. The Rpad Function syntax: rpad( text, length, [ pad_text ] ) Pad_text is optional, is the string that will be padded to...

Oracle PL/SQL Round Function The Round function(numbers) allow you to round up any number to a certain number of decimal places. The Round function(dates)) returns a date rounded to a specific unit of measure. The Round Function syntax: round( number, [...

Oracle PL/SQL Replace Function The Replace function replaces a sequence of characters in a string with another set of characters. The Replace Function syntax: replace( string, string_to_replace, [ replacement_string ] ) Example select replace('098098oracle', '098')from dual; would return 'oracle' select replace('0011report01',...