Re: getting sys date and database name thru SQL
From: Mike Rife <rife_at_aarlo.moffitt.usf.edu>
Date: 1995/05/02
Message-ID: <3o58ku$p0r_at_mother.usf.edu>#1/1
Date: 1995/05/02
Message-ID: <3o58ku$p0r_at_mother.usf.edu>#1/1
In article <3nlkn3$ldd_at_news.ed.ray.com>, swong_at_ED.RAY.COM says:
>
>Does anyone know how to get the system date and the database name using a SQL
>statement? Thanks.
>
>S.W.
>
The system date is stored in a pseudo column called SYSDATE:
SELECT SYSDATE FROM DUAL; The database SID is stored in the V$PARAMETER table. Do the following from a DBA Oracle account:
select value from v$parameter where name = 'db_name';
NOTE: watch the case on the literal string. It should be lowercase. Received on Tue May 02 1995 - 00:00:00 CEST