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??
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'
Previous Topic: Does unique constraints decrease performance ?
Next Topic: Returning REF CURSORS of Oracle Stored Procedures
Goto Forum:
  


Current Time: Tue Oct 20 09:59:32 CDT 2020