Continuing the nation theme, here’s another six SQL clues to countries. Can you get them all?
where business = 'abbreviated';
where contents in ('beef', 'kidney beans');
where actor = 'Tom Green';
where allegiance = 'Confederate';
where second_person = 'female';
As always, put your answers (more...)
What a great conference – there’s been a lot of praise for the organisers and all the speakers. I haven’t missed a conference since I started 15 years ago, and I hope it keeps going (in one form or another) for a long time to come.
This year I attended the following sessions (some titles changed for effect):
Björn Rost – 12c for DBAs and Developers; FDA (time to drop those journal triggers)
Scott Wesley – CSS & (more...)
What a view!
I just returned from my first trip to Utah where I briefly (I was only there for 28 hours!) touched down in Salt Lake City to attend the UTOUG Fall Symposium.
Before I give you the run down, if you just want to cut to the chase, here are the session slides:
Evolving From Legacy to Mobile and Beyond
The Next Two Years: What Should I Do NOW with My Oracle Forms (more...)
Somehow it is already November, which means I haveto start gearing up for all the travel that I will be doing this month. I just got back from my first trip to Utah for the super UTOUG Training Days. The team treated us like royalty and it was fun being able to bring a bit of the legacy to mobile message to the Salt Lake City. Now in less than 2 weeks….Germany here I come!
Dieser Tage hat mir mein Bruder mitgeteilt, dass ich die Wendung "Dieser Tage" zu Einleitungszwecken etwas zu sehr strapaziere.
Dann vielleicht: gestern? Gestern also hat Jonathan Lewis
in seinem Blog einen Artikel zum Cardinality-Feedback veröffentlicht, der auf einer Frage basiert, die vor einigen Tagen in Oracle-L aufgeworfen wurde - und bei der es darum ging, dass eine Query, die bei der ersten Ausführung eine angemessene Laufzeit aufwies, bei der zweiten Ausführung sehr langsam wurde, was (more...)
Originally posted on HeliFromFinland
You can easily document your database with Data Modeler: just reverse engineer the database with File-> Import -> Data Dictionary. But what if the database has no foreign keys? What’s the point of documenting then? Just tables that has nothing to do with each other…. Well, Data Modeler can help with…
There's a little over a week left to this year's major Oracle user group event in Perth, so attention all locals (or even east coasters) - if you're interested in picking up new skills & ideas - you haven't got much time left to register
This year it's called a "Professional Learning Event" instead of a conference and the program reflects it - plenty of hands on workshops mixed in with normal sessions. Considering it's (more...)
I'll be presenting an online webinar for ODTUG not long after the Perth conference.
It will be the same session I did for AUSOUG back in July, which is lucky since it's 6am for us Perth locals. It's a close look at the Oracle APEX 5 Page Designer
, and what it means to you as an APEX developer.
Check the webinar registration
page for details on the abstract and help with the time zone (more...)
Your applications contain 20-30% dead code that is never executed. Not just commented-out code that programmers have left in “just in case”, but routines never called, branches never executed and screens never displayed.
The cost of software maintenance depends on the size of the code base, but systems with dead code are more expensive to maintain. This is because every time a developer comes across a dead piece of code, he becomes unsure: “I wonder (more...)
What could be simpler than a set of “Next” and “Previous” buttons?
I love Interactive Reports, they make it easy to deliver a lot of power to users for very little development effort. However, with that power comes some complexity for building certain features not available in the base Apex toolset.
I had an IR with a fairly costly and complex query behind it, linked to another screen to view the details for a record. The (more...)
This article describes how to standardize your JDeveloper Patching as requested in Planning & Getting Started – Team, Skills and Development Environments. It is part of the ADF Architecture Practice lessons and describes the patching with examples for windows.
In this version the Oracle OPatch is delivered with the silent installation of JDeveloper.
All what you need is the patch file for your platform (e.g. p19591087_121300_Generic.zip for JDEVADF SECURITY (more...)
A couple of very, very basic observations on getting going with 12c Inmemory in a multitenant database.
1. When trying to set inmemory_size within a PDB when inmemory_size is 0 in the CDB
ORA-02096: specified initialization parameter is not modifiable with this option
SQL> alter session set container = cdb$root;
SQL> select value from v$parameter where name = 'inmemory_size';
SQL> alter session set container = orcl;
SQL> alter (more...)
Oracle Database 12c introduces a
SEARCH_CONDITION_VC column to the
USER_CONSTRAINTS views. The
SEARCH_CONDITION_VC column is a
VARCHAR2 data type equivalent to the search condition in the
LONG data type
SEARCH_CONDITION column. Unfortunately, Oracle Database 11g and earlier versions requires you to convert the
LONG data type to a
VARCHAR2 for the equivalent behavior. This post provides you with a function to help you do that in (more...)
Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates.
If you are wondering why you are getting this error message after following the example in the documentation describing procedure CREATE_COLLECTION_FROM_QUERYB2 in the APEX_COLLECTION API, the quick answer is that the sample code is flawed.