Berikut contoh inheritance:
my_object --> test_object

create or replace type my_object as object(
a number,
b varchar2(10),
member function getA return number,
member function getB return varchar2
) NOT FINAL;
/

create or replace type body my_object as
member function getA return number is
begin
 return a;
end;
member function getB return varchar2 is
begin
 return b;
end;
end;
/

INHERIT from MY_OBJECT
----------------------

create type test_object under my_object (
c date,
member function getC return date
);
/

create or replace type body test_object as
member function getC return date is
begin
 return c;
end;
end;
/

Sekarang test_object memiliki member: a, b, & c, berikut member function 
getA(), getB() & getC()


Bowo

--- In [email protected], "yulius_wibowo" <yulius_wib...@...> wrote:
>
> Kang Ujang...
> Contoh yg diberikan bukan inheritance, tapi Overloading...
> 
> Bowo
> 
> --- In [email protected], "oracle@" <oracle@> wrote:
> >
> > kalau model begini inheritance bukan ya?
> > sorry rada ga mudheng dgn OOP :D
> > 
> > 
> > create or replace package Pkg_Jobs as
> > 
> >    subtype tString   is varchar2(30);
> >    subtype tJob      is varchar2(64);
> >    type tArrayJob is table of tJob index by pls_integer;
> >    type tArraySeqByJob is table of number index by tJob;
> > 
> >    procedure Execute(arg_job in tJob, arg_commit in boolean := true);
> >    procedure Execute (arg_jobs in tArrayJob, arg_commit in boolean := true);
> > end Pkg_Jobs;
> > /
> > 
> > 2010/3/16 Ratno Putro Sulistiyono <ratno@>
> > 
> > > nambahin,
> > > klo yang didatabase package bisa mirip seperti class, soalnya dalam 
> > > package
> > > bisa didefinisikan properties dan method (function ataupun procedure), dan
> > > bisa overloading juga tapi ga bisa inheritance.
> > > dan klo yg dimaksud oodb emang lebih ke arah tipe data, jadi bisa bikin
> > > tipe
> > > data sesuka hati seperti yang dijelasin bang bowo.
> > >
> > > regards,
> > > ratno
> > >
> > > 2010/3/16 yulius_wibowo <yulius_wibowo@>
> > >
> > > >
> > > >
> > > >
> > > > Utk pemrograman di Form/Report masih traditional/struktural.
> > > > Contoh:
> > > > Untuk merubah property dari sebuah block digunakan global procedure
> > > > SET_BLOCK_PROPERTY.
> > > > SET_BLOCK_PROPERTY('BLOCK123', QUERY_ALLOWED, PROPERTY_TRUE);
> > > > SET_BLOCK_PROPERTY('BLOCK456', QUERY_ALLOWED, PROPERTY_TRUE);
> > > >
> > > > Sedangkan utk pemrograman di dalam Oracle database-nya bisa traditional,
> > > > bisa juga OOP:
> > > > Utk yg traditional spt: PROCEDURE, FUNCTION , PACKAGE,...
> > > > Sedangkan utk yg OOP : TYPE (CREATE TYPE AS OBJECT ...)
> > > >
> > > > cmiiw,
> > > > Bowo
> > > >
> > > >
> > > > --- In [email protected] <indo-oracle%40yahoogroups.com>, Bati
> > > > Firdaus Kurniawan <bati_fk_1804@> wrote:
> > > > >
> > > > > Dear para master Oracle,
> > > > >
> > > > > Saya mau tanya. Sebenarnya coding Oracle di Form atau Report Developer
> > > > itu digolongkan ke OOP atau struktural yah?
> > > > > soalnya yang saya tau kalo OOP itu kan identik dengan "Class"..
> > > > >
> > > > > lalu kalau Oracle Databasenya sendiri termasuk OODB bukan yach?
> > > > >
> > > > > mohon penjelasan para master..
> > > > > Thanks,
> > > > >
> > > > > Bati Firdaus K
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > >
> > > >
> > > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > > --
> > > -----------I.N.D.O - O.R.A.C.L.E---------------
> > > Keluar: [email protected]
> > > Website: http://indooracle.wordpress.com
> > > http://www.facebook.com/group.php?gid=51973053515
> > > -----------------------------------------------
> > >
> > > Bergabung dengan Indonesia Thin Client User Groups,
> > > Terminal Server, Citrix, New Moon Caneveral, di:
> > > http://indo-thin.blogspot.comYahoo! Groups Links
> > >
> > >
> > >
> > >
> > 
> > 
> > -- 
> > thanks and regards
> > ujang | oracle dba | mysql dba
> > jakarta - indonesia
> > 
> > 
> > [Non-text portions of this message have been removed]
> >
>


Kirim email ke