Answer / madhavi

SQL> set serverout on
SQL>
SQL> create or replace
2 type new_person as object (
3 last_name varchar2(100),
4 phone varchar2(100),
5 member function get_last_name return varchar2,
6 member function get_phone_number return varchar2 )
7 not final
8 /

Type created.

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

Answer / purushottam mishra

by using dynamic sql

What are the basic techniques of indexing?

0 Answers  

---

Types of joins?

4 Answers   Microsoft,

---

What is the basic structure of PL/SQL ?

6 Answers  

---

What is a Procedure ?

3 Answers  

---

Explain the commit statement.

0 Answers  

---

Give an example of Full Outer Join?

1 Answers   IBM,

---

how to get a list of all tables in a database? : Sql dba

0 Answers  

---

How to get employee name from employee table which is the fiveth highest salary of the table

20 Answers   Infosys, Rolta,

---

How to create a table using constraints... IF i change the PARENT KEY value ,then CHILD KEY table will also to change in the another table... plz reply ur answers @ mak2786@gmail.com Arunkumar

3 Answers  

---

what is a tablespace? : Sql dba

0 Answers  

---

explain the difference between delete , truncate and drop commands? : Sql dba

0 Answers  

---

what is 'mysqlshow'? : Sql dba

0 Answers  

---