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 a temp table?

1032

---

What are analytical functions in sql?

1038

---

what is a view? : Sql dba

1105

---

Show code of a cursor for loop.

1065

---

Do we need commit after truncate?

1089

---

What is sqlite used for?

1008

---

Is join same as left join?

1045

---

How to download oracle sql developer?

1120

---

What is sql and db2?

1013

---

What is orm in sql?

1052

---

What is compound trigger?

1045

---

How do you modify a column in sql?

1004

---

How do I run sql?

1196

---

How do sql databases work?

1005

---

Explain normalization and what are the advantages of it?

959

---