PL/SQL   «Prev 

Dangling Reference Syntax in Oracle

SELECT column_name_1, <column_name_2> 
FROM table_name alias
WHERE object_name IS DANGLING;

Location 1 The SELECT clause for selecting attributes from the object table
Location 2 The FROM clause for specifying the name of the object table
Location 3 The IS DANGLING clause

validation_clauses
{ VALIDATE REF UPDATE
[ SET DANGLING TO NULL ]
| VALIDATE STRUCTURE
[ CASCADE { FAST | COMPLETE } ]
[ into_clause ]
{ OFFLINE| ONLINE }
}