hmmmm ta kirain yg bagian ini inheritance juga....
subtype tJob is varchar2(64); type tArrayJob is table of tJob index by pls_integer; type tArraySeqByJob is table of number index by tJob; eh ternyata ada keyword "under" juga to... sejak oracle versi piro ya pak lik? 2010/3/16 yulius_wibowo <[email protected]> > > > > 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] <indo-oracle%40yahoogroups.com>, > "yulius_wibowo" <yulius_wib...@...> wrote: > > > > Kang Ujang... > > Contoh yg diberikan bukan inheritance, tapi Overloading... > > > > Bowo > > > > --- In [email protected] <indo-oracle%40yahoogroups.com>, > "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><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]<indo-oracle-unsubscribe%40yahoogroups.com> > > > > 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] > > > > > > > > -- thanks and regards ujang | oracle dba | mysql dba jakarta - indonesia [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 <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/indo-oracle/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
