Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!news-FFM2.ecrc.net!newsfeed.vmunix.org!newsfeed.ision.net!news.is-europe.net!ision!not-for-mail
From: "Guido Konsolke" <Guido.Konsolke@triaton.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: insert user and data login in a table
Date: Tue, 9 Sep 2003 12:30:36 +0200
Organization: Ye 'Ol Disorganized NNTPCache groupie
Lines: 24
Message-ID: <1063103153.878632@news.thyssen.com>
References: <mqh7b.304384$lK4.9525365@twister1.libero.it>
NNTP-Posting-Host: 149.211.49.31
X-Trace: goliath.news.is-europe.net 1063103439 19437 149.211.49.31 (9 Sep 2003 10:30:39 GMT)
X-Complaints-To: abuse@is-europe.net
NNTP-Posting-Date: 9 Sep 2003 10:30:39 GMT
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
Cache-Post-Path: news.thyssen.com!unknown@170.56.164.200
X-Cache: nntpcache 2.3.3 (see http://www.nntpcache.org/)
Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:242678

"Maurizio" <hillbon@tin.it> wrote...
> I desired know like i can insert in automatic the [user] and the
[date] of
> login of a consumer in a table.
> Thank you in advance
> Maurizio
>

Hi Maurizio,

it's all in the manuals.
Have a look at triggers.
Hints:
* before
* row
* user
* sysdate

Now it's your turn to work.

hth,
Guido