While developing your database application, you need to be able to test your application and stored database code.
You can generator hundreds of thousands of rows with meaningful test-data in your database if you use the very powerful and flexible Test Data Generator. If you need to import from legacy or other systems, use the Data Pump or Data Import tools.
To run ad-hoc queries or analyse the statement-execution plans, use the very flexible SQL Editor - also used to run scripts and parameterized statements and of course, you can use the BLOB Editor to view and edit your binary data.
If you're using InterBase or Firebird then you can use the build in Stored Procedure Debugger in order to test your Stored Procedure code:
|