SQL Function

SQL functions are built into Oracle Database and are available for use in various appropriate SQL statements. Do not confuse SQL functions with user-defined functions written in PL/SQL.

If you call a SQL function with an argument of a data type other than the data type expected by the SQL function, then Oracle attempts to convert the argument to the expected data type before performing the SQL function.

Oracle TO_DATE Example

by Ed Chen
September 21, 2019March 17, 2023

Oracle TO_DATE function can convert a string into a datetime value which is acceptable for computing or comparing values of datetime type. In other words,… Read More »

Oracle SUBSTR Function by Examples

by Ed Chen
August 21, 2019December 10, 2022

SUBSTR Function Oracle SUBSTR function is used to cut or extract a piece of sub-string from an outer string. In this post, I will introduce… Read More »