I would like to create function which can return more date from a query
create or replace FUNCTION FUNCTION1(cdate in date,org in number) RETURN number AS
select destination into dd from tbl_sms
where c_date=cdate and originator=org;
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.