Try something like this:
SELECT * FROM USERS
MINUS
SELECT * FROM USERS AS OF TIMESTAMP
TO_TIMESTAMP ('22-APR-03 9:04:58','DD-MON-YY HH24: MI: SS')
"Georg Scholz" <georg.scholz_at_vienna.at> wrote in message
news:d9hsn0hi07grh9to81bkgtkimskit80kct_at_4ax.com...
> Hello,
>
> Is there a general way to SELECT those records, which have been
> inserted at last in the current transaction?
>
> Some sort of "SELECT * FROM Table WHERE Record is new " ?
>
>
> What I want to do:
>
> When I'm inserting new records, triggers are getting fired, which
> update some columns. Now I want to display these values to the user,
> so (s)he can decide whether to commit or rollback the changes.
>
>
> Thanks in advance for help on this topic
>
> Georg Scholz
>
>
>
Received on Tue Oct 26 2004 - 08:11:38 CDT
