0 Replies Latest reply on Jan 15, 2008 11:37 AM by 611590

    Oracle Function

    611590
      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