-- Author: 	Ahbaid Gaffoor - OCPdba.Net
-- File:        setprompt.sql
--
-- Purpose:     Call this script from the SQL prompt to have it reflect your current schema and database connection
--
-- Usage:	@setprompt


set termout off
column iam new_value myprompt noprint;
select whoami||'> '  as iam from dual;
set sqlprompt "&&myprompt"
set termout on