Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

create oops concept pl/sql

800528Mar 14 2011 — edited Mar 16 2011
hi,

i jsut gone through pl/sql oops;

creating inheritance in oops through object type ,by creating supertype or base type and derived type ,is it important to create table of that type and why?
example.

create or replace type person_t as object (ssn number, name vacrhar2(30), address varchar2(100)not final;

create or replace type person_tab_ty as table of perosn_t;

create or replace type student_t under perdon_t(deptno number....);

create or replace type student_tab_t as table of student;

CREATE TABLE test (
regular_field DATE,
person_nested_tab person_tab_typ,
student_nested_tab student_tab_typ)
NESTED TABLE person_nested_tab STORE AS per_tab
NESTED TABLE student_nested_tab STORE AS stu_tab;

why we create table use this nested table .

in type specification why we use not instantiate ? please tell me ?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 13 2011
Added on Mar 14 2011
8 comments
1,005 views