Jeffrey Kemp

Jeffrey Kemp has asked 12 questions and find answers to 211 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

Poll Oracle DB for changes
Replace CHAR with VARCHAR2
How To Find First Date of All MOnths In A Year
Oracle SQL possible to trim characters before a character is found?
PL/SQL Validate/Insert/Update Status - retval vs. exception
Do I need a id column in audit table?
Oracle Synonyms issue
PL/SQL: How can I calculate the AGE knowing a column called Birth_Date?
use of owa_util with oracle apex and location line at the end of generated files
Oracle 10G - Query using rownum stopped working after migration from 9i