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
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_name||'';'
from
Title: RE: How to put if statement with Accept value ???
-Original Message-
From: Andrea Oracle [mailto:[EMAIL PROTECTED]]
How to do a if statement with Accept? Like I first
prompt user for a value, Accept var prompt ..., then
based on the value I got, do differenct things