Daily refresh at particular hour/minute [message #400444] |
Tue, 28 April 2009 04:21 |
summoner
Messages: 44 Registered: March 2009
|
Member |
|
|
I have a refresh group that targets to refresh on 4am each day.
However, I need to refresh the group manually sometimes. Therefore, I cannot set the interval as sysdate+1.
I have tried setting the interval as follows. However, they are not correct
Quote: | trunc(sysdate+1) +4/24
|
The next interval will show 9:25:20pm.
Quote: | trunc(sysdate+1) + interval '4' hour
|
Incorrect syntax
Thank you for your help
|
|
|
|
Re: Daily refresh at particular hour/minute [message #400466 is a reply to message #400455] |
Tue, 28 April 2009 05:22 |
summoner
Messages: 44 Registered: March 2009
|
Member |
|
|
gentlebabu wrote on Tue, 28 April 2009 04:56 |
Try
interval => 'trunc(SYSDATE +1) + 4/24'
Babu
|
If shows error as follow:
Quote: |
Failed to commit: ORA-06550: line 5, column 20: PLS-00103: Encountered the symbol "TRUNC" when expecting one of the following: ) , * & = - + < / > at in is mod remainder not rem <an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_ LIKE4_ LIKEC_ between || multiset member SUBMULTISET_ The symbol "," was substituted for "TRUNC" to continue. ORA-06550: line 5, column 44: PLS-00103: Encountered the symbol "" when expecting one of the following: ) , * & | = - + < / > at in is mod remainder not rem => .. <an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_ LIKE4_ LIKEC_ between || member S
|
|
|
|
|
|
|
Re: Daily refresh at particular hour/minute [message #440395 is a reply to message #400466] |
Sat, 23 January 2010 12:18 |
jezzicaz789
Messages: 1 Registered: January 2010
|
Junior Member |
|
|
summoner wrote on Tue, 28 April 2009 05:22gentlebabu wrote on Tue, 28 April 2009 04:56
Try
interval => 'trunc(SYSDATE +1) + 4/24'
Babu
If shows error as follow:
Quote:
Failed to commit: ORA-06550: line 5, column 20: PLS-00103: Encountered the symbol "TRUNC" when expecting one of the following: ) , * & = - + < / > at in is mod remainder not rem <an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_ LIKE4_ LIKEC_ between || multiset member SUBMULTISET_ The symbol "," was substituted for "TRUNC" to continue. ORA-06550: line 5, column 44: PLS-00103: Encountered the symbol "" when expecting one of the following: ) , * & | = - + < / > at in is mod remainder not rem => .. <an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_ LIKE4_ LIKEC_ between || member S
Thanks you for the post.
Hi guys, Im a newbie. Nice to join this forum.
|
|
|
|