In Oracle PL/SQL, you can use the following commands to view table details:
The SET DEFINE
command changes the prefix character used to mark substitution variables. You can use SET DEFINE
to turn variable substitution off.
SET DEF[INE] {OFF | ON | prefix_char}
Define is a SQL*Plus client variable. It is NOT a database level setting.
When you start SQL*Plus, variable substitution will be on by default, and the default prefix character is an ampersand. If you are running a script that uses ampersands in text strings, you may want to change the prefix character to something else. If your script doesn’t use substitution variables, you may find it easiest to turn the feature off.
What are your thoughts on this post?
I’d love to hear from you! Click this link to email me—I reply to every message!
Also use the share button below if you liked this post. It makes me smile, when I see it.