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


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

Original text of this message