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 truncate ddl or dml?

1037

---

What is db journal file?

1152

---

How to call a javascript function from pl sql?

1185

---

What is sql*loader?

1283

---

What are the sql commands?

1226

---

Does inner join remove duplicates?

992

---

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

1017

---

what is the difference between undefined value and null value? : Sql dba

1139

---

List the ways to get the count of records in a table?

940

---

List different type of expressions with the example.

970

---

what is foreign key? : Sql dba

1105

---

What is a trigger in sql?

1232

---

How many row comparison operators are used while working with a subquery?

1072

---

Does sql*plus also have a pl/sql engine?

1131

---

define join and explain different type of joins? : Sql dba

997

---