Re: REGEXP

From: Marcus Mönnig <mm_at_marcusmoennig.de>
Date: Fri, 13 Sep 2013 12:58:13 +0200
Message-ID: <CAFuw4v=gVE74Eahj5HZmmn7kdWjC+z58Jrt6EQ7QmmF2uH1gFg_at_mail.gmail.com>



Can it be the calculated value? Then something like this woudl work: declare
  l_vc varchar2(255);
  l_next_date date;
begin
l_vc:='SYSDATE+7/24';
execute immediate 'select '|| l_vc ||' from dual' into l_next_date; DBMS_OUTPUT.PUT_LINE(l_next_date-trunc(sysdate)); end;

Cheers,
Marcus

2013/9/13 oracledba <oracledba71_at_gmail.com>

> column values looks like:
> SYSDATE+7/24
> TRUNC(SYSDATE + 1) + 2.75/24
>
> Required output:
>
> +7/24
> +1 + 2.75/24
>
> Thanks
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Sep 13 2013 - 12:58:13 CEST

Original text of this message