GeekInterview.com
Series: Subject:
Question: 51 of 234

Ampersand in SQL Output

How to display & in Oracle SQL output
Asked by: nishantsethi | Member Since Jan-2008 | Asked on: Aug 18th, 2008

View all questions by nishantsethi

Showing Answers 1 - 1 of 1 Answers
sailajabetha

Answered On : Aug 18th, 2008

View all answers by sailajabetha

Use concatenate operator ...

SQL> select 'a'||'&'||'b' from dual;

'A'
---
a&b

Yes  1 User has rated as useful.
  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.