Skip to Main Content

DevOps, CI/CD and Automation

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Oracle Function

611590Jan 15 2008
Hi everyone
I would like to create function which can return more date from a query
Ex:
create or replace FUNCTION FUNCTION1(cdate in date,org in number) RETURN number AS
dd number(30);
BEGIN
select destination into dd from tbl_sms
where c_date=cdate and originator=org;
RETURN (dd);
END FUNCTION1;
Note:my table return many rows for each c_date and org ,which my function can not handle, my question is can i improve this function to do this? Because i wann use it in many views.
Thanks

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 12 2008
Added on Jan 15 2008
0 comments
4,989 views