OraFAQ Forum: SQL & PL/SQL » using special characters with sql/plus

Home » SQL & PL/SQL » SQL & PL/SQL » using special characters with sql/plus

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

using special characters with sql/plus [message #11396]

Wed, 24 March 2004 14:24

Nathan Pohle
Messages: 2
Registered: March 2004

Junior Member

I am using Oracle 9i, release 2 in Windows and have been trying to insert this string, 'Leisure, Tourism, & Hospitality', into a column in one of my tables, using the�'insert' command in sql/plus�and whenever I try and do it, it comes back saying 'value for hospitality:'. Can anybody tell me how to do this, without getting this message. Thanks.

Report message to a moderator

Re: using special characters with sql/plus [message #11397 is a reply to message #11396]

Wed, 24 March 2004 14:46

Rajarshi Dasgupta
Messages: 52
Registered: October 2001

Member

This is happenning as you have '&' sign in your value. Use it in the following way...

set feedback off
set define off

Insert into .... ;
Insert into .... ;

set feedback on
set define on

Hope this works.

Report message to a moderator

Re: using special characters with sql/plus [message #11399 is a reply to message #11397]

Wed, 24 March 2004 17:50

Nathan Pohle
Messages: 2
Registered: March 2004

Junior Member

Got, that. However, this obviously doesnot work with single quotes or newline characters, etc. The characters that one can usually use escape codes to print, but sqlplus doesn't have these so is there any way of doing this.

Report message to a moderator

Previous Topic:	export some specifice recordss errorr (req. query.)
Next Topic:	sql_querry

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 30 08:36:56 CDT 2025