db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From musky <musk...@gmail.com>
Subject using SELECT as an SQL triggered action
Date Fri, 08 Feb 2008 17:16:58 GMT

i created the following trigger in my java program:
"CREATE TRIGGER insert_trigger AFTER INSERT ON table_name FOR EACH STATEMENT
SELECT * from table_name" 

my problem is how to store the result of the SELECT * from table_name
statement so that i can display it on the console output whenever ant data
is inserted into the table,that data is retrieved from the table.

is such a thing possible.

urgent help needed please.

-- 
View this message in context: http://www.nabble.com/using-SELECT-as-an-SQL-triggered-action-tp15359808p15359808.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.


Mime
View raw message