MAX Function in Oracle / PLSQL

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 […]

Read More

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 […]

Read More

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 […]

Read More

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 […]

Read More

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 […]

Read More

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 […]

Read More

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 […]

Read More

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 […]

Read More

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 […]

Read More