(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