How to return different columns from the same table based on Oracle database version? (banner vs banner_full in v$version)
I need to return the BANNER_FULL column from v$version if the database version is 18+, otherwise return the BANNER column. Both exist in all versions, but banner is deprecated.