Re: Insert an apostrophe into a string?

Use the SQL Function chr() for this.

chr(10) gives you a newline
chr(39) gives you an apostrophe

In SQL*Plus try the following:

set pagesize 0
set heading off
set feedback off
spool tmp.sql

select 'select ' || chr(39) || table_name || chr(39) ||

        ', count(*) from ' || table_name ||';' from user_tables /
spool off
start tmp.sql

I hope this works for you

Martin Pammer
VRZ Informatik Dornbirn (Austria)
mpammer_at_vrz.net Received on Thu Aug 08 1996 - 00:00:00 CEST