Steven Feuerstein reviews our book!

Steven Feuerstein, the PL/SQL architect at Oracle Corporation reviewed Michael Rosenblum and Paul Dorsey’s new book: Oracle PL/SQL Performance Tuning Tips & Techniques: I recently received a copy of Michael Rosenblum’s and Dr. Paul Dorsey’s latest book: Oracle PL/SQL Performance Tuning Tips

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

Oracle PL/SQL Performance Tuning Tips & Techniques

Dulcian’s Michael Rosenblum and Dr. Paul Dorsey have just completed another book for Oracle Press: Oracle PL/SQL Performance Tuning Tips & Techniques This book present a hands-on approach to enabling optimal results from PL/SQL. The book begins by describing the discovery

Tagged with: , , , , ,
Posted in BLOG, Code tips, Development, Dulcian News, News, Oracle, Our Books, PL/SQL, Publications, Resources, What's New

Thoughts on Performance Tuning

Michael Rosenblum and I are writing a book about PL/SQL performance tuning for Oracle Press. I started thinking about the “big picture” ideas that everyone should know.  The following is the list that I came up with. If you have

Tagged with: , ,
Posted in BLOG, PL/SQL, Publications

Oracle Dynamic SQL – generic search

From Michael Rosenblum’s blog a series of three posts on how to do a generic dynamic SQL search in PL/SQL with Native Dynamic SQL – the example does not use DBMS_SQL and uses bind variables to help optimize the query. In

Tagged with: , , ,
Posted in BLOG, Oracle, PL/SQL, What's New

If you don’t ask, you will never find out why your system is performing poorly

We had a large operation that took up to a minute to run.  It was copying data to a staging area, running over a thousand data validation rules (~50,000 lines of code), and then formatting all of the validation errors

Tagged with: ,
Posted in BLOG, PL/SQL, SQL

The Challenge of Converting Oracle Forms to ADF (or other J2EE)

“How do I convert my Oracle Forms applications to…?” I have been getting this kind of question ever since JDeveloper 3.0 was released. As soon as BC4J (now ADF BC) was created, we started seeing the handwriting on the wall.

Tagged with: , , , , ,
Posted in BLOG, Consulting, Development, Products

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

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

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
Disclaimer
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.