oracle - How can i "Clean" output from sqlplus query? -
i have got simple query , need 1 value = valid
the query is:
select 'value('||status||')' value user_indexes index_name = '&1';
but hve got in out:
c:\program files\zabbix\bin\win64\oracle>sqlplus -s @"c:\program files\zabbix\bi n\win64\oracle\conn2.sql" olaptablevelsid old 1: select status user_indexes index_name = '&1' new 1: select status user_indexes index_name = 'olaptablevelsid' valid
what old , new strings? how can dismiss it?
thank you.
set verify off
should you. please add such line in script before query.
Comments
Post a Comment