Re: Transitioning to Oracle: How can you list out the names of all tables and fields?

Home -> Community -> Usenet -> c.d.o.server -> Re: Transitioning to Oracle: How can you list out the names of all tables and fields?

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Sun, 12 Aug 2007 14:17:06 -0700
Message-ID: <1186953426.039369.194760@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 Sun Aug 12 2007 - 16:17:06 CDT