From: "Paul Brewer" <paul@paul.brewers.org.uk>
Newsgroups: comp.databases.oracle.server
References: <dbb1ff9aff315c3db8df54727be3cbb6.32095@mygate.mailgate.org> <ts91t2j6kgvmaf@news.demon.nl>
Subject: Re: Filtering data
Date: Wed, 10 Oct 2001 21:00:39 +0100
Lines: 27
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
NNTP-Posting-Host: ppp-1-49.cvx2.telinco.net
Message-ID: <3bc69182_2@mk-nntp-1.news.uk.worldonline.com>
X-Trace: 12 Oct 2001 07:45:22 +0100, ppp-1-49.cvx2.telinco.net
Path: news.easynews.com!easynews!cyclone2.usenetserver.com!usenetserver.com!news-hub.cableinet.net!blueyonder!newspeer.clara.net!news.clara.net!dispose.news.demon.net!demon!mk-nntp-1.news.uk.worldonline.com!ppp-1-49.cvx2.telinco.net
Xref: easynews comp.databases.oracle.server:121012
X-Received-Date: Fri, 12 Oct 2001 02:01:20 MST (news.easynews.com)

Agree. Efficiency, robustness, encapsulation, network traffic...

As Sybrand wrote in a different  thread (something like) - could you please
e-mail _all_ my developer colleagues with this invaluable advice? :-)

Other possible 'commandments' (perhaps 'recommendations'?):

Use format masks for dates wherever possible, rather than rely on defaults
Avoid relying on type conversions
Consider 'order by decode' before writing lots of client-side code
Bind your variables whenever practicable

All contributions welcome.

Paul

"Sybrand Bakker" <postbus@sybrandb.demon.nl> wrote in message
news:ts91t2j6kgvmaf@news.demon.nl...
>
<snip>
> One of the first commandments in using Oracle is you should do
*everything*
> on the database side what you *can* do on the database side.
<snip>
>