Answer Posted / chandu

create type addresstype as object
(hno varchar2(5),street varchar2(10),
city varchar2(10),pin varchar2(5));

Now we use this object in creating table like this.

create table employee(empno number(5),job varchar2(10),sal
number(5),empaddress addresstype);

insert into employee
values(101,'clerk',6000,addresstype('114a','gandhi','hyd',50001));

what is the difference between rownum pseudo column and row_number() function? : Sql dba

1021

---

How do I find sql profiler?

886

---

What is the difference between mdf and ndf files?

1063

---

Which join is like inner join?

978

---

how can we optimize or increase the speed of a mysql select query? : Sql dba

890

---

What is sql exception?

915

---

How much does sqlite cost?

986

---

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

1144

---

What are records give examples?

954

---

What is sql procedures and functions?

956

---

Does pdo prevent sql injection?

886

---

What are the two different parts of the pl/sql packages?

1026

---

What is a unique key and primary key and foreign key?

920

---

What is compute?

1016

---

How do you break a loop in pl sql?

989

---