OraFAQ Forum: Client Tools » insert & in table

Home » Other » Client Tools » insert & in table

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

insert & in table [message #243395]

Thu, 07 June 2007 03:48

reyazan
Messages: 53
Registered: February 2005

Member

how i use below statement in oralce 8i
insert into table values ('SSS & nnn')

pls help

Report message to a moderator

Re: insert & in table [message #243398 is a reply to message #243395]

Thu, 07 June 2007 03:57

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

Report message to a moderator

Re: insert & in table [message #243409 is a reply to message #243395]

Thu, 07 June 2007 04:13

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

set define off

Regards
Michel

Report message to a moderator

Re: insert & in table [message #243421 is a reply to message #243395]

Thu, 07 June 2007 04:39

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>>

Report message to a moderator

Re: insert & in table [message #243427 is a reply to message #243421]

Thu, 07 June 2007 04:54

Maaher
Messages: 7065
Registered: December 2001

Senior Member

And closed. Hit search for more possibilities.

MHE

Report message to a moderator

Previous Topic:	SQL Plus 8.0
Next Topic:	oracle report

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 06 17:03:05 CST 2024