Use CHR(39) to place a single tic inline.
--- mitchell <[EMAIL PROTECTED]> wrote:
> hi
>
> I forget how to put single qutation on sql.
> somebody can help me.
>
> Mitchell
>
>
> I could't make it from following.
>
> select 'ALTER TABLESPACE rename file "'"
> '||file_name||' to
> '||file_na
hi
I forget how to put single qutation on sql. somebody can help me.
Mitchell
I could't make it from following.
select 'ALTER TABLESPACE rename file "'" '||file_name||' to
'||file_name||'"'";'
from dba_data_files
where tablespace_name = 'TBL_STATEMENT';
--
Please see the official ORACLE-L
