From: | Ramesh T <rameshparnanditech(at)gmail(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | rules |
Date: | 2015-02-26 10:33:51 |
Message-ID: | CAK8Zd=t0L6qoUJ1XpgnX-W=LOhfQ2vKsEW9fPVJhD+woHsLfpw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
it is in postgres i need to convert into oracle
CREATE RULE payment_insert_p2007_04 AS ON INSERT TO payment WHERE
(new.payment_date >= '2007-04-01'::timestamp without time zone) DO INSTEAD
INSERT INTO payment_p2007_04 (payment_id)VALUES (1);
in oracle format i used google
i got
BEGIN
DBMS_MACADM.CREATE_RULE(
rule_name => 'Restrict Access to Maintenance Period',
rule_expr => 'TO_CHAR(SYSDATE,''HH24'') BETWEEN ''14'' AND ''15''');
END;
/
it is not works for me ,any one let me know is it possible create rule in
oracle on particular table as i mentioned create rule as postgres format.
From | Date | Subject | |
---|---|---|---|
Next Message | Jirayut Nimsaeng | 2015-02-26 10:46:55 | BDR Multiple database |
Previous Message | Jim Nasby | 2015-02-26 08:30:33 | Re: [HACKERS] Composite index and min() |