OraFAQ Forum: SQL & PL/SQL » Materialized view refresh

Home » SQL & PL/SQL » SQL & PL/SQL » Materialized view refresh

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Materialized view refresh [message #235903]

Tue, 08 May 2007 06:27

sbrbot
Messages: 5
Registered: August 2006
Location: Croatia

Junior Member

How to define that materialized view (snapshout) should be refreshed on first day of each month since months do have different number of days? When one defines NEXT parameter in mv creation clause there is option NEXT SYSDATE+days or NEXT TO_DATE(date)+days but how to define 1st day of month? If you define SYSDATE+30 this is not what I want.

Report message to a moderator

Re: Materialized view refresh [message #235925 is a reply to message #235903]

Tue, 08 May 2007 07:33

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

SQL> select sysdate, trunc(add_months(sysdate,1),'month') next_month from dual;
SYSDATE     NEXT_MONTH
----------- -----------
8-MAY-2007  1-JUN-2007

1 row selected.

Regards
Michel

Report message to a moderator

Re: Materialized view refresh [message #235928 is a reply to message #235925]

Tue, 08 May 2007 07:42

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

SQL> select sysdate, last_day(trunc(sysdate)) + 1 from dual;

SYSDATE  LAST_DAY
-------- --------
08.05.07 01.06.07

Report message to a moderator

Previous Topic:	how to number of working days in a month
Next Topic:	what is the cause of bad bind variable error here?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 20:28:17 CST 2024