Re: Oralce newbe

Someone wrote:
: >
: > My major issue with the Oracle system is that my workstations will
: > always display current active files.

For my own understanding, without buying and digging through the recommended book since i'm not about to need this today or tomorrow, would the following be a) a possible approrach, or b) a stupid way to do this?

	for "real time" updates on to a central "console" like screen
	being monitored by a person, do the following

	add a trigger to a few appropriate application tables.  When
	certain columns or rows are added or modified, then the trigger
	sends a message to what ever procedure is used to provide the
	console monitoring facility (or more likely add the message to
	some kind of messaging queue).

Is this sensible or stupid? I'm not sure how to send such a message, but I assume that the Java facilities probably provide something that could be used, or there might be a DBMS_xxx package that supports this.

($0.02) in the debit column Received on Fri Nov 12 2004 - 18:23:30 CST