Oracle Dynamic SQL – generic search

Posted on April 22, 2013 by Ileana Balcu — No Comments ↓

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: Code, Database, PL/SQL, tips
Posted in BLOG, Oracle, PL/SQL, What's New

Creating a comma-separated list of items from a column

Posted on August 1, 2011 by Ileana Balcu — 2 Comments ↓

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

Tree Navigation in Web apps

Posted on June 1, 2011 by Paul Dorsey — No Comments ↓

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

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.