Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

ALTER SESSION SET NLS_DATE_FORMAT = 'yyyy-mm-dd HH24:MI:SS';
CREATE FUNCTION db_banner
RETURN VARCHAR2 DETERMINISTIC
IS
  v_version VARCHAR2(100);
BEGIN
  SELECT $IF DBMS_DB_VERSION.VERSION < 18
         $THEN banner
         $ELSE banner_full
         $END
  INTO   v_version
  FROM   v$version
  WHERE  ROWNUM = 1;

  RETURN v_version;
END;
/
SELECT * FROM USER_ERRORS;
SELECT db_banner()
FROM   dual


DB_BANNER()


Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production