Viewed 100K+ times! This question is You Asked Hi,I want to insert a values into a table as follows:create table test (name varchar2(35));insert into test values ('&Vivek');I tried the escape character '\' but the system asks for a value of the substitution variable.I also did a "set define off" but then also the system asks for a value in a window.I use Toad for Oracle 10" to interact with the database.Please help. and Tom said...Please ask the makers of toad how to turn off substitution variables in their product.What you did would work for our tool sqlplus - but not for someone else's tool called 'Toad' apparently. Rating (23 ratings)Is this answer out of date? If it is, please let us know via a Comment Comments Comment Just execute as a scriptG, March 15, 2012 - 10:51 am UTC
Toad for Oracle key
DOWNLOAD: https://urlcod.com/2vIx1G
2ff7e9595c
Comments