Matthew McPeak

Matthew McPeak has asked 5 questions and find answers to 46 problems.

Stats

About

Most of my development is in Oracle PL/SQL or Java, in support of Oracle e-Business Suite Supply Chain implementations or custom supply chain systems development.

Matthew McPeak questions

Java - detect whether there is an exception in progress during `finally` block
Is this a valid way to minimize binding invalidations?
ConcurrentHashMap needed with ReadWriteLock?

Matthew McPeak answers

Does creating index on table containing million of rows causes any issue? Any danger exists for doing the same in live production DB?
select most recent values in very large table
Consistency for simultaneous UPDATES in Oracle, when the WHERE clause depends on the old value
use bind variable with LIKE % operator
EXECUTE IMMEDIATE PL/SQL Block return type
Why use left join at all
More Efficient Way to Grab the Latest Value based off a composite index?
get_release Oracle API returning "Unknown" result instead of correct release
How to avoid duplicate insert in DB through Java?
Why does Oracle pseudo column CONNECT_BY_ISLEAF seems broken?