Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Scripting

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US