Oracle TO_DATE function is used to convert string type into date type. Oracle SQL TO_DATE examples and syntax can be found below. Oracle TO_DATE Function Syntax SELECT TO_DATE (STRING_VALUE, [FORMAT_MASK],[NLS_LANGUAGE]) FROM table_name; In the above Oracle TO_DATE Function Syntax: STRING_VALUE is the value that will be converted into date format. FORMAT_MASK is an optional field, if […]
function
USERENV Function in Oracle SQL – PLSQL
Oracle SQL / PLSQL USERENV function is used to get the information about the current Oracle Session. Oracle SQL / PLSQL syntax for the USERENV function is: SELECT USERENV (parameter) FROM table_name; The parameter is the value that is passed to the USERENV function. The possible values of parameter are shown below: Parameter Explanation CLIENT_INFO […]
UID Function in Oracle SQL – PLSQL
Oracle SQL / PLSQL uses the UID function to get the id number of the user’s session for the user who is currently logged in. Orace SQL / PLSQL syntax for the UID function is: SELECT UID FROM table_name; Example: Using Oracle SQL UID function in SQL SELECT Statement May return ‘5’ or ’15’ or […]
NULLIF Function in Oracle SQL – PLSQL
Oracle SQL / PLSQL used the NULLIF function to compare 2 expressions. If the expressions are equal then the SQL NULLIF function returns NULL, else SQL NULLIF function will return the first expression. Oracle SQL / PLSQL Syntax for the NULLIF function is: SELECT NULLIF (expression_1, expression_2) FROM table_name; Here, expression_1 and expression_2 are the […]
NANVL Function in Oracle SQL – PLSQL
Oracle SQL / PLSQL NANVL function allows us to substitute a value for a floating point number such a BINARY_FLOAT or BINARY_DOUBLE, when an SQL Not A Number (NAN) value is encountered. The Oracle SQL NANVL function is most commonly used to convert Not A Number (NAN) values to either 0 or NULL. Oracle SQL […]