Dear 1 simple qustion is how i can get out put likescott's sal is 2000becoz ' is special char i can not pipe it with enameasename||'scan we use escape sequence but i know that escape seq is only 4 % and _ plz tell me anybody

José Baptista

• Nov 18th, 2006

 

Hi

You just need to do this: ename||'''||'s'.

If ename := 'Scott', the output is Scott's.

Regards

Jos? Baptista 

shravanam

 Profile Answers by shravanam Questions by shravanam

• Oct 24th, 2007

 

TRY THIS

SELECT ENAME||' ' ' '||'S' FROM EMP: