Get database name in Oracle

SELECT *       FROM   v$database

Set define off to ignore the bind parameters when executing a procedure Oracle

set define off

/*

Define the PLSQL spec & body

*/


show errors
SET DEFINE '&'
exit