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

Why we use cross join?

890

---

What is vector point function?

1005

---

What is benefit of creating memory optimized table?

910

---

Explain sql data types?

1037

---

How you improve the performance of sql*loader? : aql loader

957

---

How do I create a sql script?

1052

---

Can a procedure in a package be overloaded?

984

---

Why do we go for stored procedures?

995

---

how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

901

---

what is a database lock ? : Sql dba

1093

---

1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

1536

---

What is posting?

990

---

Can we change the table name in sql?

890

---

How to display Row Number with Records in Oracle SQL Plus?

993

---

Can we use threading in pl/sql?

975

---