Home » RDBMS Server » Server Administration » How to describe all the tables from tab?
How to describe all the tables from tab? [message #371986] Mon, 01 January 2001 05:53 Go to next message
Satya
Messages: 36
Registered: January 2001
Member
How to describe all the tables from tab?
describe all the tables with table name
as the heading.(script)

Report message to a moderator

Re: How to describe all the tables from tab? [message #371988 is a reply to message #371986] Mon, 01 January 2001 23:49 Go to previous message
Vince
Messages: 11
Registered: December 2000
Junior Member
Hi,

I hope this is what you wanted!!!

Spool Result.sql
Select ' Prompt ' || TNAME || Chr(10) || ' Desc ' || TName From Tab
Spool Off

@Result.sql

Give it a Try, iam not sure with your question, if this is not the case, could you be more specific with your question!!

Cheers,

Vince.

Report message to a moderator

Previous Topic: loading excel data into oracle database
Next Topic: Select unique rows from one table to other
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 17 15:07:20 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.