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;
How is this blank field ('' as Contact) created Oracle Peoplesoft Query Manager? I can only create fields from a table.