well, the SQL is certainly SQL:2003 compliant --
both the generator query and the resulting queries;
you only use a tool-specific trick to execute the generated SQL commands.
I guess any DBMS offers similar tricks ...
Kind regards,
Lex.
visit my website at
http://www.naturaljoin.nl
On Fri, Jul 02, 2004 at 12:24:12PM +0200, Lex de Haan wrote:
> well, you could of course generate a SQL*Plus script to do the work for
> you --
> something like:
> SQL> set heading off trimspool off ... off ... off ... off
> SQL> spool doit.sql
> SQL> select 'select count(*) from '||table_name||';'
> 2 from user_tables;
> SQL> spool off
> SQL> @doit
>
> Kind regards,
> Lex.
- Binary/unsupported file stripped by Ecartis --
- Type: text/x-vcard
- File: Lex de Haan.vcf
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Fri Jul 02 2004 - 07:55:06 CDT
