OraFAQ Forum: General » Table information in database.

Home » Other » General » Table information in database.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Table information in database. [message #103281]

Wed, 16 April 2003 16:43

Manu
Messages: 5
Registered: February 2002

Junior Member

Hi,

My database is having a table called "tab" that contains names of all the tables and their type. Are their any command to display the column names of table wise. There are 40 tables, so I can not do "desc tablename" that many times. Is there any short procedure.

waiting for reply.
Manu

Report message to a moderator

Re: Table information in database. [message #103282 is a reply to message #103281]

Mon, 21 April 2003 05:25

Annamalai.P
Messages: 1
Registered: April 2003

Junior Member

Hi Manu,

Use the table "COLS" which provides information with regard to tablename,column,datatype,nullable etc... available in a schema.

regards
Annamalai.P

Report message to a moderator

Re: Table information in database. [message #103293 is a reply to message #103281]

Mon, 05 May 2003 04:55

Sheshadri
Messages: 12
Registered: June 2002

Junior Member

You can use the following query and execute it in SQL Prompt by selecting all the results of query at a time.

sql> Select 'Desc ' || tname from tab;

This will fetch you 40 rows and looks like

Desc tab1
Desc tab2....

Now select all these 40 rows and paste it in sqlprompt at a time.

Report message to a moderator

Previous Topic:	Oracle11i
Next Topic:	I NEED TO KNOW

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 08:59:38 CST 2024