Last record of a result set

From: JAW <jwilliam_at_aglresources.com>
Date: Tue, 5 Oct 2010 09:26:30 -0700 (PDT)
Message-ID: <84f18303-2f50-4936-8b06-27f69ae34acc_at_30g2000yqm.googlegroups.com>

cat dhtexp.sql

set heading off feedback off pagesize 0
--

spool zzz.par
prompt file=data.dmp
prompt log=data.log

prompt direct=y
prompt buffer=100000000
prompt userid=data
prompt tables=(

 select ' '|| tablename ||','
 from userz.tab_codes
 where export='Y'
 order by tablename;
prompt )
--

spool off
prompt exp parfile=zzz.par

A very minor issue. I generated export cards for a group of tables in a codes table for an application upgrade.

The last line shows up with TABLENAME, as expected.

Though it is minor I was attempting to think of a way in SQL to take care of.

Maybe LAG??? Received on Tue Oct 05 2010 - 11:26:30 CDT