Pro Oracle SQL Development: Best Practices for Writing Advanced Queries

© Jon Heller 2019

Jon HellerPro Oracle SQL Development https://doi.org/10.1007/978-1-4842-4517-0_3

3. Increase Confidence and Knowledge with Testing

Jon Heller¹ 

(1)

Clive, IA, USA

 

Testing is more than simply demonstrating a program is correct. We must constantly challenge ourselves to make ourselves better. Likewise, we must also challenge our programs and our ideas. Testing is how we bring science into our craft and replace guesses and myths with real knowledge about how the world works. Building good tests can take a lot of time and effort, and Oracle databases present unique challenges for building reproducible test cases. Luckily, Oracle provides many tools to help us test, such as SQL, PL/SQL, the data dictionary, dynamic performance views, ...