select '''' from dual;

will select a single quote in Oracle or mySql


Niki Tragen wrote:
how > to get the single quotes in around the sid and serial# without syntax errors

> spool killcolumbus.sql
> select
> 'alter system kill session ' || "'"|| sid|| ',' ||serial#||';' from v$session
> where username = 'COLUMBUSUN'
> AND status='INACTIVE';
> spool off
>
> tried concatenating and trying to escape the ' as a special character with \ but no
> luck.


Oracle LazyDBA home page