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

Popular posts from this blog

account - Script error login visual studio DefaultLogin_PCore.js -

xcode - CocoaPod Storyboard error: -