solusi lain : kolom tetap ditambahkan seperti biasa, kemudian buat view agar urutan kolom sesuai keinginan.
CMIIW 2007/5/1, Oscar Wilyanto <[EMAIL PROTECTED]>: > > wah... harus di drop dulu yah tablenya? ada cara lain yang ga pake drop? > > ----- Original Message ----- > From: Firman H.M. > To: [email protected] <indo-oracle%40yahoogroups.com> > 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] <oscar%40mkdgroup.com>>: > > > > 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] > > > -- 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]
