Re: Audit Trails...

From: <goldenge_at_my-dejanews.com>
Date: Wed, 30 Sep 1998 02:11:32 GMT
Message-ID: <6us40k$sl2$1@nnrp1.dejanews.com>

In article <6uoe2l$er0$1_at_imsp009a.netvigator.com>, "Erik" <eriktang_at_netvigator.com> wrote:
> Hello, can anyone help to answer my questions :
>
> In our site, the Oracle8 was installed under HP-UX. When I reviewed the
> audit trails (e.g. select * from dba_audit_session) by using SQL*Plus, only
> date was shown under the column timestamp. However, if I use MS-Access
> through ODBC, I can get both time and date for the column timestamp. Is it
> related to NLS parameters ? How can I see the time information using
> SQL*Plus ?
>
> Thanks in advance.
>
> Regards/Erik
>
>

Dear Erik, It's related to NLS parameters. In SQL*PLUS, you can use following statement to set date format. ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY MM DD HH24:MI:SS' (Reference the details in 'Oracle8 SQL Reference ' book)

Best Regards.
Golden Ge
Email:goldenge_at_chinasystems-cn.com

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Sep 29 1998 - 21:11:32 CDT