Using special character for column alias - Oracle

Asked Oct 20 '17 at 08:27

Active Oct 20 '17 at 09:19

Viewed 1,596 times

I trying to alias a column with "a&b": eg:

SELECT numberofemployees "Employees (D&B)" from account;

SELECT numberofemployees as "Employees (D&B)" from account;

Every other character works fine except for the "&". This query is prompting me to give a value for a variable. I am using it in PL/SQL Developer.

asked Oct 20 '17 at 08:27

Pooja

SELECT numberofemployees as [Employees (D&B)] from account; – Ryan Gadsdon Oct 20 '17 at 08:29
8

Use `SET DEFINE OFF`, and it will work for that particular session. – Maheswaran Ravisankar Oct 20 '17 at 08:34
2

If you are running in PLSQL Developer's SQL Window, use double ampersand (&&), it will print only once without any prompt. – San Oct 20 '17 at 09:09

0 Answers0