All geek questions in one place

OLD: and NEW:

I am using Oracle SQL Developer.

I am using options &TableName

My query comes back to me in the results with the OLD tag : in front of it and again with the New: tag (the variable is replaced by the value that I typed), and then my results follow this.

How do I get rid of this annoying comeback and change it to just display my results?

+3
source share
1 answer

In SQL * Plus, I think you mean it SET VERIFY OFF. I do not have SQL Developer to test it the same way, but I would think so.

, , , SQL Developer.

define tmpVar='test'

set verify on

select '&tmpVar' from dual;

set verify off

select '&tmpVar' from dual;

:

old:select '&tmpVar' from dual
new:select 'test' from dual
'TEST' 
------ 
test   

'TEST' 
------ 
test

@a_horse_with_no_name .

+4

Source: https://habr.com/ru/post/1766063/

More articles:


All Articles