Skip to Main Content
Forums

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!

Call a function from a SELECT statement

user8819407Sep 28 2009 — edited Sep 28 2009
Hi,
I want to add a column in my result with a result I get when calling a function. First q - is it possible to call a function inside a SELECT statement? The function requires parameters so my question would be (if it works) something like

SELECT A, B, C, functionX(B, C)
FROM TableY

Is above possible at all? If, pls advice syntax/query.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 26 2009
Added on Sep 28 2009
13 comments
15,087 views