Forum Stats

  • 3,783,390 Users
  • 2,254,767 Discussions
  • 7,880,376 Comments

Discussions

Oracle Function

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
This discussion has been closed.