The Oracle data dictionary contains pretty much everything. The table you're looking for is ALL_TAB_COLUMNS in this case, assuming you're working with tables.
>I'm not big on oracle so I don?t know if you have something similar to the >schema info tables in MSSQL but I believe that DESCRIBE will work in >Oracle... according to google anyway :-) > >.:.:.:.:.:.:.:.:.:.:.:. >Bobby Hartsfield >http://acoderslife.com > > > > > >-----Original Message----- >From: daniel kessler [mailto:[EMAIL PROTECTED] >Sent: Thursday, December 07, 2006 9:26 AM >To: CF-Talk >Subject: Re: Determine database field type > >Oracle - I almost always say so, but forgot this time. oops. > >>No one ever says what database they are using :-) >> >> >>.:.:.:.:.:.:.:.:.:.:.:. >>Bobby Hartsfield >>http://acoderslife.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263152 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4