|
Re: difference!!!!! [message #19416 is a reply to message #19414] |
Fri, 15 March 2002 02:39 |
pratap kumar tripathy
Messages: 660 Registered: January 2002
|
Senior Member |
|
|
what do u mean by rule ? are u talking about constraints OR rule based optimization ?
Database Triggers
------------------
Oracle allows you to write procedures written in PL/SQL, Java, or C that execute (fire) implicitly whenever a table or view is modified, or when some user actions or database system actions occur. These procedures are called database triggers.
Database triggers can be used in a variety of ways for the information management of your database. For example, they can be used to automate data generation, audit data modifications, enforce complex integrity constraints, and customize complex security authorizations.
|
|
|
Re: difference!!!!! [message #19427 is a reply to message #19414] |
Sat, 16 March 2002 01:08 |
jeya
Messages: 18 Registered: January 2001
|
Junior Member |
|
|
CREATE RULE rule1 AS
ON SELECT TO emptable1
DO SELECT * FROM emptable2;
what will this query do??
whether it will select rows from emptable1 or emptable2 or from both???
|
|
|