DB General Info

Create Or Replace Force View Sys.Av_db_gen_info (Db_info)
As
   Select '01- ' || Banner Db_info
     From Sys.V_$version

   Union
   Select '02- ****************************************************'
     From Dual
   Union
   Select '03-    The ' || Parameter || ' option is not installed'
     From Sys.V_$option
    Where Value <> 'TRUE'
   Union
   Select '04- ****************************************************'
     From Dual
   Union
   Select '05-   With the ' || Parameter || ' option'
     From Sys.V_$option
    Where Value = 'TRUE';