OraFAQ Forum: SQL & PL/SQL » concatenating msg and statement

Home » SQL & PL/SQL » SQL & PL/SQL » concatenating msg and statement

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

concatenating msg and statement [message #216722]

Tue, 30 January 2007 02:46

karismapanda
Messages: 58
Registered: January 2007

Member

Hi,
I want to create a script in which i will keep connect command and one command which will show 'connected to username'.
how to acomplish this task.
Thanks and Regards,
Karisma

[Updated on: Tue, 30 January 2007 02:46]

Report message to a moderator

Re: concatenating msg and statement [message #216727 is a reply to message #216722]

Tue, 30 January 2007 03:06

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Does this help?

MHE

Report message to a moderator

Re: concatenating msg and statement [message #216739 is a reply to message #216722]

Tue, 30 January 2007 04:00

karismapanda
Messages: 58
Registered: January 2007

Member

Thanks,

select 'connected to '||user from dual;
This is working.

Report message to a moderator

Previous Topic:	count(*) or count(1)
Next Topic:	get duplicate record in a table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 08:53:51 CST 2024