Home » RDBMS Server » Server Administration » How can I retrieve the number of columns for a particular table in SQL
How can I retrieve the number of columns for a particular table in SQL [message #371120] Thu, 31 August 2000 11:32 Go to next message
Andrew Barham
Messages: 1
Registered: August 2000
Junior Member
an ideas??

Report message to a moderator

Re: How can I retrieve the number of columns for a particular table in SQL [message #371121 is a reply to message #371120] Thu, 31 August 2000 12:27 Go to previous message
JOHN
Messages: 182
Registered: April 1998
Senior Member
select count(*) from all_tab_columns
where table_name = 'TABLENAME'

Report message to a moderator

Previous Topic: Does unique constraints decrease performance ?
Next Topic: Returning REF CURSORS of Oracle Stored Procedures
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 16 15:18:35 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.