Finn Lovsted & Associates: Software

Try and Buy --- French Flash Cards --- SQL Deletion Script Generator --- Try and Buy

Oracle SQL Script Generator

This program generates an Oracle SQL deletion script. Use a form to input the table name, the name of a single numeric column that serves as the key, and the numeric range.

A script is generated in the same directory you've placed the SQLDeletion_Generator.mdb file. The script will include commits for every 10,000 records within the numeric range you input on the form. Run the resulting script in SQLPlus. Good for Oracle 8i, 9i, 10g.

This is an Access 97 file.

SQLDeletion_Generator.mdb (112 KB)

$3.99 Canadian (will be less in US Dollars because of exchange rate)

top

Installation

Windows XP SP2 marks many files downloaded from the internet as having come from a nonsecure zone. If you download an Access file and receive the following error opening it: "Microsoft Access cannot open this file. This file is located outside of your intranet or on an untrusted site. Microsoft Access will not open the file due to potential security problems. To open the file, copy it to your machine or an accessible network location."...

...the solution is to right-click on the Access file in Windows Explorer and choose Properties. Click the button titled Unblock at the bottom of the Properties dialog.

Copyright Finn Lovsted 2005 - 2009