Re: More on ORA-01722
From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 21 Mar 2013 12:39:45 -0000
Message-ID: <0dGdnbMIj_X2YtfMnZ2dnUVZ8sSdnZ2d_at_bt.com>
Date: Thu, 21 Mar 2013 12:39:45 -0000
Message-ID: <0dGdnbMIj_X2YtfMnZ2dnUVZ8sSdnZ2d_at_bt.com>
"vsevolod afanassiev" <vsevolod.afanassiev_at_gmail.com> wrote in message news:8607bd35-fb8e-4a15-95c5-dd7cddad8f49_at_googlegroups.com... | Another option is to establish some ranking: a number can always be converted into a string but the opposite isn't true.
A number can be converted into many different strings -
with, or without, separators,
with, or without, leading spaces or zeros,
fixed precision (trailing decimal zeros)
etc.
Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com/all-postings
Author: Oracle Core (Apress 2011)
http://www.apress.com/9781430239543
Received on Thu Mar 21 2013 - 13:39:45 CET