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 trigger? : Sql dba

1020

---

When should I use nosql database?

1000

---

What will you get by the cursor attribute sql%found?

961

---

What is pl sql architecture?

955

---

Can delete statement be rollbacked?

980

---

how to convert numeric values to character strings? : Sql dba

1099

---

Advantages and disadvantages of stored procedure?

1118

---

what are date and time data types in mysql? : Sql dba

960

---

What problem one might face while writing log information to a data-base table in pl/sql?

1152

---

What is aggregate function in sql?

1030

---

What is t sql in sql server?

1066

---

How can I speed up sql query?

956

---

What does dml mean?

978

---

How many joins can you have in sql?

930

---

What is a delimiter in sas?

1045

---