Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help, SQL Problem!!!
D'oh! Don't know where I got that update statement (see below) from since
you were asking for a select - my brain must have been stuck somewhere
else, but it's the same general idea. Replace the update statement with
the select statement you're after. Sorry!
--
Matt Brennan
SQL*Tools Specialist
GERS Retail Systems
9725-C Scranton Road
San Diego, California 92121
1-800-854-2263
mbrennan_at_gers.com
(Original email address is spam-blocked.)
Matt Brennan <mbrennan_at_gers.antispam.com> wrote in article
<01bdc4ac$7e064100$049a0580_at_mcb>...
> This is a bit hokey, but you can spool the table names to a file by
> selecting from dba_tables (this is assuming you are doing this in UNIX,
BTW
> - don't know how other ones work) and make that file a script.
>
> 1. Make a script called myscript.sql (for the purpose of this example)
for
> your update:
>
> set echo off
> define table_to_update = '&1'
> update &table_to_update
> set blah blah blah...
> /
[snippage...]
Received on Tue Aug 11 1998 - 11:38:21 CDT