Re: Oracle performance tuning question

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Thu, 23 Jan 2003 09:34:15 -0000
Message-ID: <3e2fb718$0$233$ed9e5944@reading.news.pipex.net>

"DA Morgan" <damorgan_at_exesolutions.com> wrote in message news:3E2C287D.2A45F060_at_exesolutions.com... <snip>
> > WHERE (((SSA_NAME between :l_ie_srch_range.from[0] AND
> > :l_ie_srch_range.to[0])

> Lots of questions ... not so many suggestions. Here they are in no
> particular order?

<snip>
> 11. Why is gl_sysdate stored as a string?

and

12 what exactly does :l_ie_srch_range.from[0] mean? what data type is SSA_NAME.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************

Received on Thu Jan 23 2003 - 03:34:15 CST