Jeffrey Kemp

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

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
Limitations of APEX for WebApp
PL/SQL Cursor for loop
In SQL, How can I generate every possible unique combination of 5!56?
How to set conditional logic in SQL query in order to shuffle the precedence?
ORA-00054: resource busy and acquire with NOWAIT specified
Why does Oracle varchar2 have a mandatory size as a definition parameter?