This would be particularly useful for creating a test schema for development. In this example, I create a package that allows you to do this for most objects (with some limitations).

All test case names must start with 'test' and follow SQL Server stored procedure naming conventions. This example creates a test table, inserts values, and calls the function GetStatusMessage.

Unit-testing should have as few barriers as possible. For relational databases those barriers range from external dependencies to speed to keeping the relational schema synchronized with your object ...

The database schema will update and change during the lifetime of the application. When these changes are developed, the schema of environments like DEV, INT and TST will differ from the PROD schema.

The SQL Developer unit testing framework involves a set of sequential steps for each test case. The steps are as follows, including the user input for before the step is run and the framework ...