mardi 9 août 2011

Oracle11g : How to obtain the name of all views defined in the database

To retrieve the name of all views in database, use the following command under SqlPlus :
SQL>select * from V$FIXED_TABLE;