Symbols under oracle?

[Whitebat]

how do i tell Oracle to display a name like this : O'Donnell ? the problem is the ' in the name
thanks for your help

 

[harris79]

In PL/SQL - 'O''Donnell' or in SQL - "O'Donnell".

Note in PL/SQL all the quotes are single '
in SQL the start in finish are doubles ".

Steve

 

[Whitebat]

thats not working in my version
but its working like this :
'O'||''''||'Donnell'

 

[rcurva]

How about this one?

SELECT 'O''Donnel'
FROM sys.dual;

 

[kummi]

Hi,
If u want like above u can use below synatax.

select 'O'||chr(39)||'Donnel' from dual;

regards,
kumar.