Home » SQL & PL/SQL » SQL & PL/SQL » how to insert 45&56&
how to insert 45&56& [message #185910] Fri, 04 August 2006 04:06 Go to next message
raom
Messages: 22
Registered: January 2006
Location: india
Junior Member
hi

i have a table with two columns row(number) and id(varchar20)

i need to insert these values into the table as below
insert into mytab(row,id) values(81,'54&56&67');

but i am gettig a promt for values like
Enter value for 46:
Enter value for 67:

where i dont this .

please suggest me a work around.
Re: how to insert 45&56& [message #185923 is a reply to message #185910] Fri, 04 August 2006 05:28 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
http://www.orafaq.com/faq/how_does_one_escape_special_characters_when_writing_sql_queries
Re: how to insert 45&56& [message #185952 is a reply to message #185923] Fri, 04 August 2006 08:25 Go to previous message
raom
Messages: 22
Registered: January 2006
Location: india
Junior Member
wow!! one more piece to learn oracle
thank you Frank.
Previous Topic: Help me regarding this query
Next Topic: Trigger Execution failed
Goto Forum:
  


Current Time: Sat Dec 03 08:10:54 CST 2016

Total time taken to generate the page: 0.21798 seconds