Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!pd2nf1so.cg.shawcable.net!residential.shaw.ca!news-out1.nntp.be!propagator2-sterling!news-in-sterling.nuthinbutnews.com!newsfeed.nyc.globix.net!infeed.is.co.za!feeder.is.co.za!hades.is.co.za!not-for-mail From: "Onismus Radebe" Newsgroups: comp.databases.oracle.misc References: Subject: Re: insert user and data login in a table Date: Tue, 9 Sep 2003 12:18:53 +0200 Organization: Absa MIME-Version: 1.0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Lines: 61 Message-ID: <3f5da943$0$64719@hades.is.co.za> NNTP-Posting-Host: 169.202.5.2 X-Trace: hades.is.co.za 1063102787 64719 169.202.5.2 Xref: newssvr20.news.prodigy.com comp.databases.oracle.misc:131458 "Maurizio" wrote in message news:nrh7b.304160$Ny5.9467912@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. ___________________________________________________________________________