|Lesson 7|| Practical examples|
|Objective||Write SQL to Query Object Tables (technique 1) |
Write SQL to Query Object Tables
To query a row or a column object table, you can use standard SQL normally used in querying relational tables.
The following example uses standard SQL to query the CUSTOMER_OBJ_TABLE table:
SELECT cust_id, first_name, last_name
FROM customer_obj_table ;
In this example, we query the object just like a normal relational table.
The following diagram illustrates the variables in the syntax:
The following Tool Tip shows an example of querying an object table: