Mungkin bisa diakalin di pasang di trigger table before insert/update Ini contohnya nama table MYTABLE dan nama column KOLUM. semoga membantu salam, edys-- ------------------- contoh script--------------------- CREATE OR REPLACE TRIGGER "TR_BI_MYTABLE" BEFORE INSERT ON MYTABLE
REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW BEGIN -- SEBELUM INSERT DIBATASI MAX 65 :NEW.KOLUM := SUBSTR(:NEW.KOLUM,1,65) END; CREATE OR REPLACE TRIGGER "TR_BU_MYTABLE" BEFORE UPDATE ON MYTABLE REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW BEGIN -- SEBELUM UPDATE DIBATASI MAX 65 :NEW.KOLUM := SUBSTR(:NEW.KOLUM,1,65) END; -------------------------------------------------------------------------- On 9/7/05, Kiki Kuswara <[EMAIL PROTECTED]> wrote: > > Balik tanya nih, > > Kasusnya di form atau secara dml (sql Plus)? > > Salam, > > Kiki Kuswara > > > Dear all, > > > > Langsung aja saya punya problem dimana saya punya table salah satu > > kolomnya sudah di set max lenght 225 char. tapi Sekarang ini saya mau > agar > > isi kolom tersebut max 60 char. Kira-kira ada yang tau ga gimana caranya > > saat user isi kolom tersebut lebih dari 60 maka user tidak bisa ketik > > lagi > > > > Thanks banget ya buat bantuan teman2 semua > > > > Salam, > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > -- > > -----------I.N.D.O - O.R.A.C.L.E--------------- > > Keluar: [EMAIL PROTECTED] > > Website: http://indo-oracle.lizt.org (NEW) > > ----------------------------------------------- > > > > Bergabung dengan Indonesia Thin Client User Groups, > > Terminal Server, Citrix, New Moon Caneveral, di: > > http://indo-thin.vze.com > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > -- > -----------I.N.D.O - O.R.A.C.L.E--------------- > Keluar: [EMAIL PROTECTED] > Website: http://indo-oracle.lizt.org (NEW) > ----------------------------------------------- > > Bergabung dengan Indonesia Thin Client User Groups, > Terminal Server, Citrix, New Moon Caneveral, di: > http://indo-thin.vze.com > Yahoo! Groups Links > > > > > > > > [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/PhFolB/TM --------------------------------------------------------------------~-> -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.lizt.org (NEW) ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> 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/
