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
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indo-oracle/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/indo-oracle/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
