(Solved) : Create Type Addresst Object Street Varchar2 30 City Varchar2 20 State Char 2 Zip Char 5 Cr Q36642612 . . .
CREATE TYPE address_t AS OBJECT (
street VARCHAR2(30),
city VARCHAR2(20),
state CHAR(2),
zip CHAR(5) );
/
CREATE TYPE address_tab IS TABLE OF address_t;
/
CREATE TABLE customers (
custid number primary key,
address address_tab )
NESTED TABLE address STORE AS customer_addresses;
/
INSERT INTO customers VALUES (1,
address_tab(
address_t(’62 Oak St.’, ‘Redwood Shores’, ‘CA’, ‘94065’),
address_t(’33 Union St.’, ‘Mill Valley’, ‘CA’,’90952′)
) );
/
INSERT INTO customers VALUES (2,
address_tab(
address_t(‘2 Queens Rd.’, ‘Poway’, ‘CA’, ‘88065’),
address_t(‘129 Beach Rd.’, ‘Portola’, ‘CA’,’91132′),
address_t(’81 Federation St.’, ‘Plymouth’, ‘CA’,’71532′)
) );
/
INSERT INTO customers VALUES (3,
address_tab(
address_t(’72 Gilmour Rd.’, ‘Placentia’, ‘CA’, ‘44065’)
) );
q1 – Write a query to display the street, city, state, and zipfor all customers who zip is either 71532 or 90952 . That is, yourquery should display the following
q2 – Update the first and only address of the customer whose idis 3 from 72 Gilmour Rd. to 73 Gilmour Rd.
Expert Answer
Answer to Create Type Addresst Object Street Varchar2 30 City Varchar2 20 State Char 2 Zip Char 5 Cr Q36642612 . . .
OR