how to display & charcter in striing in oracle ?

[ub1234567]

Hi members,

i want to display & in string in oracle.

right now when i am running my script it is asking me to enter variable value and in the out put string it does not display & ..

so how can i display & in string in oracle ?

Thanks.

any help is greatly appreciated.

 

[jdemmi]

You need to use the escape characters...

http://download.oracle.com/docs/cd/B10500_01/text.920/a96518/cqspcl.htm

-- Jason
"It's Just Ones and Zeros

 

[CR85user]

If you mean to show as the output of a formula then just encapsulate in quotes.

e.g.

//{@Stringformula}
'Test' & ' & ' & 'Field2'

Would display as:

Test & Field2

Whereas:

'Test' & 'Field2'

Would show as:

TestField2

I hope this helps to understand how crystal works with ampersands.



CR8.5 / CRXI - Discovering the impossible

 

[jdemmi]

oops...I didn't even realize the question was asked in a CR forum (I also read and post in Oracle forums on here) and I just responded off the cuff...

We're both correct -- depending on where the & is being used (in CR or in an Oracle query)

-- Jason
"It's Just Ones and Zeros

 

[ub1234567]

hi jdemmi,

thanks for reply..

i want to used in oracle query nt in CR.

so your mention answer is for oracle query ?

let me know.

thanks/

 

[jdemmi]

Yes.....see the link I posted

-- Jason
"It's Just Ones and Zeros