OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » reg SQL PLUS

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

reg SQL PLUS [message #70702]

Tue, 16 July 2002 04:13

mani
Messages: 105
Registered: September 1999

Senior Member

Hi,
I need to display welcome message while loading
SQL*PLUS.
I have changed the prompt message as my name,but am not able to displayu the welcome message.
I have used DBMS_OUTPUT.PUT_LINE('WELCOME TO THE WORLD OF ORACLE!!!');
Its giving an error unknown command.
so i have given select 'WELCOME TO THE WORLD OF ORACLE!!!' from dual;
here its displaying but the display is like this:

'WELCOME TO THE WORLD OF ORACLE!!!
-----------------------------------------------
'WELCOME TO THE WORLD OF ORACLE!!!

but i dont want like this.I want the message to be disaplyed like

'WELCOME TO THE WORLD OF ORACLE!!!

any help will be gr8ly appreciated.....
Thanks
mani

Report message to a moderator

Re: reg SQL PLUS [message #70703 is a reply to message #70702]

Tue, 16 July 2002 04:19

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

SQL*Plus: Release 8.1.6.0.0 - Production on Tue Jul 16 08:05:01 2002

(c) Copyright 1999 Oracle Corporation.  All rights reserved.

Connected to:
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production

***********************************************************************
WELCOME TO THE WORLD OF ORACLE!!!
***********************************************************************
SQL>

in order to get something like above add

prompt ***********************************************************************
prompt			WELCOME TO THE WORLD OF ORACLE!!!
prompt ***********************************************************************

to your glogin.sql

Report message to a moderator

Re: reg SQL PLUS [message #70756 is a reply to message #70702]

Sat, 20 July 2002 01:57

sunil bhola
Messages: 58
Registered: July 2002

Member

If you want to display any message while to logon to sql*plus

follows these steps

1.) get the file glogin.sql from /rdbms/sqlplus/admin/glogin.sql

2.) open the file

type

set serveroutput on
prompt Made by Sunil Bhola

3.) close the file with save option

next time when you will open the sql*plus the message Made by Sunil Bhola will display on the screen

Report message to a moderator

Previous Topic:	reg UTL_FILE
Next Topic:	oracle

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 27 20:19:28 CST 2025