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 is user in sql?

0 Answers  

---

What is the maximum number of triggers, you can apply on a single table?

0 Answers  

---

Fetch an entire row from the employees table for a specific employee ID:

2 Answers  

---

What is autocommit sql?

0 Answers  

---

What is an exception in pl/sql?

0 Answers  

---

---

What is the use of time stamp in select statement?

1 Answers   TCS,

---

what is the difference between nested subquery and correlated subquery?

0 Answers  

---

What is insert command in sql?

0 Answers  

---

pl/sql testing means what ...... explain process how to find pl/sql bugs

1 Answers   Zensar,

---

Is it possible to create startup or shutdown trigger for on-schema?

0 Answers  

---

What is the difference between left and left outer join?

0 Answers  

---

What are expressions?

0 Answers  

---