Oracle 11g for Windows can now be downloaded via OTN
As Laurent already posted on his site; Oracle has made Oracle 11g for Windows (11.1.0.6.0) available on OTN. So you are now able to download it if you prefer …
Category: Database
Custom sql scripts in OAM
I noticed Oracle Applications Manager has some very handy sql script you can use when monitoring your EBS environment. When starting up OAM, navigate to Site Map —-> Monitoring …
OAUG Fusion Middleware BootCamp Chicago – Part II
Today was the first day of the FM BootCamp. After a brief introduction of the program we started with our first topic of this two-week intensive hands-on Fusion Middleware Experience. …
OAUG Fusion Middleware BootCamp Chicago – Part I
Well,Today finally was the day. I have been looking forward a lot coming to Chicago for the Fusion Middleware Bootcamp. Getting up around 5:30am to get to the train …
Oracle 11g for Developers – presenting at Oracle Benelux User Group Conference 2007
Yesterday was nice. Alex and I had two presentation ‘gigs’, the second of which was in the Amsterdam Arena, the AJAX Amsterdam stadium: It was sold out! Well, our …
Hands-on introduction to Oracle 11g at the AMIS KC Server Development event, Donderdag 1 november, 16.30 uur
![Hands-on introduction to Oracle 11g at the AMIS KC Server Development event, Donderdag 1 november, 16.30 uur]({"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"http:\/\/seattletimes.nwsource.com\/ABPub\/2012\/08\/02\/2018836700.jpg","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"} "Hands-on introduction to Oracle 11g at the AMIS KC Server Development event, Donderdag 1 november, 16.30 uur")
We have been playing with Oracle 11g for quite some time now. Walking around in the toy-store if you like. Trying out many new features, trying to push them …
MOOW 2K7 – Finishing up
After surviving the water slides the day before my colleague Gerwin and I enjoyed again a great breakfast and a lot of coffee. For me this is an essential …
Oracle 11g Total Recall – Flashback in the hands of Database Designers and Application Developers, at last. And: the end of Journalling Tables
One of the new features in the Oracle 11g database is called Oracle Total Recall. This is called marketing! I have read some weblogs where people – mostly DBAs …
Flexible Row Generator with Oracle 11g Unpivot Operator
Row generation is a very useful technique for many (semi-)advanced SQL Queries. We have discussed various methods for row-generation in previous articles on our weblog. Examples are the CUBE …
Using Oracle 11g Virtual Columns for implementation of Dynamic Business Rules
With the new 11g feature Virtual Columns, we can (almost) declaratively implement dynamic constraints, such as: salaries can not be increased by more than 10% employee records can only …
MOOW 2K7 – The Friday Sessions
I stood up at 07 o'clock and after a great meal in a restaurant, I attended my first session: Tapio Lahdenmäki's presentation about "Rethink your Indexes". A lot of …
Oracle 11g – Virtual Columns – to publish derived column values without storing them. And more…
Oracle 11g introduces Virtual Columns. “What do we need Virtual Columns for, aren’t real ones more useful?” you might wonder. And what are they to begin with? A virtual …
MOOW 2K7 – The drive home, Come Home- Event (Thursday)
Thursday morning, somewhere between 11.00 and 11.03 hours, the Miracle Express left from Anjo Kolk's home. From the almost 40 Dutch participants of Miracle (Oracle) Open World event, 12 …
Oracle 11g Partial Table Flashback (flashback only selected columns or a subset of records)
Oracle 9i started introducing Flashback technology into the Oracle RDBMS. Flashback unlocks the UNDO data already available in the Oracle database for read-consistency, for other applications. Using Flashback queries …
Yes, it is here too: the PIVOT operator in Oracle 11g
Pivoting is all the rage. Turning rows into columns. You can do it in Excel, in all BI/OLAP tools and we could do it in Oracle using clever tricks …
The Oracle 11g UNPIVOT operator – turning columns into rows
The PIVOT operation is one frequently discussed when talking about more advanced SQL Queries. Pivoting is the process of switching rows and columns, and is for example an advanced …
DBMS_COMPARISON – to compare and synchronize tables (new in Oracle 11g)
One of the interesting new pieces of functionality in Oracle 11g is offered by the DBMS_COMPARISON package. This package allows us to compare two tables – or two views …
MOOW 2K7 – The Miracle Express
It’s the day before Miracle Oracle Open World 2007. Tomorrow the (Dutch) Miracle Express will leave and will make its way from Garderen to Lalandia, Denmark. Hopefully arriving with …
Importing Access applications into Apex
Some time ago I’ve been experimenting with the Apex 3.0 feature that migrates entire Access applications to Application Express. It took me a lot of time because I found …
Check out the Apex 4.0 preview at Carl Backstrom's blog!
The live demo presented by Carl Backstrom as presented to the attendees of the Apex European Training Days is now publicly available! You can review at Carl’s blog , …
XML Data – To be stored or not to be stored, and beyond…
It is nagging… I got an email from that you are able to download the handouts from ODTUG until half September (download them now, 1/2 September they will be …
In between AMIS consultancy jobs…
This (for this site) is a strange post… I am looking for a consultancy job. Nothing new here, but only a strange way to make this visible to the …
Enqueuing AQ JMS Text Message from PL/SQL on Oracle XE
Today I was configuring a message driven bean to listen to an AQ queue. The tutorials and examples I found had me create the queue like this: dbms_aqadm.create_queue_table( queue_table=>'MY_QUEUE_TABLE' …
CTAS on a Table with Nested Tables
The other day one of my colleagues asked me if it is possible to create a copy of a table with all the content in it. He wanted to …
Used port numbers by the Oracle OEM agent
This is definitly a post worthy as one of the members of the BAAG. The work was extensive (setup, config, install, checking) and afterwards the outcome could have been …
Implementation Restricted Relaxed in Oracle 11g
If you are a regular user of the FORALL statement, you are probably also familiar with this message: PLS-00436: implementation restriction: cannot reference fields of BULK In-BIND table …
New in Oracle 11g: Read Only Tables
In Oracle 11g database it is possible to make a table really read only, also for the owner of that table. Until now a table could only be made …
Getting started with JPA mapping : How IntelliJ can map your data with a few clicks
With JPA, there finally is an ORM standard and every major IDE has support for it. Today I will show you how to map your data with IntelliJ IDEA. …
New in Oracle 11g: PL/SQL Function Result Cache
A new feature in the Oracle 11g database is the ‘Function Result Cache’. When you create a function with the new clause ‘RESULT_CACHE’ the result of the function is …
New in Oracle 11g: the FOLLOWS Clause in Create Trigger Statement
The order in which triggers of the same type fire is arbitrary. But in Oracle 11g the create trigger statement has a FOLLOWS clause. With the FOLLOWS clause you …
DBMS_PROFILER Report for SQL Developer
Oracle SQL Developer offers the ability to create reports with graphs in it. A number of reports are included with the tool, unfortunately a report which shows information based …
Oracle 11G: XMLQuery = eval
A nice little trick on Oracle 11G is using XMLQuery as an eval function: SQL>l 1 select substr( sys_connect_by_path( level, '*' ), 2 ) || ' = ' …
New PL/SQL Compiler Warning in Oracle 11g
The PL/SQL compiler in Oracle 11g will give you a warning if it encounters a when others exception without a raise or raise_application_error. SQL> alter session set plsql_warnings='enable:all'; Session …
New PL/SQL Feature in Oracle 11g: CONTINUE
A minor new PL/SQL feature in Oracle 11g is the new statement ‘continue’. With the continue statement you can skip to the next iteration in a loop. A small …
EclipseLink – Youngest Open Source Project provides venerable Java Software – TopLink’s enterprise level Object Relational and Object XML mapping now open source
Some months ago, Oracle announced its plans to donate the high end Object Relational Mapping Framework TopLink to the open source community. To be more specific: under the EclipseLink …
My rediscovery of vi
I am sure I am one of those humans that are using something for a long long time, and suddenly find out they have been doing things in a …
Calling a PL/SQL Function at the wrong time gets me into trouble – the dreaded ORA-0113 End of Comunication Channel with a hierarchical query
I have a query: an in line view, built from two simple queries unioned together, that forms the starting point for a hierarchical (connect by) query. Nothing up my …
ODTUG Kaleidoscope: HOTSOS Instrumentation Library for Oracle
Last week six of us at AMIS attended the ODTUG Kaleidoscope conference in Daytona Beach, FL. I always need some time to digest all the information that was presented …
DBConsole 11g (part 3) – “Transparent Tablespace Encryption and Alerting”
Triggered a little bit by a post of Christo Kutrovsky from The Pythian Group, this post will be about one of the new features on tablespace level: Transparent Tablespace Encryption Until …
DBConsole 11g (part 2) – Using the SQL Performance Analyzer
Now straight into the more interesting Oracle 11g features. Let's start using the SQL performance Analyzer and doing so make use of Replay. The Performance section of the DBConsole …