Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: SQL Plus Question
Walter,
Maybe I asked the wrong question. I did get output with dba privileges, but it isn't what I was looking for.
What's the easiest way to display the structure (column headings would be fine) of all the tables in a database (if I don't know their names)? For example, assume you were just handed a new database and you want to list the tables and the format of each table in the database.
Thanks for the help,
Mark
"Walter T Rejuney" <BlueSax_at_Unforgetable.com> wrote in message
news:3A54CA88.6CE885DB_at_Unforgetable.com...
> Mark Riehl wrote:
> >
> > All,
> >
> > Easy question. What SQL Plus command can I use to show me all of the
tables
> > in a database? I'm looking for the Oracle equivalent of relshow in
MySQL or
> > mSQL.
> >
> > Thanks,
> > Mark
>
> Assuming you are logged in with dba priviledges:
>
> select owner||'.'||table_name
> from dba_tables
> order by 1;
>
> It isn't a sqlplus command though - sqlplus itself has no awareness of
> the database. It is just a client application that passes dml,dcl, ddl,
> etc and formats the output.
Received on Thu Jan 04 2001 - 13:26:37 CST
![]() |
![]() |