Skip to main content

Avoid Anti-Patterns

  • Chapter
  • First Online:
Pro Oracle SQL Development
  • 925 Accesses

Abstract

So far this book has mostly focused on what we should do. It is also helpful to discuss the things we should not do. This chapter contains a list of anti-patterns – programming concepts and styles that we should avoid.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Notes

  1. 1.

    Joel Spolsky has written about the problems with rewriting code from scratch: www.joelonsoftware.com/2000/04/06/things-you-should-never-do-part-i/ .

  2. 2.

    In version 12.2 we could also use this new syntax to handle conversion errors: TO_DATE(VALUE DEFAULT NULL ON CONVERSION ERROR, ‘YYYY-MM-DD’). While that function is perfectly safe, we still have to remember to use it every time we reference an unsafe column.

Author information

Authors and Affiliations

Authors

Rights and permissions

Reprints and permissions

Copyright information

© 2019 Jon Heller

About this chapter

Check for updates. Verify currency and authenticity via CrossMark

Cite this chapter

Heller, J. (2019). Avoid Anti-Patterns. In: Pro Oracle SQL Development . Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-4517-0_15

Download citation

Publish with us

Policies and ethics