untuk melihat tabel lain di user lain silahkan pake DBA_TAB_COLS,
tentunya harus login sbg user yang mempunyai akses sbg DBA
> 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
>
> Messages in this topic (0) 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
> Yahoo! Finance
> It's Now Personal
> Guides, news,
> advice more.
> Yahoo! HotJobs
> Career change time?
> Explore companies
> and new careers
> New web site?
> Drive traffic now.
> Get your business
> on Yahoo! search.
