Hello,
I wrote these commands with "set verify on" (which is default)
SQL> define majorValue = 'Music';
SQL>select * from students where "major" = '&majorValue';
The result that I get is:
old 1: select * from students where "major" = '&majorValue'
new 1: select * from students where "major" = 'Music'
id first_name last_name
---------- -------------------- --------------------
major current_credits
------------------------------ ---------------
10007 David Dinsmore
Music 4
10009
Rose Riznit
Music 7
But if I give the same commands with "set verify off", the response that I get is:
id first_name last_name
---------- -------------------- --------------------
major current_credits
------------------------------ ---------------
10007 David Dinsmore
Music 4
10009 Rose Riznit
Music 7
Only difference is that in the second case it doesn't show the old and new values, that means the one with the variable and then with the replaced variable name with the value.
old 1: select * from students where "major" = '&majorValue'
new 1: select * from students where "major" = 'Music'
IT won;t make any difference in the output that you get but its just for you to see which variable is getting replaced by which value.
I hope this helps.
Vibha.