Home » RDBMS Server » Server Administration » string manipulation
string manipulation [message #371010] Mon, 07 August 2000 17:25 Go to next message
PM
Messages: 3
Registered: August 2000
Junior Member
is there a way to print this type of
string in sqlplus :
America's #1 Talk show host
TIA
pm

Report message to a moderator

Re: string manipulation [message #371014 is a reply to message #371010] Tue, 08 August 2000 09:15 Go to previous messageGo to next message
Lee
Messages: 56
Registered: May 1999
Member
Use prompt 'string here'

Report message to a moderator

Re: string manipulation [message #371016 is a reply to message #371010] Tue, 08 August 2000 09:39 Go to previous message
Thavamani
Messages: 11
Registered: July 2000
Junior Member
Hi,
The answer to your query is this

select 'america'||''''||'s'||'#1 Talk show host TIA pm' from dual;
Regards,
Thavamani

Report message to a moderator

Previous Topic: Top N values
Next Topic: Re: Help on SQL "SELECT.."
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 22 06:26:58 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.