ANNOUNCEMENT: community.oracle.com is currently Read only due to planned upgrade until 28-Sep-2020 9:30 AM Pacific Time. Any changes made during Read only mode will be lost and will need to be re-entered when the application is back read/write.

This discussion is archived

1 Reply Latest reply on May 4, 2016 8:39 AM by B.Delmée

Displaying "&" in column name

Vinod Kumar G M May 4, 2016 8:14 AM

Hi i am using the below query

select null as "A&B" from dual. How we can use "&" in the column name.

Thanks

Vinod

1. Re: Displaying "&" in column name

B.Delmée May 4, 2016 8:39 AM (in response to Vinod Kumar G M)

run "set define off" prior to your query, just like you'd have to with sql*plus
Like Show 0 Likes(0)

Actions