Re: Dynamic PL/SQL, MERGE and a Dissapearing Plus Sign

From: Jim Smith <usenet01_at_ponder-stibbons.com>
Date: Wed, 4 Apr 2007 07:27:27 +0100
Message-ID: <JN9HyYWPV0EGFwiE@jimsmith.demon.co.uk>

In message <1175528690.515468.275960_at_o5g2000hsb.googlegroups.com>, jr <jrolandumuc_at_yahoo.com> writes
>Thanks.
>
>JR
>
>dynamicStmt := 'MERGE INTO myTable t USING (SELECT c.a,c.b,c.c,c.d, '
>|| '(case when c.e > 0 then ''+''||c.e '...
>

If c.e is a number, and the target column is a number, then your expression will evaluate to something like '+1234' and be coerced to a number. +1234 is the same as 1234.

-- 
Jim Smith
Ponder Stibbons Limited <http://oracleandting.blogspot.com/>
RSS <http://oracleandting.blogspot.com/atom.xml>

Received on Wed Apr 04 2007 - 01:27:27 CDT