Actually, I did exactly this a few years ago.
Only problem: NULLs show up as blanks ...
Apart from that, it works like a charm!
-- Peter Vanroose.
Op 23 jun. 2020 22:10, om 22:10, "Fennell, Brian" schreef:
>Another idea . . .
>
>You could also wrap Oracle SQLPlus in p
Short answer, assuming you are including hard-coded SQL into a Perl script:
Place the textual SQL, without any additional backslashes or extra quotes or
whatsoever,
within the following:
my $sql_text = q(
);
Unless you have a closing ")" without a preceding opening "(" in that SQL text
(which
on it only
knows about itself ...
-- Peter Vanroose,
ABIS Training & Consulting,
Leuven, Belgium.
On 16 november 2018 03:09 Daniel Kasak <> wrote:
> [... ]
> I've done quite a bit of search, but can't find any docs that mention
> fetching *databases* - either in ODBC docs or in Per
Use sprintf instead of printf.
-- Peter Vanroose.
On 1 october 2018 12:13 Mike Martin <> wrote:
> If I use printf to round a numeric value before inserting into postgres table
> it is altered to 1 rather than the value when it is put into a table
>
> example
>
> CRE