sqlplus message
Date: Sun, 22 Jul 2001 06:55:29 GMT
Message-ID: <9hqmrm$hdi$1_at_nntp9.atl.mindspring.net>
[Quoted] I get the following message when I logon using my login profle. I get the message every time but don't know why
SQL> _at_login
You are logged into database PROD1.
You are logged in as user DUTCH.
Today is the 02ND of Jul, 2001 and the time is 16:28.
Input truncated to 14 characters *** Why di I get this message????***
the script
SET HEADING OFF
SET LINESIZE 132
SET PAGESIZE 66
SELECT 'You are logged into database '|| name ||'.'
FROM v$database;
SELECT 'You are logged in as user '|| user ||'.'
FROM DUAL; SELECT 'Today is the '|| to_char(SYSDATE, 'DDth "of" Mon"," yyyy') ||
' and the time is ' || to_char(SYSDATE, 'hh24":"mi') || '.'
FROM DUAL; SET HEADING ON Thanks for any help... Received on Sun Jul 22 2001 - 08:55:29 CEST