| |
|
To help you learn how to make the best use of Quest Code Tester for Oracle as quickly as possible, we offer a library of tutorials. Pick a category below and click on the arrow. You will then see a list of topics. Click on a topic to access that tutorial. A tutorial consists of a Flash video, step by step instructions for doing the same thing yourself, sample code you can use, and a test definition export. Instructions: These tutorials are all based on database objects (tables, programs, etc.) that are defined in a script named qcto#install_demo.sql, which is located in the QuickStart subfolder in which Quest Code Tester was installed. The default folder is "C:\Program Files\Quest Software\Quest Code Tester for Oracle". Run this script inside Toad or your choice of PL/SQL execution environment, including SQL*Plus, after connecting to the schema in which you want to run the demos (if you have installed Quest Code Tester with public synonyms, you can choose your schema, otherwise install into that same schema). Then proceed with emulating the demonstrations you will see below. If you have problems using these tutorials, please get in touch. Note: We have now released the commercial release of Quest Code Tester, but we are still in the process of upgrading all our videos. You might encounter a video that displays an older UI; hopefully you can still see how to use the sparkling new Quest Code Tester to get the job done. Soon, all will be consistent...please be patient! Introduction and Overviews Start with the tutorials in this section, to make sure that you understand how important it is to test your code more thoroughly and to learn how Quest Code Tester for Oracle can help you accomplish this critical goal. Why is testing so important and why don't we do more and better testing? The realities of testing PL/SQL programs How Quest Code Tester for Oracle can help you get rid of bugs in your PL/SQL procedures Test Tables, Views, Queries and Cursor Variables Most every PL/SQL program reads or writes data in one or more database table. Quest Code Tester for Oracle helps you test changes in these structures with a wide selection of pre-defined, high-level tests. Learn how to use Quest Code Tester for Oracle to test the contents of not only tables and views, but also queries and cursor variables. Test the contents of a database table against a control/copy table Test inserts into a table with a query, and Quick Build Test Collections, PL/SQL's array-like structures Collections are array-like structures in PL/SQL that are used for in-memory caches, to speed up SQL access with BULK COLLECT and FORALL, and much more. With Quest Code Tester for Oracle, you can compare the contents of a collection to another collection, or to a dataset, such as a query, cursor variable, or table. Introduction to testing collections Test the contents of a collection of records Test the contents of a collection that is indexed by strings Defining the "elements equal" function for record comparisons Test Records, PL/SQL's analogue to rows in tables Records are PL/SQL analogues to table rows: they are composed of one or more fields, which can be scalars or more complex structures. They are a very common structure in PL/SQL, especially %ROWTYPE records based on a database table. Quest Code Tester for Oracle helps you build test code to easily test these structures. Compare the contents of a record to a query or another record Defining the "elements equal" function for record comparisons Test global variables and expressions What if your program modifies the contents of a variable in another package? No problem! Just define an outcome based on an expression. These tutorials shows you how to do this for a variety of conditions. Test any sort of expression with Quest Code Tester for Oracle Test contents of files You read and write files with UTL_FILE in PL/SQL. You can easily test the contents of files with the Quest Code Tester for Oracle. Test exceptions, system output, elapsed time Sometimes you expect your program to raise a certain exception. Other times you want to test to make sure that no exception is raised at all. Many PL/SQL programs generated output to screen via DBMS_OUTPUT, and you need to verify that output. Finally, do you want to make sure your program is running quickly enough? These tutorials show you how to design all of these tests, and more. Does the program raise a specific exception or any exception? Tips and Tricks The tutorials in this section will help you take full advantage of all the special features and capabilities of the Quest Code Tester for Oracle. Defining the "elements equal" function for record comparisons Tips for working with object types in Quest Code Tester Learn how to test object type methods *indirectly* from within Quest Code Tester Administrative tasks Your test definitions will quickly become a critical element of your overall application metadata and business intelligence. These tutorials show you how to manage those test definitions, set preferences, and add to/change the metadata that Quest Code Tester for Oracle uses to drive the test creation process. |
|
|
©2004-2006 PL/Solutions. All Rights Reserved. |
|