Query to find database name and username with using Oracle package.

This query will tell you the name of the database that you use and the username that you use to query the database currently.
SQL>select dbms_standard.database_name DB_NAME,
dbms_standard.login_user USERNAME from dual;

With Regards
Vijay Kaushik