Home » SQL & PL/SQL » SQL & PL/SQL » Insert into table
Insert into table [message #299075] Fri, 08 February 2008 21:10 Go to next message
Messages: 1
Registered: February 2008
Junior Member
hi there
how can i insert '&pen' in a table field using sql language.
always it is taking it as a subsituation variable. but if a
want &pen as a table field value how can i do it?
Re: Insert into table [message #299077 is a reply to message #299075] Fri, 08 February 2008 21:45 Go to previous messageGo to next message
Messages: 247
Registered: September 2006
Location: New Delhi
Senior Member
set define off

Re: Insert into table [message #299111 is a reply to message #299075] Sat, 09 February 2008 08:22 Go to previous message
Messages: 13
Registered: April 2007
Junior Member
Also can use escape character. But set define off is a better solution
Previous Topic: Using Variables with SQL
Next Topic: Update values
Goto Forum:

Current Time: Sun Jul 23 16:11:21 CDT 2017

Total time taken to generate the page: 0.87554 seconds