Tuesday, April 20, 2004
SQLPLUS problem with & Ampersands
If you need to load a script through SQLPlus that has ampersands, then use the command
SET SCAN OFF
to disable interpretation of the &.
If you don't you can't INSERT strings such as "Andrew & Susan" because SqlPlus will interpret the ampersand as a prompt.
SET SCAN OFF
to disable interpretation of the &.
If you don't you can't INSERT strings such as "Andrew & Susan" because SqlPlus will interpret the ampersand as a prompt.
