Answer Posted / keshav

CREATE Or Replace TYPE AddressType AS OBJECT (
street VARCHAR2(15),
city VARCHAR2(15),
state CHAR(2),
zip VARCHAR2(5)
);

CREATE Or Replace TYPE nested_table_AddressType AS TABLE OF AddressType;

CREATE TABLE employee (
id INTEGER PRIMARY KEY,
first_name VARCHAR2(10),
last_name VARCHAR2(10),
addresses nested_table_AddressType
)
NESTED TABLE
addresses
STORE AS
nested_addresses;

INSERT INTO employee VALUES (
1, 'Steve', 'Brown',
nested_table_AddressType(
AddressType('2 Ave', 'City', 'MA', '12345'),
AddressType('4 Ave', 'City', 'CA', '54321')
)
);

DELETE FROM TABLE (
SELECT addresses FROM employee WHERE id = 1
) addr
WHERE
VALUE(addr) = AddressType(
'4 Ave', 'City', 'CA', '54321'
);

Is sql better than excel?

519

---

How can we solve sql error: ora-00904: invalid identifier?

701

---

What is string join?

559

---

explain advantages of innodb over myisam. : Sql dba

648

---

How to use sql*plus built-in timers?

578

---

---

what is self join and what is the requirement of self join? : Sql dba

687

---

What is java sql driver?

550

---

Can a procedure in a package be overloaded?

549

---

What is the most important ddl statements in sql are?

523

---

Is oracel sql developer written in java?

648

---

Can function return multiple values in sql?

533

---

What are the properties of a transaction?

573

---

What is the difference between microsoft sql and mysql?

514

---

Is oracle and sql same?

577

---

what is the difference between $message and $$message? : Sql dba

553

---