Uppercase PROMPT value in SQLPlus? Possible? 2

[MCubitt]

Rather than use
upper(&value)
throughout an SQL statement for a PROMPTed value, is there a way to change it once?

I.e.

prompt Enter value: &&value
newvalue = upper(&value)

select * from table where column1=newvalue or column7=newvalue


Thanks

(In SQLPlus, not PL/SQL)



There's no need for sarcastic replies, we've not all been this sad for that long!

 

[sem]

You may declare bind variable and then use it:

SET FEEDBACK OFF
var uValue VARCHAR2(256)
EXEC :uValue := UPPER('&value')


select :uValue from dual

Regards, Dima

http://seminihin.narod.ru

 

[MCubitt]

Bravo! Thank U!


There's no need for sarcastic replies, we've not all been this sad for that long!