I am trying to achieve this.
This is my code
var cvar varchar2(20)
exec :cvar := 'variable value'
print cvar
This is the current output
PL/SQL procedure successfully completed.
CVAR
--------------------------------------------------------------------------------
variable value
I want to output only the variable value. Not its name or any other output
variable value
I tried all these settings. no luck
SET DEFINE on
SET HEADING OFF
SET VERIFY OFF
SET FEEDBACK ON
SET ECHO OFF
SET PAGESIZE 0
SET TRIMS ON
SET PAGES 1000
SET APPINFO OFF
SET TIME OFF
SET TIMING OFF
SET TERMOUT ON
SET TRIMS ON
It is
set heading off: