Solved

Given the Following Example of an Object Type in Oracle \quad

Question 3

Essay

Given the following example of an object type in Oracle:
CREATE TYPE carType AS OBJECT (
regNo \quad VARCHAR2 (8),
make \quad VARCHAR2 (20),
model \quad VARCHAR2 (20));
CREATE TABLE vehicles OF carType;
State the two ways:
(a) in which the 'vehicles' table can be viewed;
(b) to insert a record in the 'vehicles' table;
(c) to retrieve records of all Ford cars from the 'vehicles' table.

Correct Answer:

verifed

Verified

Related Questions