Path: news.cambrium.nl!textnews.cambrium.nl!feeder1.cambriumusenet.nl!feeder3.cambriumusenet.nl!feed.tweaknews.nl!postnews.google.com!u7g2000vbq.googlegroups.com!not-for-mail From: Rich Newsgroups: comp.databases.oracle.misc Subject: Select statement that returns field size? Date: Wed, 5 May 2010 11:05:50 -0700 (PDT) Organization: http://groups.google.com Lines: 10 Message-ID: NNTP-Posting-Host: 74.68.58.138 Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 X-Trace: posting.google.com 1273082750 30040 127.0.0.1 (5 May 2010 18:05:50 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Wed, 5 May 2010 18:05:50 +0000 (UTC) Complaints-To: groups-abuse@google.com Injection-Info: u7g2000vbq.googlegroups.com; posting-host=74.68.58.138; posting-account=aPtDgAkAAADdNn6md5GF0EGsEA6kDBmT User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; GTB6.4; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729),gzip(gfe) Xref: news.cambrium.nl I am using 10g. I want to do a select statement that will give me the name of the fields in a table. And I also want to know the field type and field size. Can this be done? Regards