Quotidien Shaarli

Tous les liens d'un jour sur une page.

October 15, 2014

12c: DISPLAY CDB/PDB NAME IN SQL PROMPT - ORACLE IN ACTION

define gname=idle
column global_name new_value gname
set heading off
set termout off
col global_name noprint
select upper(sys_context ('userenv', 'con_name') || '@' || sys_context('userenv', 'db_name')) global_name from dual;
set sqlprompt '&gname> '
set heading on
set termout on