You could play around with this: SELECT * FROM all_tab_columns shows all columns in every table, along with the datatype of each column. just set your where clause
-----Original Message----- From: Gormley Patrick-r34220 [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 08, 2003 8:20 PM To: CF-Talk Subject: Oracle Data Types Hi, Is there a way get a columns data type from a cfquery ? Or a query that outputs column names and data types? -Patrick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
