Create Blank Field in Peoplesoft Query Manager

1.7k views Asked by At

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.

0

There are 0 answers