Code:
         SELECT SYS_CONTEXT('USERENV','DB_NAME') FROM dual;
Sam