Re: PL/SQL Dynamic sql

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sun, 13 Jun 2004 07:30:36 +0000 (UTC)
Message-ID: <cagvqs$md$1@titan.btinternet.com>

Steve,

Bear in mind that the huge, static, CASE statement is likely to offer much better scalability than the dynamic option with global packaged variables.

It is valid to trade development time against run time - just so long as it's a deliberate choice

-- 
Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html
Optimising Oracle Seminar - schedule updated May 1st


"Steve Rainbird" <steve.rainbird_at_mssint.com> wrote in message
news:bc30fc0d.0406122320.6c63897f_at_posting.google.com...
Jonathan


>

>

> Thanks for that you may just have saved me writing a huge case statement!

>

> Steve

Received on Sun Jun 13 2004 - 02:30:36 CDT