Home » SQL & PL/SQL » Client Tools » insert & in table
insert & in table [message #243395] Thu, 07 June 2007 03:48 Go to next message
reyazan
Messages: 53
Registered: February 2005
Member
how i use below statement in oralce 8i
insert into table values ('SSS & nnn')


pls help
Re: insert & in table [message #243398 is a reply to message #243395] Thu, 07 June 2007 03:57 Go to previous messageGo to next message
ammishra
Messages: 179
Registered: January 2007
Location: india
Senior Member
have you run this statment on oracle 8i ?
have you got any error if yes please past?

--Yash
Re: insert & in table [message #243409 is a reply to message #243395] Thu, 07 June 2007 04:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
set define off

Regards
Michel
Re: insert & in table [message #243421 is a reply to message #243395] Thu, 07 June 2007 04:39 Go to previous messageGo to next message
saibal
Messages: 111
Registered: March 2007
Location: India
Senior Member
sys@DBASE-SQL>>set escape on
sys@DBASE-SQL>>sho escape
escape "\" (hex 5c)
sys@DBASE-SQL>>select 'you \& me' from dual;

'YOU&ME'
--------
you & me

sys@DBASE-SQL>>
Re: insert & in table [message #243427 is a reply to message #243421] Thu, 07 June 2007 04:54 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
And closed. Hit search for more possibilities.

http://www.orafaq.com/forum/fa/448/0/

MHE
Previous Topic: SQL Plus 8.0
Next Topic: oracle report
Goto Forum:
  


Current Time: Sat Dec 03 20:13:07 CST 2016

Total time taken to generate the page: 0.06679 seconds