CHAPTER4Expanding the SQL Horizons
The following good-old database half-wisdom/half-joke, often attributed to Tom Kyte, is still as valid as ever:
1. If you have something to do in the database, do it in SQL.
2. If you cannot do it in SQL, do it in PL/SQL.
3. If you cannot do it in either SQL or PL/SQL, do it in Java.
4. If you cannot do it in Java, do it in C.
5. If you cannot do it in C, are you sure that it needs to be done?
The reality is a bit more complicated because there are a lot of dimensions involved when comparing different approaches, such as performance, maintainability, available expertise, ...
Get Oracle PL/SQL Performance Tuning Tips & Techniques now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
