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
onlineami2008
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
mshrkshl
Messages: 247
Registered: September 2006
Location: New Delhi
Senior Member
set define off

regards,
Re: Insert into table [message #299111 is a reply to message #299075] Sat, 09 February 2008 08:22 Go to previous message
dba_bng
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 Dec 04 15:00:37 CST 2016

Total time taken to generate the page: 0.16531 seconds