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 is the difference between truncate & delete command?

1233

---

Explain what are the characteristics of data files?

1135

---

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

2285

---

What are the ansi data types supported in oracle?

986

---

What is connection pooling in oracle?

1013

---

List the various oracle database objects?

1108

---

How to create an initialization parameter file?

1101

---

Can a parameter be passed to a cursor?

1179

---

How to best split csv strings in oracle 9i?

1093

---

How oracle handles dead locks?

1129

---

Difference between cartesian join and cross join?

1090

---

Is insert autocommit in oracle?

1128

---

Where do we use decode and case statements?

1058

---

What are dml statements in oracle?

1130

---

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2332

---