OraFAQ Forum: Server Administration » calculating maximum row size....

Home » RDBMS Server » Server Administration » calculating maximum row size....

Wed, 13 June 2001 10:55

Jared
Messages: 10
Registered: June 2001

Junior Member

Anybody know how to get the maximum row size of a table with SQL?

Thanks in advance,
Jared

Wed, 13 June 2001 15:47

Bala
Messages: 205
Registered: November 1999

Senior Member

Hi

select max(length(col1 || col2 || col3....)) from t;

should do it..

Bala.

Previous Topic:	How to store a Lotus Notes-file?
Next Topic:	sql on desk top at home, personal edition

Goto Forum:

]

Current Time: Thu Jul 04 20:52:13 CDT 2024