Mindsforest

Home / Oracle SQL

Showing posts with label Oracle SQL. Show all posts

ORA-02291: integrity constraint (string.string) violated - parent key not found

ORA-02291 : integrity constraint (string.string) violated - parent key not found Cause : A foreign key value has no matchi...

ORACLE/PLSQL: TO_DATE FUNCTION This Oracle tutorial explains how to use the Oracle/PLSQL TO_DATE function with syntax and examples. ...

SQL SERVER: COALESCE FUNCTION This SQL Server tutorial explains how to use the COALESCE function in SQL Server (Transact-SQL) with s...

Syntax Description of the illustration listagg.gif Purpose For a specified measure, LISTAGG orders data within each group specifie...

Syntax Description of the illustration XMLAgg.gif Purpose XMLAgg is an aggregate function. It takes a collection of XML fragments ...

This Oracle tutorial explains how to use the Oracle/PLSQL SIGN function with syntax and examples. DESCRIPTION The Oracle/PLSQL SI...

SQL SERVER: REPLACE FUNCTION This SQL Server tutorial explains how to use the REPLACE function in SQL Server (Transact-SQL) with syn...

You can rename a table or a column temporarily by giving another name known as alias. The use of table aliases means to rename a table i...