Matthew McPeak

Matthew McPeak has asked 5 questions and find answers to 50 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

Oracle SQL: how to enforce only one value may be 'checked'?
Oracle - Get statistics of a query
PL/SQL Add Multiple Columns to Query with Single Function
PL/SQL Package level exception handling
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