How to create a blank/empty column with SELECT query in oracle?

Question

I want to generate an output with blank/empty column with a "Select" query in oracle. I'm able to achieve this with below sql query:

SELECT CustomerName AS Customer, "" AS Contact  FROM Customers; 

So when I run above sql query it returns a table with two columns "Customer" column with content in it and "Contact" column with no content or blank column. I want to achieve same with oracle query. Any help will be highly appreciated.

Answer 1

I think you should use null

SELECT CustomerName AS Customer, null AS Contact  FROM Customers; 

And Remember that Oracle

treats a character value with a length of zero as null.

Answer 2

In DB2, using single quotes instead of your double quotes will work. So that could translate the same in Oracle..

SELECT CustomerName AS Customer, '' AS Contact  FROM Customers;