Kaleidoscope 2009 – Oracle Web Videos

Presenter Dr. Paul Dorsey is an Oracle ACE, the founder of Dulcian, Inc., an Oracle consulting firm, and president Emeritus of the NYOUG. He sat down with Oracle Magazine senior editor Jeff Erickson at the Kaleidoscope Conference 2009 in Monterey,

Posted in Media

Blue Button Plus

Blue Button is a simple concept: give patients’ access to their own data. The U.S. Department of Veterans Affairs (VA) first used the Blue Button logo on its patient portal in 2010 ,By clicking on the button, individuals could download

Posted in Industry News

Case-sensitive object names

A tip/funny story from our colleague Grigoriy Novikov: There was one project with which I was involved that required a lot of different tools used by a lot of developers with different fields of expertise. The Java developer group was

Tagged with: , , , ,
Posted in Code tips, Consulting, Resources, SQL

Surviving Major Database Architecture Changes – ODTUG Journal 2012

Michael Rosenblum published this article in the ODTUG Journal in 2012. The Introduction is below: Changes are inevitable in any information system. Even with the best possible requirements analysis, it is extremely hard to anticipate all of the potential changes

Tagged with: , ,
Posted in Articles, Conferences

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: , , , , ,
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

Tagged with: , , , , , , ,
Posted in BLOG, Code tips, Oracle, PL/SQL, SQL

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: , , , ,
Posted in BLOG, Code tips, Consulting, Oracle, PL/SQL, SQL

Oracle PL/SQL For Dummies

Find tips for creating efficient PL/SQL code If you know a bit about SQL, this book will make PL/SQL programming painless! Do you need to get up to speed on PL/SQL programming?  Read this book to find out about code

Tagged with: , ,
Posted in Oracle, Our Books, PL/SQL, Publications, Resources

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: , , ,
Posted in BLOG, Consulting, Development, Resources

Performance Considerations for Web Applications – Paul Dorsey, Michael Rosenblum IOUG Collab 2009

Paul Dorsey and Michael Rosenblum published this article in the IOUG Web Architecture Best Practices Booklet (Collab’09 edition)  in 2009. The Introduction is below: Many of the performance tuning techniques applied to client/server applications that consisted of rewriting poorly written SQL code and tuning the database

Tagged with: ,
Posted in Articles, Code tips
The information presented on this blog is presented to provide general technical information. If, while attempting to apply any of the ideas, procedures, or suggestions herein, you experience any kind of programming or system problems or failure, it will be as a result of your own actions. Dulcian, Inc. and all authors of text found anywhere on this site, and all internally-linked Web sites, Mail Lists, Blogs and/or e-mail group discussion, disclaim responsibility for any user's actions and any damage that may occur based on information found on this website and associated Mail Lists, Blogs and/or e-mail group discussion. Any technical advice or directions found on or through this site is provided AS IS and its provided without warranty or any guarantee of its accuracy. You perform any modifications to programs or software AT YOUR OWN RISK.