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
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'
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
Previous Topic: Top N values
Next Topic: Re: Help on SQL "SELECT.."
Goto Forum:
  


Current Time: Tue Oct 20 09:13:15 CDT 2020