Create Blank Field in Peoplesoft Query Manager

Asked Jun 28 '18 at 16:29

Active Oct 16 '20 at 16:42

Viewed 1,533 times

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.

edited Oct 16 '20 at 16:42

Stevoisiak

asked Jun 28 '18 at 16:29

Michele

3

I just found the solution.....In Expressions, click on Add Expressions. Type '' (two single quotes) and click OK. Click on Use as Field. Click on Edit and type the name of the field in the Heading Text. Click on OK – Michele Jun 28 '18 at 17:07
sounds, good except PeopleSoft only allows date fields and long text fields to be null, so you might need to make it wrap your quotes around 1 blank space instead of nothing. – qyb2zm302 Jun 29 '18 at 14:03

0 Answers0