wah, terimakasih para master's.. soalnya lagi mau design sistem nih. :) klo bgtu brrti kudu pake design struktural deh.
ternyata coding yg gw buat masih struktural. brrti masih harus byk belajar OOP di Oracle. ( soalnya br kali ini liat struktur koding OOP di oracle, padahal udh lama bgt pke oracle :D ). trimakasih buat info2nya. :) Thanks, Bati Firdaus K ________________________________ From: yulius_wibowo <[email protected]> To: [email protected] Sent: Tue, March 16, 2010 4:42:14 PM Subject: [indo-oracle] Re: Oracle itu OOP ato Struktural ? 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 indo-oracle@ yahoogroups. com, "yulius_wibowo" <yulius_wibowo@ ...> wrote: > > Kang Ujang... > Contoh yg diberikan bukan inheritance, tapi Overloading. .. > > Bowo > > --- In indo-oracle@ yahoogroups. 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 indo-oracle@ yahoogroups. 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: indo-oracle- unsubscribe@ yahoogroups. com > > > Website: http://indooracle. wordpress. com > > > http://www.facebook .com/group. php?gid=51973053 515 > > > ------------ --------- --------- --------- -------- > > > > > > 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] > > > [Non-text portions of this message have been removed]
