Coba pake query ini, SELECT * FROM ALL_TAB_COLUMNS WHERE TABLE_NAME='NAMA_TABLE'
CMIIW firmanhm 2007/5/9, Oscar Wilyanto <[EMAIL PROTECTED]>: > > Dear Masters, > > Bagaimana cara untuk melihat field2 di table lengkap dengan default value > dari kolom tersebut. Kalau pakai 'describe' gak kelihatan default valuenya > soalnya. > > 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]
