Path: utzoo!attcan!uunet!know!cs.utexas.edu!titan!drack From: drack@titan.tsd.arlut.utexas.edu (Dave Rackley) Newsgroups: comp.databases Subject: Re: Question: purging records from oracle db Message-ID: Date: 31 Oct 90 16:41:16 GMT References: <10314@milton.u.washington.edu> Sender: news@titan.tsd.arlut.utexas.edu Organization: Applied Research Laboratories, University of Texas at Austin. Lines: 38 In-reply-to: robert@blake.u.washington.edu's message of 31 Oct 90 14:49:48 GMT In article <10314@milton.u.washington.edu> robert@blake.u.washington.edu (Gedankenleere) writes: > How do I go about purging records from an orcacle database (on a vax vms > machine) from batch?? Not real sure what you mean by "purging" records from the database. You can delete records batchwise by creating a command file that calls SQL*PLUS, which, in turn, executes a query file. For example: $! DOQUERY.COM $! $ sqlplus username/password @del_query.sql $ exit ------------------------------- REM DEL_QUERY.SQL REM delete table_name where expression = YOUR_CONDITION; exit ^ Don't forget the semicolon. Hope this helps. :-) -- DISCLAIMER? I don't know anything 'bout any ol' disclaimer! +=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=+ | David Rackley | | | Applied Research Laboratories | Remember, you can tuna fish, | | The University of Texas | But you can't tuna piano! | | Austin, TX. 78758 | | +=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=+