The "Automatic SQL Query Generator" tool generates Insert, Update and Delete SQL queries for Oracle database tables. Pre-requisites: 1. The tool is in the form of windows exe file and works well on Windows XP and higher versions. 2. Microsoft ODBC driver for Oracle should be pre-installed on the system. Usage: 1. Extract the contents of the zip file. 2. Provide the database credentials in db.conf. Details to be provided are: hostname, port, sid, username and password. Save the file. 3. Double click on AutoSQLPredictiveTrial.exe / AutoSQLRandomTrial.exe. 4. Provide the table name for which the queries are to be constructed. 5. Provide the table owner name. 6. Wait for the "Done" message to appear. AutoSQLPredictive: This is the predictive version, which constructs queries similar to existing data in the provided table name. To use this version, there should be at least one pre-existing record in the table. AutoSQLRandom: This version constructs queries with random column values. Can be used for tables having no pre-existing records.
Requirements:
Microsoft ODBC driver for Oracle
Limitations:
10-day trial
Comments not found