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

PL-SQL Performance Tuning Cover2

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

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

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

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