Welcome to Oracle Communities
Register and Participate in Oracle's online communities. Learn from thousands of experts, get answers to your questions and share knowledge with peers.
I load the northwind schema data with the SQdeveloper 19.2.1 into the DB per SQL window and
<insert .. value( ' .. & .. ' )> the 'Enter Substituation Alert' alert:
The & symbol is being interpreted as an SQL*Plus input variable.
You can turn it off by running:
set define off
I don't know if there is an option to set the default it to "OFF".
to make it default behavior, add it to your startup script
Thanks, Jeff & Mike.