calling an oracle functions (ie decode and lpad) from java
Posted on 2003-10-24
I'm trying to incorporate an oracle 'DECODE' function in one of my querystrings, and an oracle 'LPAD' function in another. If heard this would help performance...When using a regular statement, I get an 'invalid column' error (and yes, I've checked a gazillion times). I'm new to jdbc/java.sql...Should I be using something else/perhaps a callable statement in code? Is this the best thing to do for performance or should I do the decode/lpad work in java?