A number of years ago, a Masters Degree student sent me an email asking what project methodology was best. Should we use an iterative Agile approach, or was a waterfall better in some cases? What about RUP and all of its variants?…
Expert PL/SQL Practices for Oracle Developers and DBAs
Expert PL/SQL Practices for Oracle Developers and DBA’s was released on August 1, 2011. It was written by 15 PL/SQL senior developers and DBAs. Since one of them is my colleague and friend, Michael Rosenblum (Misha), I got the chance to…
Tagged with: advanced PL/SQL, Database, expert, Michael Rosenblum, Oracle, PL/SQL
Posted in BLOG, Our Books, Resources
Posted in BLOG, Our Books, Resources
Creating a comma-separated list of items from a column
We needed to create a comma-separated list of items out of a column. We wanted “Red,Orange,Blue,Black,White”, and in the database we had Red Orange Blue Black White Grigoriy Novikov came up with a number of solutions: Solution 1: The basic…
Installing Oracle 32b Development tools in Windows 7
If you are trying to install some of the Oracle Development Tools (Oracle Forms, Oracle Reports, Oracle Designer) in a Windows 7 environment and you need access to the Registry, you can find those entries by using regedit in the…
Tagged with: Oracle Designer, Oracle Forms, Oracle Reports Builder, registry, Windows7
Posted in BLOG, Code tips, Consulting, Oracle, PL/SQL, SQL
Posted in BLOG, Code tips, Consulting, Oracle, PL/SQL, SQL
Tree Navigation in Web apps
Anyone can make a tree display, but tree navigation involves much more. What you really want on a tree includes all of the following: 1. Only load nodes that are necessary. 2. Provide the option to reload every time the tree…
Tagged with: PL/SQL, tips, web application development
Posted in BLOG, Code tips, Consulting, Development
Posted in BLOG, Code tips, Consulting, Development
Definition of business rules
First we need to recognize that the Business Rules Forum (BRF) folks see rules as pretty big things. Ron Ross talks about the possibility of 1000 or more rules in an ERP. I think of those as analysis rules. The more detailed implementation…
Tagged with: BRIM, Business rule, FAQ, Natural language
Posted in BLOG, Consulting, Development, Resources
Posted in BLOG, Consulting, Development, Resources
