Re: PL/SQL Question for FORMS5.0

To include Single Quotes in a Single Quoted string, simply double up on the quotes.

For example:
String := 'Hello ''JOE''';
In this example, the string will equal: Hello 'JOE'

Here's a script I use to generate row counts from all tables in the current schema:

SQL> SELECT 'SELECT ''' || TABLE_NAME || ''', COUNT(*) FROM ' || TABLE_NAME;' FROM SYS.USER_TABLES

SQL> SPOOL tables.sql
SQL> /
SQL> spool output
SQL> _at_tables.sql
SQL> spool off

Hope this helps,

Sandy Received on Sat Jan 24 1998 - 00:00:00 CET