Oracle: V$VERSION

select
   banner      -- 'Oracle%' or 'Personal Oracle%' or 'Oracle %Perf%' or …
   banner_full,
   regexp_replace(banner_full, '.*\n(.*)', '\1') banner_full_2nd_line,
   banner_legacy,
   con_id
from
   v$version;