Object Tables   «Prev  Next»

Build SQL Statements to Detect Dangling References

Apply two techniques for querying an object.
After completing the required entry fields to connect to the database, the following steps must be completed:
Build the SQL statement with the following code:

First SELECT Statement

SELECT product_name, store_cost, sale_price
FROM product_obj_table; 

Apply an alternative technique for querying an object, building the following code:

Second SELECT Statement

SELECT first_name, last_name
FROM customer_obj_table cot
WHERE cot.full_address.state = 'NE'; 
After this process is completed, SQL*Plus displays the result of the compilation of your query.

You will need to be able to remove data without worrying that there are dangling references that will invalidate referential integrity along the way. By using reference partitions, you are unifying the ways in which the data is divided across multiple tables, and that significantly eases the maintenance burden