OraFAQ Forum: Server Administration » Que. Related to Concat operator

Home » RDBMS Server » Server Administration » Que. Related to Concat operator

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

Tue, 26 December 2000 03:32

Srinivasulu P
Messages: 5
Registered: December 2000

Junior Member

How to concat single quote with data Like
my SQL output has to come
by using scott/tiger emp table

ename sal

'SMITH 800
'ALLEN 1600
'WARD 1250
'JONES 2975
'MARTIN 1250
'BLAKE 2850
'CLARK 2450
'SCOTT 3000
'KING 5000
'TURNER 1500
'ADAMS 1100
'JAMES 950
'FORD 3000
'MILLER 1300

How to retive this type of information.
this srinivas from LANCO Global SYS from INDIA.,
Thank U.

Report message to a moderator

Tue, 26 December 2000 05:27

Venkata Krishnayya Kommu
Messages: 13
Registered: July 2000

Junior Member

Dear Srinivas,
try the following SQL.
select '''|| ename ename, sal from emp;
This is the answer as far as I understood the question. If it is not, you can contact me at venkat_14770@rediffmail.com. I am also a resident of Hyderabad(Opus Asia Tech Pvt Ltd)
Bye
Venkata Krishnayya Kommu

Report message to a moderator

Tue, 26 December 2000 23:04

P. Lavanya
Messages: 8
Registered: November 2000

Junior Member

hi,
The sql given by Venkata krishnayya kommu is correct.
A small change:
select ''''||ename ename,sal sal from emp;
bye
lavP

Report message to a moderator

Wed, 27 December 2000 03:38

Venkata Krishnayya Kommu
Messages: 13
Registered: July 2000

Junior Member

Here is the solution
select chr(180)||ename ename, sal from emp;

Report message to a moderator

Previous Topic:	help
Next Topic:	Help required

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 17 00:02:21 CDT 2024