SQL & PL/SQL

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!

SQL query - Alias name (value) as parameter to an Oracle function

user8819407Oct 14 2009 — edited Oct 15 2009

Hi,
I have a sql query something like

Select tbl1.valueA, tbl1.valueB, tbl2.valueX, MAX(CASE tbl2.valueY = 'XX' THEN tbl2.valueZ END) AS "ValueZ header", Function(tbl1.valueB, tbl2.valueX, "valueZ header")
FROM table1 tbl1
JOIN table2 tbl2 ON tbl1.id = tbl2.tbl1id
WHERE ...

my problem is that I need the value from MAX statement as parameter to the function and I have tried to use the alias name (valueZ header) but this is not working. I guess because of some syntax error. Can I use alias name as parameter into the function at all - if - how should I do this?

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 12 2009

Added on Oct 14 2009

6 comments

3,006 views