Answer Posted / prabhudatta barick

--CREATE A OBJECT TO HOLD ADDRESS

CREATE OR REPLACE TYPE ADDRESSES AS
OBJECT(ADDRESS1 VARCHAR2(1000),
ADDRESS2 VARCHAR2(1000));

--CREATE TABLE
CREATE TABLE EMP (
EMPNO VARCHAR2 (5),
ENAME VARCHAR2 (30),
ADDR ADDRESSES);

--INSERT DATA
INSERT INTO EMP VALUES(0001,'PRABHUDATTA',ADDRESSES
('BANGALORE','KARNATAKA'));

COMMIT;

--SELECT DATA
SELECT EMPNO, ENAME,A.ADDR.ADDRESS1,A.ADDR.ADDRESS2 FROM
EMP A;

What privilege is needed for a user to create indexes in oracle?

1026

---

What is the difference between formal parameters and actual parameters?

1086

---

I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

2460

---

How to insert multiple rows with one insert statement in oracle?

1085

---

What is a directory object?

1097

---

State the various uses of dbcc command?

1060

---

How to best split csv strings in oracle 9i?

1041

---

Can a parameter be passed to a cursor?

1123

---

What is an oracle table?

988

---

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5410

---

What is a named program unit?

1074

---

How would you begin to troubleshoot an ORA-3113 error?

2077

---

what is the difference between data migration and production migration.

2346

---

How many types of cluster table in Oracle?

1034

---

What is an Oracle Instance?

1120

---