For easy reference, we have provided a list of all SQL Server (Transact-SQL) functions. The list of SQL Server functions is sorted into the type of function based on categories such as string, conversion, …

This Oracle tutorial explains how to use the Oracle / PLSQL LISTAGG function with syntax and examples. The Oracle / PLSQL LISTAGG function concatenates values of the measure_column for …

This Oracle tutorial explains how to grant and revoke privileges in Oracle with syntax and examples. You can GRANT and REVOKE privileges on various database objects in Oracle.

The list of Oracle/PLSQL functions is sorted into the type of function based on categories such as string/character, conversion, advanced, numeric/mathematical, and date/time.

Learn how to create and drop functions in SQL Server (Transact-SQL) with syntax and examples. In SQL Server, a function is a stored program that you can pass parameters into and return a value.

SQL stands for Structured Query Language and is the standard relational language that is supported by just about every database product. All database professionals should know how to write, …

This SQL Server tutorial explains how to use the CONVERT function in SQL Server (Transact-SQL) with syntax and examples. In SQL Server (Transact-SQL), the CONVERT function converts an …

We will conclude with a review of the functions that are proprietary to Oracle. With this tutorial, you should be on your way to becoming proficient in Oracle and PLSQL.

This Oracle tutorial explains how to use the Oracle / PLSQL REGEXP_SUBSTR function with syntax and examples. This function, introduced in Oracle 11g, will allow you to extract a substring from a …

This Oracle tutorial explains how to use the Oracle UPDATE statement with syntax, examples, and practice exercises. The Oracle UPDATE statement is used to update existing records in a table in an …