Oracle PL/SQL Trunc Function The Trunc function(numbers) returns the 1st argument truncated by the number of decimal places specified in the 2nd argument. The Trunc function(dates)) returns a date truncated to a specific unit of measure. The Trunc Function syntax: trunc(...
Oracle PL/SQL Trim Function The Trim function removes all specified characters from the beginning or from the ending of a string. The Trim Function syntax: trim( [ leading | trailing | both [ trim_character ] ] string ) Leading – remove...
Oracle PL/SQL Translate Function The Translate function replaces a single character at a time with with another character. The Translate Function syntax: translate( string, string_to_replace, replacement_string ) Example select translate('3forms398', '398', '765') from dual; would return '7forms765' select translate('555mysql', '5my', '7pl')...
The PL/SQL TO_NUMBER function is a powerful conversion function that allows you to convert a character string into a numeric value. It is commonly used when dealing with data types in the Oracle database. The TO_NUMBER function takes a string input...
Oracle PL/SQL To_Lob Function The To_Lob function converts LONG or LONG RAW values to LOB values. The To_Lob Function syntax: to_lob( long_column ) Example insert into customers (lob_column) select to_lob(long_column) from suppliers;...
