APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

IG column Sql Expression source type

Eslam_ElbyalyApr 7 2019 — edited Apr 7 2019

Hi,

I'm trying to use "Sql Expression" source type of an IG column. The IG is based on table test(qty, price) and I added column "total" through right click> create column. It's source type is "sql expression". The expression is ":QTY * :PRICE".

I want to see the result of multiplying qty and price whenever the IG's query is executed. And this does not happen. You can see it when you run the page.

Is this not the way "Sql Expression" source type is used?

https://apex.oracle.com/pls/apex/f?p=97990:18:129097241914633:::::

Workspace= MY_WS
user= forhelp
password= forhelppwd
app= MISC
page= 18

This post has been answered by fac586 on Apr 7 2019

Jump to Answer

Added on Apr 7 2019

#apex-discussions

2 comments

5,026 views