Last month Oracle released a statement of direction for SQL Developer (here it is). Apart from the enhanced testing capabilities the most important feature will be the support of graphical logical and physical data modeling - just like you normally would do using Oracle Designer - using the acquired CDW4ALL extension. This modeling can be [...]

Popularity: 330 points

Using the Preferences of SQL Developer you can register a User Defined Extension (UDE). This UDE is just a small XML file containing a command or query. If your Oracle Designer Repository is queriable by the user you use for your connection, you can show the Table Definitions in Designer alongside the definitions in the [...]

Popularity: 268 points

Our seminar took place Wednesday the 23/04. The blog have been under construction for a while, so therefore this late post
The seminar went very well. There was 55 participants. Some of them were from Logica, so there were around 50 customers which we were extremely happy with. We did a mix of demos [...]

Popularity: 396 points

The last day of the conference already…
The day started with a presentation on Datamodelling using JDev. The presenter showed how JDev could replace Designer for modelling. Imho JDev doesn’t support logical modelling at all (he misused Java class models to represent a logical model), there is no repository and no relation between a logical and [...]

Popularity: 221 points

The (rather ambitious) schedule for today was :
Lost in JDeveloper by Sten Vesterli : Sten guided the (Forms experienced) audience in creating an ADF Swing Client App ofcourse declaratively (next to AJAX this is the buzzword of the conference : everything should be declarative, you can be a programmer when you’ re able in controlling [...]

Popularity: 225 points

After yesterdays Blogger Meetup it was hard to start the day…
The first session of the day was Sue Harper’s talk on SQL Developer Latest Features. She mainly focussed on the new / enhanced features of version 1.5, that will be production somewhere (early?) 2008. To name some new features : external authentication (OPS$ users), [...]

Popularity: 262 points

After a rough flight yesterday I arrived in Birmingham. The city has a complete Christmans atmosphere, as you might expect at this time of year. There even is a ‘real’ Frankfurter Christmas market with ‘Beer und Bratwurst‘ and hot wine - and lots and lots of other more or less Christmas related stuff. I made [...]

Popularity: 218 points

LogicaCMG has a good presence at the upcoming UKOUG in Birmingham (3-6 Dec 2007). These are the subjects presented by LogicaCMG employees (in order of appearance):

From Oracle Forms to J2EE: Why, What and How (not)?
Mr Roel Hartman
03/12/2007 15:20 - 16:20 Track 6

Securing Web Services : From Encryption to a Web Service Security Infrastructure
Mr Peter Lorenzen
04/12/2007 [...]

Popularity: 202 points

From the 11g New Features Guide:
“New in 11.1 is the ability to mark a PL/SQL function to indicate that its result should be cached to allow lookup, rather than recalculation, on the next access when the same parameter values are called. This function result cache saves significant space and time. Oracle does this transparently using [...]

Popularity: 237 points

Oracle 11g is shipped with a number of great new PL/SQL features. One of them - although a very small one - is that access to sequences is allowed in PL/SQL, so no need to “SELECT seq.nextval INTO n FROM dual” anymore!
DECLARE
  n NUMBER;
BEGIN
  SELECT seq.nextval
  INTO n
  FROM dual;
END;

can now be coded as
DECLARE
  n NUMBER;
BEGIN
  n := seq.nextval;
END;

For “currval” the [...]

Popularity: 301 points