This is one I used awhile back and gives you information on what the columns are as well.
SELECT TNAME, CNAME, COLTYPE, WIDTH, NULLS, DEFAULTVAL, SCALE FROM COL ORDER BY TNAME On 7/31/06, Deanna Schneider <[EMAIL PROTECTED]> wrote: > > Um, why not use the data dictionary to get the columns as well as the > tables: > > select o.object_name, c.column_name, c.data_type > from user_objects o, user_tab_columns c > WHERE o.object_name = c.table_name > Order by object_name > > On 7/31/06, Terry C. Mergl <[EMAIL PROTECTED]> wrote: > > Good morning everyone. > > As a novice with CF and newly introduced to one of our Oracle servers, > I'm > > having to rely on a cf query to find the tables and fields that way. > > I can successfully run a query and list all of my tables, but when I go > one > > step further to list the fields, it is either timing out or stopping > about a > > quarter of the way through and I'm not sure what to do or go from here. > > > > Any advice greatly appreciated. > > Terry > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > > Terry C. Mergl - MCSE, CNA, WCSPV > > Darien Telephone Co. > > 1011 North Way > > Darien, GA 31305 > > 912-437-6677 voice > > 912-270-0505 mobile > > [EMAIL PROTECTED] > > Network Administrator > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > > > > > > This e-mail message and any attachments may be confidential, proprietary > or > > privileged information. If you are not the intended recipient, or a > person > > responsible for delivering it to an intended recipient, any unauthorized > > review, disclosure, use or distribution is prohibited. If you are an > > unintended recipient, please delete this information from your computer > and > > contact Darien Telephone Co., immediately by replying to this message or > by > > sending e-mail to [EMAIL PROTECTED] Thank you. > > > > -- > > No virus found in this outgoing message. > > Checked by AVG Free Edition. > > Version: 7.1.394 / Virus Database: 268.10.5/403 - Release Date: > 7/28/2006 > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248243 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
