Re: insert user and data login in a table

From: Guido Konsolke <Guido.Konsolke_at_triaton.com>
Date: Tue, 9 Sep 2003 12:35:55 +0200
Message-ID: <1063103473.247197@news.thyssen.com>

Hi,

very nice example ;-)

Greetings,
Guido

"Onismus Radebe" <onismusrATabsaDOTcoDOTza_at_za> schrieb im Newsbeitrag news:3f5da943$0$64719_at_hades.is.co.za...
> "Maurizio" <hillbon_at_tin.it> wrote in message
> news:nrh7b.304160$Ny5.9467912_at_twister2.libero.it...
> > 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
> >
> >
>
>
> SQL> @ qst01.sql
> SQL> create table test (
> 2 c_user VARCHAR(30),
> 3 c_date DATE )
> 4 /
>
> Table created.
>
> Elapsed: 00:00:00.11
> SQL>
> SQL> insert into test (c_user, c_date)
> 2 values (user, sysdate)
> 3 /
>
> 1 row created.
>
> Elapsed: 00:00:00.01
> SQL>
> SQL> select * from test
> 2 /
>
> C_USER C_DATE
> ------------------------------ -----------
> ABOR009 09-SEP-2003
>
> Elapsed: 00:00:00.00
> SQL>
> SQL> drop table test
> 2 /
>
> Table dropped.
>
> Elapsed: 00:00:03.56
>
>
>
> --
> \|/
> o o
>

__________________________________oOO_(_)_OOo_________________________

---

>
> E-Business and Information Management | God said ...
> Knowledge Discovery & Dissemination | 1. div D = p
> onismusr-AT-absa-DOT-co-DOT-za | 2. curl E
= -dB/dt
> Tel: +27 11 350 3414 | 3. div B = 0
> Fax: +27 11 350 8585 | 4. curl H =
dD/dt + J
> Cel: +27 83 591 5310 | ... and there was
light.
>

---

---

>
>
>
Received on Tue Sep 09 2003 - 05:35:55 CDT