Setahu saya, perintah ALTER ... tidak bisa dijalankan di dalam PL/SQL Block, termasuk di dalam trigger.
Alternatif-nya, anda bisa menggunakan package DBMS_SESSION Bowo --- In [email protected], "Firman H.M." <[EMAIL PROTECTED]> wrote: > > create or replace trigger > different_date > AFTER LOGON ON DATABASE > BEGIN > if user='A' then > alter session set nls_date_format = 'dd-mm-yyyy'; > else > alter session set nls_date_format = 'yyyy-mm-dd'; > end if; > END; > / > > CMIIW > > 2007/1/25, Oscar Wilyanto <[EMAIL PROTECTED]>: > > > > Dear Masters, > > > > Mau tanya, apakah di Oracle tipe data 'date' bisa di pre-set formatnya? > > > > jadi misalnya di database A format tanggalnya 25-12-2006, sedangkan di > > database B format tanggalnya bisa 2006-12-25. > > > > Kalau ya, bagaimana cara men-setnya? > > > > Thanks, > > Oscar > > > > ---------------------------------------------------------- > > This message contains confidential information and is intended only for > > the > > individual named. If you are not the named addressee you should not > > disseminate, distribute or copy this e-mail. Please notify the sender > > immediately by e-mail if you have received this e-mail by mistake and > > delete > > this e-mail from your system. E-mail transmission cannot be guaranteed to > > be > > secure or error-free as information could be intercepted, corrupted, lost, > > destroyed, arrive late or incomplete, or contain viruses. MKD Group > > therefore > > does not accept liability for any errors or omissions in the contents of > > this > > message, which arise as a result of e-mail transmission. If verification > > is > > required please request a hard-copy version. > > > > MKD Group, www.mkdgroup.com > > ---------------------------------------------------------- > > > > [Non-text portions of this message have been removed] > > > > > > > > > > -- > Firman HM > PT. Xsis Mitra Utama > Graha BIP 7th Floor Jl. Jend. Gatot Subroto Kav.23 Jakarta 12930 - > Indonesia > Tel : +62-21-5210565 Hotline : +62-21-5210564 Fax : +62-21- 5229777 > > > [Non-text portions of this message have been removed] >
