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

We’re Hiring Software Developers!

Software Developer Woodbridge NJ – Full Time About Us Dulcian has a team like no other with consultants who are active authors and presenters at leading IT conferences. We build software according to the client’s specifications quickly and efficiently. Our

Tagged with: , , ,
Posted in BLOG, Development, Dulcian News, News, Oracle, PL/SQL, 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

Programs that Write Programs, are the Luckiest Programs in the World

I am not a big fan of boring, mind numbing, repetitive tasks.  I remember my early days working with word processors and spreadsheets.  If you needed to do a task more than about 10 times, it usually made sense to

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

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