How to add a constant value column in CE_COLUMN_TABLE?

[dimitris_emmanoulopoulos2]

Hi,

Having a SELECT statement like:

Select "Field1", 'static values' from "Table";

how can I create a CE_COLUMN_TABLE that includes this 'static values' column ?

Thank is advance,

Dimitris

[anindya_bose · Accepted solution]

Hi Dimitris

I believe CE_COLUMN_TABLE cannot provide what you want.

However, in a second CE_PROJECTION statement , you can take some constant values.

It is easy to take numeric values or some other allowed functions like row number or time .  In case, your requirement is to take non-numeric constant, you might need some more effort.

Constant Character value is also possible, just look at the below syntax.  Make sure you are using two consecutive single quotes not double quotes.

Result:

Cheers

Anindya

[dimitris_emmanoulopoulos2 · Accepted solution]

Thank you !