OraFAQ Forum: Server Administration » How to put a '&' in the SQL query?

Home » RDBMS Server » Server Administration » How to put a '&' in the SQL query?

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

How to put a '&' in the SQL query? [message #372071]

Tue, 09 January 2001 02:02

dennis
Messages: 31
Registered: June 1998

Member

For example, I want my query to return:
Friends&Partners

When I do:
select 'Friends&Partners', it ask me to input value.

Report message to a moderator

Re: How to put a '&' in the SQL query? [message #372078 is a reply to message #372071]

Tue, 09 January 2001 07:23

Todd Lesswing
Messages: 3
Registered: January 2001

Junior Member

Determine what your escape character is by running the command SHOW ESCAPE in sqlplus. If it says escape off. Type SET ESCAPE ON, this will set your escape character to \. You would then write your query as follows:

select 'Friends\&Partners' from dual;

Report message to a moderator

Re: How to put a '&' in the SQL query? [message #372088 is a reply to message #372071]

Tue, 09 January 2001 13:12

Andrew again...
Messages: 270
Registered: July 2000

Senior Member

in sqlplus:
-- disable substitution variable scanning!
set scan off

Report message to a moderator

Previous Topic:	SQLPLUS format
Next Topic:	indexs and performance

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 30 08:06:07 CST 2026