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;

Explain the characteristics of oracle dba?

1116

---

Briefly explain what is literal? Give an example where it can be used?

1022

---

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

1102

---

How oracle handles dead locks?

1064

---

How to save query output to a local file?

1023

---

What is a subquery in oracle?

1106

---

What is a trigger oracle?

1082

---

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1983

---

What types of joins are used in writing subqueries?

980

---

How to use "startup" command to start default instance?

1025

---

How to concatenate two text values in oracle?

1110

---

How can I introduce multiple conditions in like operator?

982

---

What is literal?

999

---

What is a read write transaction in oracle?

1083

---

What operating systems are supported by oracle database 10g xe?

1032

---