Scripting

From: Richard Cuello <rc370_at_columbia.edu>
Date: Fri, 02 Apr 1999 08:41:03 -0500
Message-ID: <3704C8EF.947A0A2E@columbia.edu>

Hi..

  Below is a script. Can someone explain to me what is going on. Especially the concatenation in select statement.

thanks for helping out
r...

set echo off
set head off
set feed off
set pagesize 10000
set linesize 200

spool example3.sql

SELECT 'SELECT '||''''|| 'The Number of Rows In '||table_name ||
          ' is '||''''|| ' || (COUNT(*)) '||
        'FROM ' ||table_name||';'

FROM sys.all_tables
WHERE owner = 'CTA';

spool off

spool example3 /* This is the LIST file for output later!!!!!! */

@example3
spool off

Received on Fri Apr 02 1999 - 07:41:03 CST