-- ci sono sicuramente alternatie meno contorte:
-- un alternativa è quella di gestire le informazioni risultanti da DESC NOME_VISTA.

SELECT
v.view_name,
k.obj_num,
o.object_id,
k.name,
k.type_num,
DECODE(k.type_num,96,'CHAR',2,'NUMBER',1,'VARCHAR2',12,'DATE'),
k.length,scale
-- k.not_null
FROM
dba_views v, dba_objects o,
sys.KU$_COLUMN_VIEW k
WHERE
v.view_name = o.object_name AND
o.owner='NOMEOWNER' AND
k.obj_num = O.object_id AND view_name='NOMETABELLA'
GROUP BY
v.view_name,
k.obj_num,
o.object_id,
k.name,
k.type_num,
k.length,scale
-- k.not_null
ORDER BY v.view_name