MAX Function in Oracle / PLSQL This Oracle tutorial explains how to use the Oracle/PLSQL MAX function with syntax and examples. Description The Oracle/PLSQL MAX function returns the maximum value of an expression. Syntax The syntax for the MAX function in Oracle/PLSQL is: SELECT MAX(aggregate_expression) FROM tables [WHERE conditions]; OR the syntax for the MAX function when […]
Category: SQL
INTERSECT Operator in Oracle / PLSQL
INTERSECT Operator in Oracle / PLSQL This Oracle tutorial explains how to use the Oracle INTERSECT operator with syntax and examples. Description The Oracle INTERSECT operator is used to return the results of 2 or more SELECT statements. However, it only returns the rows selected by all queries or data sets. If a record exists in one query […]
TO_TIMESTAMP Function in Oracle / PLSQL
TO_TIMESTAMP Function in Oracle / PLSQL This Oracle tutorial explains how to use the Oracle/PLSQL TO_TIMESTAMP function with syntax and examples. Description The Oracle/PLSQL TO_TIMESTAMP function converts a string to a timestamp. Syntax The syntax for the TO_TIMESTAMP function in Oracle/PLSQL is: TO_TIMESTAMP( string1 [, format_mask] [‘nlsparam’] ) Parameters or Arguments string1The string that will be converted […]
UNION ALL Operator in Oracle / PLSQL
UNION ALL Operator in Oracle / PLSQL This Oracle tutorial explains how to use the Oracle UNION ALL operator with syntax and examples. Description The Oracle UNION ALL operator is used to combine the result sets of 2 or more SELECT statements. It returns all rows from the query and it does not remove duplicate rows between the […]
TO_NUMBER Function in Oracle / PLSQL
TO_NUMBER Function in Oracle / PLSQL This Oracle tutorial explains how to use the Oracle/PLSQL TO_NUMBER function with syntax and examples. Description The Oracle/PLSQL TO_NUMBER function converts a string to a number. Syntax The syntax for the TO_NUMBER function in Oracle/PLSQL is: TO_NUMBER( string1 [, format_mask] [, nls_language] ) Parameters or Arguments string1The string that will be […]
UNION Operator in Oracle / PLSQL
UNION Operator in Oracle / PLSQL This Oracle tutorial explains how to use the Oracle UNION operator with syntax and examples. Description The Oracle UNION operator is used to combine the result sets of 2 or more Oracle SELECT statements. It removes duplicate rows between the various SELECT statements. Each SELECT statement within the UNION operator must have the same […]
CREATE TABLE AS Statement in SQL: Oracle / PLSQL
CREATE TABLE AS Statement in SQL This Oracle tutorial explains how to use the Oracle CREATE TABLE AS statement in SQL with syntax and examples. Description You can also use the Oracle CREATE TABLE AS statement in SQL to create a table from an existing table by copying the existing table’s columns. It is important to note […]
TO_DATE Function in Oracle / PLSQL
TO_DATE Function in Oracle / PLSQL This Oracle tutorial explains how to use the Oracle/PLSQL TO_DATE function with syntax and examples. Description The Oracle/PLSQL TO_DATE function converts a string to a date. Syntax The syntax for the TO_DATE function in Oracle/PLSQL is: TO_DATE( string1 [, format_mask] [, nls_language] ) Parameters or Arguments string1The string that will be […]
HAVING Clause in Oracle / PLSQL
HAVING Clause in Oracle / PLSQL This Oracle tutorial explains how to use the Oracle HAVING clause with syntax and examples. Description The Oracle HAVING clause is used in combination with the GROUP BY clause to restrict the groups of returned rows to only those whose the condition is TRUE. Syntax The syntax for the HAVING clause in Oracle/PLSQL […]
TO_CHAR Function in Oracle / PLSQL
TO_CHAR Function in Oracle / PLSQL This Oracle tutorial explains how to use the Oracle/PLSQL TO_CHAR function with syntax and examples. Description The Oracle/PLSQL TO_CHAR function converts a number or date to a string. Syntax The syntax for the TO_CHAR function in Oracle/PLSQL is: TO_CHAR( value [, format_mask] [, nls_language] ) Parameters or Arguments valueA number or […]