/* Formatted on 2010/10/28 9:25:00 (QP5 v5.163.1008.3004) */
SELECT owner,
table_name,
column_name,
data_type,
data_length,
SUM (
CASE data_type
WHEN 'DATE' THEN 7
WHEN 'NUMBER' THEN 22
ELSE data_length
END)
LENGTH
FROM all_tab_cols
WHERE table_name = UPPER ('T_MSG_ALARMINFO')
AND owner = UPPER ('lbs')
GROUP BY ROLLUP ( (owner, table_name, column_name, data_type, data_length))
SELECT owner,
table_name,
column_name,
data_type,
data_length,
SUM (
CASE data_type
WHEN 'DATE' THEN 7
WHEN 'NUMBER' THEN 22
ELSE data_length
END)
LENGTH
FROM all_tab_cols
WHERE table_name = UPPER ('T_MSG_ALARMINFO')
AND owner = UPPER ('lbs')
GROUP BY ROLLUP ( (owner, table_name, column_name, data_type, data_length))