wah... harus di drop dulu yah tablenya? ada cara lain yang ga pake drop? ----- Original Message ----- From: Firman H.M. To: [email protected] Sent: Tuesday, May 01, 2007 2:53 PM Subject: Re: [indo-oracle] Menyisipkan field baru pada tabel
create table y_temp as select field1,field2,...,fieldx-1,'test' as nama_field,field(x+1),...,field(n) from y drop table y alter table y_temp rename to y update y set nama_field=null alter table y modify column nama_field new_type_data 2007/5/1, Oscar Wilyanto <[EMAIL PROTECTED]>: > > Dear Masters, > > Saya ingin menyisipkan sebuah field baru pada tabel, bagaimana yah > sintaxnya, yang saya bisa sekarang ini hanya menambahkan field, bukan > menyisipkan (pakai alter table y add xxx). > > Thanks in Advance, > 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] ------------------------------------------------------------------------------ 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]
