Monday, October 25, 2010

Final day to submit your abstract for ODTUG 2011

There is only one day left to submit your presentation for the ODTUG conference... so you have to be quick to think about your title and abstract.

ODTUG is a great conference to meet and share ideas with other people using APEX. I always enjoy viewing others people presentations.

If you want to have your hour of fame, don't hesitate to submit!

Monday, October 18, 2010

SQL Developer 3 EA new features

Last week seemed to be the week of the releases of the SQL Developer team. After Oracle Data Modeler 3.0 early in the week, it was the turn to SQL Developer at the end of the week.

Version 3.0 of Oracle SQL Developer has many new or enhanced features

  1. DBMS Scheduler
  2. DBA Functionality
  3. Files and Version Control
  4. Migrations
  5. PDF
  6. PL/SQL Support
  7. Query Builder
  8. Schema Browser
  9. SQL Plus Commands
  10. Spatial
  11. Tuning
  12. Unit Testing
  13. Unloading and Uploading
As you see some very cool and useful features. In some of our projects we use Spatial and Locator and the Map Viewer will become handy there. Having a DBA pane to get more info about the DBA is great too, so you don't have to write your own statements (scripts) or use EM.

I tried the Query Builder, but that didn't seem to work for me. It took a long time to search for the objects, but finally I just got a blank window. I could add other tables from other schema's, but the schema I was connected to was not included. Maybe I'm doing something wrong or it's because of the EA state and it's not optimal yet, not sure. I didn't really go into much detail to find the real cause as I've other priorities at the moment.

Next to the list of new features at the oracle website, it's also worthwhile to follow Kris Rice's, Sue Harper's and Barry Mcgillin's blogs as they blogged (or will be blogging) about some of the new features and included some demos. They are actually in the team that build this wonderful tool!

Thursday, October 14, 2010

Data Compare for Oracle

Just a quick note to say the people at Redgate have a public release of Data Compare for Oracle now. If you ever want to compare your data, this might be an option for you.

They are the same people who build Schema Compare for Oracle which I reviewed some time ago.

Monday, October 11, 2010

Oracle Data Modeler 3.0

I just read that SQL Developer Data Modeler is out (renamed to Oracle Data Modeler).
The Early Adopter release for 3.0 can be found here.

Also check Kris Rice's blog as he's doing some nice blog posts about this new version and the features that come with it.

Oh... and if you didn't know yet, Oracle Data Modeler is FREE now :-)

Friday, October 08, 2010

APEX 4.0 Tree

In APEX 4.0 there's a new Tree Region. It's really cool and a lot better than the previous tree in APEX 3.x.

When you navigate throughout this tree there is no submit anymore, it also looks a lot better.

The only catch is that the query is not that straight forward.
If you look under the query, you'll see the explanation what columns the query should have etc. Be careful as the example under need is missing the level column!

Anyway, check out the tree, it's definitely something that people seem to like.