Skip to Main Content
Forums

APEX

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!

Interval with values from column

759982Jun 14 2010 — edited Jun 14 2010
Hello,

Normaly you use this :
select sysdate + interval '+01 02:30:12' day to second from dual

What is need is this - put value from column "INTERVAL_Values"(values like '+01 02:30:12') at next statement:
select sysdate + interval *"INTERVAL_Values"* day to second from TABLE_NAME.

It didn't work. What is the solution.

Thanks Walter!
This post has been answered by 682558 on Jun 14 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 12 2010
Added on Jun 14 2010
#apex-discussions, #pl-sql, #plsql, #sql
2 comments
437 views