How can I find out which table/tables are behind a view?
I tried following with scott/tiger:
SQL> select text from all_views where view_name = 'TAB';
TEXT
---------------------------------------------------------
select o.name,
decode(o.type#, 2, 'TABLE', 3, 'CLUSTER',
4,
The text after "4," is not displayed in SQL*Plus-Editor. The attribut TEXT with datatype long is not displayed fully on the screen. How can I correct it? Thank You!