Tag Archives: Oracle

ORACLE TO_CHAR

Oracle To_char() is an SQL function which will convert a number or date to string.

SQL Functions Leave a comment

SQL REVERSE

SQL REVERSE function is used to return reverse of a string. It’s supported by MS SQL Server, MySQL. Oracle supports it too, but maybe not in the documents.

SQL Functions Also tagged , , Leave a comment

ORACLE TO_DATE

Oracle To_date() is an SQL function which will convert a string to date. In SQL Server we could use SQL CONVERT function to convert a string to date.

SQL Functions Leave a comment

SQL EXTRACT (Oracle Function)

The SQL EXTRACT() function is used to get a value (year, month, day, etc.) from a date/time expression. It’s supported by MySQL and Oracle, but the syntax is different. In this post we’ll discuss it’s syntax and example in Oracle.

SQL Functions Also tagged Leave a comment