Category: Database
The UNPIVOT operator was introduced in Oracle Database 11g – see for example: https://technology.amis.nl/blog/2421/the-oracle-11g-unpivot-operator-turning-columns-into-rows. In Oracle, the UNPIVOT operation is the process of turning Columns to Rows. Put simply, …
Sunday’s Conference day started very early at around 07:30 by going straight to registration, then on to a quick breakfast and the first session at 08:30 AM. Joel Kallman …
In the past few weeks, I have encountered a similar discussion in various organisations. Each organisation uses either SOA Suite (11g) or Oracle Service Bus (11g) at the core …
Some IT organizations that I visit have a sign somewhere indicating the number of days that have passed without a major issue. Production sites with proper respect for health …
Whilst preparing for the Thursday Thunder session at the last day of the ODTUG Kaleidoscope 2011 conference in Long Beach, where an all star team of moderators and developers …
You may have seen we write on Flashback functionality in the Oracle Database. It’s an area that I like – especially since the introduction of the Flashback Data Archive …
This very brief article demonstrates how a fairly complex, nested JSON document can be created using a single SQL query. The main features used in the SQL statement are …
Alex Nuijten
June 14, 2011
Announce / Events, Database, DBA Oracle, Development Tools, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, PL/SQL, SOA, Software Engineering, Web/Java, XML
Ook dit jaar, namelijk op dinsdag 14 Juni, organiseert AMIS de ODTUG Preview. Het jaarlijkse congres van de ODTUG, de Oracle Development Tools Users Group, vind dit jaar plaats …
Once upon a time, I had something of a reputation for creating Charts in SQL. Bar Charts, Pie Charts, Gantt Charts and several other unlikely chart types, all created …
One of the topics I discussed in today’s Masterclass Advanced Database Development was inter-session communication – or how database sessions can exchange information. One of my favorite vehicles to …
Have you ever wanted to replace a character in a string just by position? I needed this the other day and IMHO there is no way in Oracle PL/SQL …
The XBRL Extention, a no cost add-on extention on XML-DB targeting the Extensible Business Reporting Language area, is now available for download. This second release ( p12388668_112020_Generic.zip ) of …
De Oracle Database is in zekere zin ook een Applicatie Server. Of in elk geval is de database een zeer krachtige infrastructuur die door allerlei soorten applicaties kan worden …
Roel Hartman and me are currently very busy with our Kaleidoscope 2011 presentation “XFiles, the APEX Version: The Truth is in There…“. During this presentation, we will demonstrate the …
There is often a need to synchronize data from a query. For example reading external data and update the tables. Sometimes it can be achieved by a single merge …
In my quest to position ‘connect by’ (and its 11g successor, Recursive Subquery) as mechanism for recursive queries rather than just an hierarchical query facility, I stumbled across a …
I’ve been using RAC (10gR2) for years now and I was wondering how RAC One Node differs from RAC. That’s why I used a few ‘old’ RAC servers that …
It is only beta at this point, but the long awaited Oracle 11gR2 XE edition – free but with certain limitations – is available for download from OTN – …
For a couple of months I have been discovering the Android platform. As an original Oracle developer I was wondering how an Android app can be connected to an …
One of our customers had this request: Can you make a backup of my development database that I can use to restore ( the same database ) to a …
Een upgrade naar de nieuwste versie van de Oracle Database vindt zelden plaats op initiatief van het applicatie-ontwikkelteam. Upgrades worden meestal gedaan in verband met support-regelingen, op verzoek van …
In the recently published blog article Database Transaction Recorder – Adding Who to When and What to make Flashback take over from Journalling tables (https://technology.amis.nl/blog/10911/database-transaction-recorder-adding-who-to-when-and-what-to-make-flashback-take-over-from-journalling-tables) I have discussed how …
I have to admit that, even though I have tried on several occasions to dive head first into APEX, so far I have only wet my feet. I have …
In previous articles, I have suggested that the arrival of the Flashback Data Archive in Oracle RDBMS 11g allowed us to finally say goodbye to journalling tables. Keeping track …
This article demonstrates how Java application can query data from relational databases (well, in this case more specifically the Oracle RDBMS) without the use of plain old JDBC but …
A few years ago I was lucky to be able to start working for a client that has Oracle RAC clusters. There we encountered lot’s of interesting issues, and …
As PL/SQL developer you probably have worked with object types before and maybe you also know that you can add methods (i.e. functions and procedure which operate on the …
The new ready to download Oracle XBRL Extension is a “no cost option” on top of the latest Oracle Database 11.2.0.2.0 release. With this added functionality you will get …
It is a strange thing really: querying the database to find missing data. Queries usually report on what is there. Not the queries in this article (and its prequel): …
The other day, I came across a press release – www.iso.org/iso/pressrelease.htm?refid=Ref1383 – from the ISO organization, announcing that they had issued new country codes for the islands in the …
Its almost Christmas and the end of this 2010 year and I keep wondering what will happen, Oracle wise, in 2011. I have, had, my idea’s about what might …
When you want to expose your Stored Procedure to the “outside world”, should you do this using XMLType? As always, the correct answer is “it depends”. For this example …
Sometimes it is necessary to create a Stored Procedure which returns an XMLType, like when you want to expose the Stored Procedure to the “outside world”, like via a …
One of the key objectives – though not ulterior motives – in Service Oriented Architecture is decoupling. By decoupling currently mutually dependent agents, we introduce more opportunity for flexibility, …
Usually in SQL queries, you will try to retrieve information from a database by reading specific records from the relevant tables. However, there are situations where what you want …
I have had trouble with a certain view I have to create at the customer site I am currently working at. The view involves 3 SQL queries combined by …
Really getting the most out of your database. That would be nice, given wat databases can do (and what you may have paid for them). Few serious Java Applications …
One of the requirements at my current project is to have one ADF table display data from different database tables. That is, depending on criteria entered by the user, …
This article accompanies the similarly named article in the Dutch Java Magazine. It provides additional resources, some source code and an invitation to the 4 February Masterclass by Lucas …
I’ve written a small package (1500 lines). But with this package you can generate a PDF-document with a few lines of PL/SQL code. It’s small because it lacks some …
![Replace by position]({"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"} "Replace by position")