Re: Dumb Developer tricks

From: Yechiel Adar <adar666_at_inter.net.il>
Date: Sun, 31 Jan 2010 08:56:53 +0200
Message-id: <4B6529B5.1050409_at_inter.net.il>

The second one is a replacement for "substring" function that word in mysql and sql server but not on oracle.
If you want you code to work across platforms, you need to add "substring" function in oracle.

I will not comment about the wisdom of selecting from dual.

Adar Yechiel
Rechovot, Israel

Connor McDonald wrote:
> http://www.oracledba.co.uk/tips/worst_plsql.htm
>
> http://www.oracledba.co.uk/tips/substring_substring.htm
>
>
> --
> Connor McDonald
> ===========================
> email: connor_mcdonald_at_yahoo.com <mailto:connor_mcdonald_at_yahoo.com>
> web: http://www.oracledba.co.uk
>
> "Semper in excremento, sole profundum qui variat"

--
http://www.freelists.org/webpage/oracle-l

Received on Sun Jan 31 2010 - 00:56:53 CST