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:248242 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
