robert@blake.u.washington.edu (Gedankenleere) (10/31/90)
How do I go about purging records from an orcacle database (on a vax vms machine) from batch?? thanx in advance.
drack@titan.tsd.arlut.utexas.edu (Dave Rackley) (11/01/90)
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 | | +=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=+