Jeffrey Kemp

Jeffrey Kemp has asked 12 questions and find answers to 202 problems.

Stats

About

Oracle Database Designer and Developer

Application Designer & Developer at Oracle specialising in Oracle APEX (Application Express), Oracle SQL, and PL/SQL with over 21 years experience. Oracle ACE alumni.

Jeffrey Kemp questions

Highlight differences between two strings
Force Hibernate to issue DELETEs prior to INSERTs to avoid unique constraint violations?
Interesting Oracle analytic query challenge
Error on connecting to Oracle from py2exe'd program: Unable to acquire Oracle environment handle
Get the LENGTH of a LONG RAW
How to call REPLACE with CLOB (without exceeding 32K)
What does style "visibility:hidden" mean for the <html> element?
Resolving ORA-4031 "unable to allocate x bytes of shared memory"

Jeffrey Kemp answers

Oracle 10G - Query using rownum stopped working after migration from 9i
Oracle Reports splitting columns to extra rows in spreadsheet output
Lost update in Concurrency control? [closed]
Oracle SQL VARCHAR2 datatype storage
An SQL query with a WHERE greater than a count, when another field is already in GROUP BY
Oracle: using WHERE ROWNUM = 1
When is the code between a PL/SQL Package begin/end block executed?
Getting weird issue with TO_NUMBER function in Oracle
Setting the value of a form field from a Query
PLSQL : Get sum for each day of week and total sum for week in a single query