Answer Posted / begum

hi this is really work

create type addr as object (
add1 varchar2(15),
add2 varchar2(15));
/
create table nest1 (
id number(2),
name varchar2(10),
address addr);

insert into nest1 values(10,'uma',addr('10th
main','bangalore'));
/
insert into nest1 values(20,'sami',addr('77g
colony','chennai'));

SQL> select * from nest1;

ID NAME
---------- ----------
ADDRESS(ADD1, ADD2)
--------------------------------------------
10 uma
ADDR('10th main', 'bangalore')

20 sami
ADDR('77g colony', 'chennai')

How can we find out the duplicate values in an oracle table?

1036

---

How to call a stored function with parameters?

1028

---

What is a user account in oracle?

1117

---

What are the built-in functions used for sending Parameters to forms ?

3376

---

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2821

---

What are the uses of linked server and explain it in detail?

1053

---

What is data file?

1097

---

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1984

---

What is varray?

1124

---

State any two functions of oracle?

1042

---

Why do you create or replace procedures rather that drop and recreate.

999

---

What is archive log in Oracle?

1129

---

How to get execution path reports on query statements?

976

---

Which are the five query types available in oracle?

947

---

What is the use of aggregate functions in oracle?

1022

---