select *
from INFORMATION_SCHEMA.COLUMNS
order by TABLE_NAME, ORDINAL_POSITION
--
Tony Rogerson, SQL Server MVP
http://sqlblogcasts.com/blogs/tonyrogerson
[Ramblings from the field from a SQL consultant]
http://sqlserverfaq.com
[UK SQL User Community]
"Mark D Powell" <Mark.Powell_at_eds.com> wrote in message
news:1186953426.039369.194760_at_j4g2000prf.googlegroups.com...
> On Aug 12, 2:04 pm, carnahan...._at_gmail.com wrote:
>> I am transitioning to Oracle from SQL Server using a poorly documented
>> application that uses Oracle 9 as its back end.
>>
>> SQL Server has a command that dumps the names of all Fields in all
>> Tables.
>>
>> Is there a similar command I can execute to do the same with Oracle?
>
> [Second attempt after Google posting error reported so if duplicate my
> apologies]
>
> I have ran queries to pull column information from the SQL Server
> dictionary tables but I was unaware of a command (procedure?) to dump
> all columns for all talbes, for future reference what is the command?
>
> -- Mark D Powell --
>
Received on Mon Aug 13 2007 - 15:47:43 CDT
