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));

Is sql injection illegal?

982

---

What do you think about pl/sql?

973

---

What is the difference between having and a where in sql?

1055

---

What is the usage of sql functions?

1101

---

How to get list of all tables from a database?

1125

---

what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

999

---

Why primary key is required?

965

---

Why do we use %rowtype & %type in plsql?

1007

---

How to avoid using cursors? What to use instead of cursor and in what cases to do so?

1148

---

How can we link a sql database to an existing android app?

1002

---

Explain cursor types?

974

---

how to calculate the difference between two dates? : Sql dba

1021

---

Can a varchar be a primary key?

970

---

Can we insert data into materialized view?

909

---

How do you delete a table?

1033

---