The SET VERIFY command controls whether or not SQLPlus displays before and after images of each line that contains a substitution variable1. The correct answers to your question are B and E. The SET VERIFY ON command will enable the display of any substitution variable used in our last executed SQL statement. When you use the DEFINE clause to create a variable, and the variable is not used in the next SQL statement then that variable will not be “shown” by the SET VERIFY command2. It can be used in both SQL Developer and SQLPlus.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
maksud020
2 weeks, 1 day agoacd3ea6
2 months, 3 weeks agoShahedOdeh
2 months, 4 weeks agoArslanAltaf
8 months agohmatinnn
10 months, 2 weeks agoyaya32
11 months agoyanoolthecool
11 months, 2 weeks agojm9999
1 year, 2 months agojm9999
1 year, 2 months agoKizTine
1 year, 2 months agozouve
1 year, 5 months agozouve
1 year, 5 months agozouve
1 year, 5 months agoESZ
1 year, 6 months agoSantiBZ_07032022_1744
1 year, 11 months agoholdfaststrongly
2 years, 2 months agokarols32
2 years, 2 months agoKizTine
1 year, 2 months agoAveragenoob
2 years, 3 months ago