Salam,
Teman-teman, ada gak yg punya pengalaman buat function
md5?
Ceritanya begini nih, aku khan mau buat rpocedure yg
nantinya akan isi di table users, dimana salah satu
field adalah dalam bentuk encrypt by md5.
Seperti ini nih:
CREATE OR REPLACE TRIGGER USER_TRG
AFTER INSERT ON M_PEGAWAI FOR EACH ROW
declare V_NIP varchar2(8);
BEGIN
V_NIP := md5(to_char(:new.tgllahir,'DD') ||
to_char(:new.tgllahir,'MM') ||
to_char(:new.tgllahir,'YYYY'));
insert into users ("USER_LOGIN", "USER_PWD",
"USER_NAME", "NIP", "LOK", "KDU1", "KDU2", "KDU3",
"KDU4") values (:new.NIP,V_NIP,:NEW.NAMA, :NEW.NIP,
:NEW.LOK, :NEW.KDU1, :NEW.KDU2, :NEW.KDU3, :NEW.KDU4);
END;
ada yg bisa bantu?
Nuhun,
Samsun
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
------------------------ Yahoo! Groups Sponsor --------------------~-->
Something is new at Yahoo! Groups. Check out the enhanced email design.
http://us.click.yahoo.com/SISQkA/gOaOAA/yQLSAA/PhFolB/TM
--------------------------------------------------------------------~->
--
-----------I.N.D.O - O.R.A.C.L.E---------------
Keluar: [EMAIL PROTECTED]
Website: http://indo-oracle.blogspot.com
Mirror: http://indooracle.wordpress.com
-----------------------------------------------
Bergabung dengan Indonesia Thin Client User Groups,
Terminal Server, Citrix, New Moon Caneveral, di:
http://indo-thin.blogspot.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/
