SQL Functions – SQL Tutorial

ORACLE TO_CHAR

December 14, 2011 by admin

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

SQL REVERSE

December 11, 2011 by admin

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 LEFT Function

December 4, 2011 by admin

SQL LEFT() function is used to get left part of a string with the length of specified number. It is supported by MySQL, MS SQL Server, Access, but not by Oracle.

SQL SPACE

December 2, 2011 by admin

SQL SPACE() function is used to return space characters, the number of the characters is indicated by the interger parameter. It is supported by MySQL and MS SQL Server, but not Oracle.

SQL CHAR

November 30, 2011 by admin

SQL CHAR function is used to return a character of an int ASCII code.

SQL DATENAME

November 26, 2011 by admin

SQL DATENAME() is a SQL Server function used to return the name or value of the specified datepart of the a date.

SQL ASCII

November 23, 2011 by admin

SQL ASCII function is used to return ASCII code of a character, if the parameter is a string, it will return the ASCII code of the most left character.

ORACLE TO_DATE

November 17, 2011 by admin

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.

The SQL CONVERT() is a SQL Server function which is used to convert a data type to another data type in general. We can also use this function to convert a date/time expression to different formats, or convert a formatted date/time string to date expression.

SQL EXTRACT (Oracle Function)

November 11, 2011 by admin

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.