OraFAQ Forum: Server Administration

Thu, 11 January 2001 22:49

srikantha
Messages: 3
Registered: December 2000

Junior Member

what is the queary for get the number of columns of the table in sql prompt.

Fri, 12 January 2001 03:16

John R
Messages: 156
Registered: March 2000

Senior Member

Yuo want to look at the views All_Tab_Columns and User_Tab_Columns.

Try:

Select Count(*)
From user_tab_columns
where table_name = Your_table

Previous Topic:	query
Next Topic:	queary

Goto Forum:

]

Current Time: Sat May 18 00:01:20 CDT 2024