rules

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.

Browse pgsql-general by date

  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()