user_tab_cols seharusnya USER_TAB_COLUMNS. klo pake user_tab_columns hanya bisa liat deskripsi dari tabel2 user tersebut aja (untuk liat default value, silahkan tambahkan kolom DATA_DEFAULT di select statement), tetapi tidak bisa melihat deskripsi dari tabel2 user lain..
Klo mau liat deskripsi table2 dari semua user bisa ambil data2nya dari tabel ALL_TAB_COLUMNS. CMIIW On 5/9/07, master of mobility <[EMAIL PROTECTED]> wrote: > Hello Oscar, > > coba pake query ini: > Select TABLE_NAME,COLUMN_NAME,DATA_TYPE,DATA_LENGTH > from user_tab_cols > where TABLE_NAME = 'nama_tabel'; > > Semoga bermanfaat, > > Master of Mobility > > > > > > > > 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] > > > > > > > Messages in this topic (1) Reply (via web post) | Start a new > > topic > > > Messages | Files | Photos > > > -- > > -----------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 > > > > Change settings via the Web (Yahoo! ID required) > > Change settings via email: Switch delivery to Daily Digest | Switch format > > to Traditional > > Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe > > > > > > Recent Activity > > > > 11 > > > New Members > > > Visit Your Group > > > SPONSORED LINKS > > > > Thin client server Database marketing software Database > > management software Online database software Customer database > > software > > > > > > Career Change > > > Yahoo! HotJobs > > > Search Jobs > > > Find the right one > > > > > Yahoo! Finance > > > It's Now Personal > > > Guides, news, > > > advice more. > > > > > New web site? > > > Drive traffic now. > > > Get your business > > > on Yahoo! search. > > > > > > > > > -- > -----------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 > > > > -- Regards, Edi Yanto PT. Jati Piranti Solusindo (Jatis Solutions) Menara Jamsostek, Tower A, 16th floor Jl. Jend. Gatot Subroto Kav.# 38 Jakarta Selatan, 12930 - Indonesia my blog: http://ediyanto83.wordpress.com
