From: "Saad Ahmad" <saad.ahmad@mchugh.com>
Subject: Re: Oracle 7.3 not Y2K compliant on Digital Unix?
Date: 1998/05/05
Message-ID: <01bd7832$a5713680$2207030a@sahmad-pc.mfa.com>#1/1
References: <5u4qPGA1f4S1EwY1@jimsmith.demon.co.uk> <01bd776a$41d10ce0$2207030a@sahmad-pc.mfa.com> <354ed170.4495584@news.demon.co.uk>
Organization: McHugh Software International
Newsgroups: comp.databases.oracle.server,comp.databases.oracle.misc



> 
> This is **not** a Y2K issue - selecting a date field from anywhere
> gets you the default format (which defaults to 2 digit year but can be
> changed) unless specified otherwise.  If you want a 4-digit year,
> specify it and it will be correct.

"Thou shall atleast read the message before 'following-up' on it"

On your machine do sqlplus
SQL> desc v$transaction <<< --- see no select * from 
Also to make sure 
SQL> desc v_$transaction