Re: getting sys date and database name thru SQL
From: Edward L Dansker <edansker_at_us.oracle.com>
Date: 1995/04/27
Message-ID: <3not69$7e_at_dcsun4.us.oracle.com>#1/1
Date: 1995/04/27
Message-ID: <3not69$7e_at_dcsun4.us.oracle.com>#1/1
swong_at_ED.RAY.COM writes:
>Does anyone know how to get the system date and the database name using a SQL
>statement? Thanks.
>
>S.W.
>
select value from v$parameter where name like '%DB_%';
should give you the database name.
select sysdate from dual;
will give you the system date.
Regards,
Ed Dansker Received on Thu Apr 27 1995 - 00:00:00 CEST