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…
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: misha, Oracle, paul dorsey, performance tuning, PL/SQL, tuning
Posted in BLOG, Code tips, Development, Dulcian News, News, Oracle, Our Books, PL/SQL, Publications, Resources, What's New
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…
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…
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…
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: ADF, Forms converter, Formspider, Java EE, Oracle Forms, PL/SQL
Posted in BLOG, Consulting, Development, Products
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: 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…
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
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…
