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'
);

Can we use two order by clause in query?

969

---

Can we use distinct and group by together?

1060

---

What is pl sql collection?

978

---

what is the difference between a having clause and a where clause? : Sql dba

1091

---

what is 'mysqladmin' in mysql? : Sql dba

1028

---

What are the ddl commands?

1014

---

What are instead of triggers?

1046

---

What is audit logout in sql profiler?

1030

---

what is isam? : Sql dba

1016

---

Does mysql_real_escape_string prevent sql injection?

955

---

How do I restart sql?

979

---

What is the usage of nvl function?

1041

---

Explain the difference between rename and alias?

1018

---

Define SQL and state the differences between SQL and other conventional programming Languages?

1224

---

what is the use of set statement in tsql? : Transact sql

1011

---