Community Page
- awads.net/wp/ Jump to website »
-
Subscribe -
Community
-
Top Commenters
-
Popular Threads
-
Recent Comments
- wow this suxxxxxxxxxxx
- My husband works in China. When I visited I met some lovely Chinese people. One young man went out of his way to show us China. Wonderful shopping experiences & friendship. My husband is...
- Thanks very much for sharing that Eddie, it saved me a lot of time! Best regards, -Adam vonNieda
- Hi William, I'm assuming you're referring to the usefulness of Enso or other launcher applications. I have Firefox open all the time so it does not make much difference there. From personal...
- To open Firefox, wouldn't it be simpler to click on the Firefox icon? Or in Windows, press Win-R to get a "Run" prompt and type "firefox"? Google and Dictionary.com already...
Eddie Awad’s Blog
News, views, tips and tricks on Oracle and other fun stuff
The document below contains patterns of bad SQL and PL/SQL code that Gojko Adzic has repeatedly found in various applications and databases. Some of the bad practices include:
Use of WHEN OTHERS in exception handling.
Embedding complex SQL inside PL/SQL code.
Poor PL/SQL error ha ... Continue reading »
Use of WHEN OTHERS in exception handling.
Embedding complex SQL inside PL/SQL code.
Poor PL/SQL error ha ... Continue reading »
1 year ago
Witness the title, which apparently refers to only SQL and PL/SQL and then the following claims which have *nothing* to do with SQL or PL/SQL and are all about database and application *design*:
Storing ROWIDs for later reference,
Storing an empty LOB instead of NULL,
Use of magic numbers and strings instead of NULL.
Talk about confusing the confused...
1 year ago
But what I really prefer is views with Instead of triggers. You get all of the benefit of using an API, but you can use any tool that expects to be updating a table.
1 year ago
You've also got two objects to deal with. Not necessarily a bad thing if the view can be re-used. But you are likely to be faced with the choice of putting filter conditions within the view itself, or as part of the query against the view.
1 year ago
@John: yes, it makes sense to use a tool to generate packages for API access to table data. I believe Quest CodeGen Utility http://qcgu.net/ can do that for you.
@gary: I agree with you. One approach is to wrap all SQL, complex or not, into separate functions.