286 reputation
211
bio website jeffkemponoracle.com
location Perth, Australia
age 38
visits member for 3 years, 3 months
seen yesterday

Oracle Database Designer and Developer

Since 2000 Jeffrey has designed, developed, maintained and enhanced a variety of large and small custom applications for the government sector using Oracle Database 7.3, 8i, 9i, 10g and 11g; Application Express 3.1, 3.2, 4.0, 4.1, and 4.2; Oracle Forms 4.5, 6i, 9i and 10g; Oracle Reports 2.5, 6i and 9i.

He has particular interests and experience in Oracle SQL, PL/SQL, database performance tuning, and Oracle Application Express (APEX).


Feb
5
awarded  Student
Feb
5
asked Use a Context namespace in a multi-tenant database?
Oct
2
awarded  Enlightened
Oct
2
awarded  Nice Answer
Apr
19
comment Why keeps Oracle writing into WARNING_SETTINGS$?
According to psoug.org/reference/dbms_warn_int.html it appears to be related to the PL/SQL compiler warnings. What if you run: ALTER SESSION SET PLSQL_WARNINGS='DISABLE:ALL'; whenever you compile anything? Not sure if this would be equivalent to your add_warning_setting_cat or not.
Feb
1
awarded  Critic
Jan
5
awarded  Yearling
Dec
21
awarded  Citizen Patrol
Dec
20
answered Oracle sort varchar2 column with special characters last
Jan
5
awarded  Teacher
Jan
5
awarded  Supporter
Jan
5
answered How do you version your Oracle database changes?
Jan
5
awarded  Autobiographer