Re: insert user and data login in a table

From: Onismus Radebe <onismusrATabsaDOTcoDOTza_at_za>
Date: Tue, 9 Sep 2003 12:18:53 +0200
Message-ID: <3f5da943$0$64719@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:18:53 CDT