how to create object in plsql

Answers were Sorted based on User's Feedback



how to create object in plsql..

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.

Is This Answer Correct ?    11 Yes 0 No

how to create object in plsql..

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

Is This Answer Correct ?    0 Yes 0 No

how to create object in plsql..

Answer / purushottam mishra

by using dynamic sql

Is This Answer Correct ?    3 Yes 6 No

Post New Answer

More SQL PLSQL Interview Questions

what is a trigger? : Sql dba

0 Answers  


what is Complex index. how to create it?

2 Answers  


what is an index? : Sql dba

0 Answers  


What type of database is sql?

0 Answers  


What is data abstraction in sql?

0 Answers  






what is the functionality of the function htmlentities? : Sql dba

0 Answers  


I have a Employee table with columns ename,eid,salary,deptno. How to retrieve sum of salary for each deptno?

8 Answers   L&T,


What is hibernate and its relation to sql?

0 Answers  


What does an inner join do?

0 Answers  


What is a full join?

0 Answers  


What is pl sql package?

0 Answers  


what is a sub query?how will you calculate working days in a month using sub query?

4 Answers   InteQ,


Categories