Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

NEWBIE Question

Status
Not open for further replies.
skapsak

skapsak

Technical User
Apr 3, 2000
10
US
If I know the table names in an Oracle database is there a way I can find out the field names and data types without having to go to the data model?
 
Sort by date Sort by votes
Run the following:<br><br>desc [your table name]<br><br><br>Cal
 
Upvote 0 Downvote
You can also info with the following query:<br><FONT FACE=monospace>select * from all_tab_columns<br>where&nbsp;&nbsp;owner = '&table_owner'<br>and&nbsp;&nbsp;&nbsp;&nbsp;table_name = '&table_name';</font>
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Jewel142
  • Locked
  • Question
Newbie to Sql Subqueries
Replies
3
Views
283
Jewel142
Jewel142
JazzMaan
  • Locked
  • Question
Group by question
Replies
7
Views
328
JazzMaan
JazzMaan
mark1110
  • Locked
  • Question
Group By Question
Replies
1
Views
204
JarlH
JarlH
vengelus82
  • Locked
  • Question
Rescue this newbie
2
Replies
21
Views
744
vengelus82
vengelus82
mark1110
  • Locked
  • Question
Update Question
Replies
3
Views
201
PHV
PHV

Part and Inventory Search

Sponsor

Back
Top