Oracle Forms

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!

formula column based on sql statement

Eslam_ElbyalyApr 2 2014 — edited Apr 7 2014

hi all ,

i have a select statement :

(select sum(t.CR_AMOUNT-t.DR_AMOUNT)
        from HOSPITAL_TRANSACTIONS_VIEW t
        where t.TRX_TYPE in ( 'CR','DR')
        and   t.CUSTOMER_NO = :account_no        -- where (:account_no) is a char column in a non-database block 
        and   t.trx_date between '01-03-2014' and '31-03-2014') ;

and i want to create a formula column based on it , but i do not know how ?

thanks in advance

This post has been answered by Andreas Weiden on Apr 2 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 5 2014

Added on Apr 2 2014

#forms, #moved-from-devops

11 comments

5,164 views