Home » SQL & PL/SQL » SQL & PL/SQL » & in insert statement (oracle 10g)
& in insert statement [message #406629] Fri, 05 June 2009 01:29 Go to next message
swas_fly
Messages: 220
Registered: March 2008
Location: Bhubaneswar
Senior Member
All

How can i insert these values correctly into the table

if i just write it as it is it is taking w as a variable and prompting me for the value.

Please advice

INSERT INTO B_TAB VALUES(23,'c&w (volvo, thus)','C&W (VOLVO, THUS)');
Re: & in insert statement [message #406630 is a reply to message #406629] Fri, 05 June 2009 01:31 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
You better check the FAQ before posting.

By
Vamsi
Re: & in insert statement [message #406631 is a reply to message #406629] Fri, 05 June 2009 01:31 Go to previous message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is a FAQ.
With 200+ posts you should know how to search.

Regards
Michel
Previous Topic: Dynamic Using for Execute Immediate
Next Topic: Performance Imorvement for Oracle Query
Goto Forum:
  


Current Time: Sun Dec 11 04:24:13 CST 2016

Total time taken to generate the page: 1.03437 seconds