Category: Database
Packages in the Oracle Database are a fine construct to use for creating a service API at PL/SQL level – that through JDBC or other connections into the database …
In our series on the 11g R2 release of the Oracle RDBMS, AMIS staff discusses various functions, features an facilities that have been added, improved or extended in this …
In our series on the 11g R2 release of the Oracle RDBMS, AMIS staff discusses various functions, features an facilities that have been added, improved or extended in …
Many years ago, Oracle basically set the standard in SQL. Whatever was Oracle SQL could be seen as the standard. This has never been absolutely true – ANSIÂ SQL was …
I noticed yesterday a new feature that could have the potential to be a small, by me unnoticed, gem called "Flash Cache". I hope someone on the internet, that …
Oracle 11g Release 2 for Linux can now be downloaded via the Oracle Technology Network here: http://www.oracle.com/technology/software/products/database/index.html The documentation and whitepapers can be found via the following link: http://www.oracle.com/technology/products/database/oracle11g/index.html The …
The Merge statement was introduced in Oracle 9i and improved upon in Oracle 10g. In Oracle 9i only the INSERT and UPDATE parts were supported, in Oracle 10g DELETE …
Recently I presented for the fourth time at the annual ODTUG Kaleidoscope conference. It’s really a great conference that I recommend to every Oracle consultant. It features great presentations, …
Every year ODTUG – Oracle Development Tool User Group – organizes a conference, called Kaleidoscope. This time it was in Monterey, California. If you have never been to …
Last week, this weblog hit the 9M post reads mark. Since we started technology.amis.nl/blog in July 2004, it took us some 5 years to get to that point. …
Oracle posted a press release about their involvement and commitment for UBMatrix XBRL technologies last Wednesday saying (among others): "To help publicly held companies facilitate the preparation, publishing and …
During the years I have a lot of times encountered performance problems that ended up to be fast queries (less than 10ms) which are executed very much. In these …
Lucas already gave a very good in depth overview of the "Hotsos Revisited" session last night. It always amazes me how fast he can make a cool blog post …
It’s Monday night and a select company of DBAs and Database developers have gathered at AMIS HQ in Nieuwegein for the ‘Looking Back at Hotsos 2009’ session. It …
Say, you are in need of a directory listing from within the Oracle database similar to the one generated with Unix command ls. Your database doesn’t contain a JVM, …
The 8th of March 2009…The Oracle Performance Symposium in Irving, Texas, also known as the Hotsos Symposium was about to start… Four Dutch guys had the luck to attend …
Marco Gralike
April 22, 2009
AMIS, Announce / Events, Architecture, Book reviews and Publications, Databases, DBA Oracle, Development Tools, IT, Oracle, Tools
Begin maart 2009 werd in Irving, Texas, het internationale Oracle Performance Symposium Hotsos gehouden. Ook dit jaar stond het symposium garant voor inhoudelijke hoogstaande presentaties en discussies over performance. Vier …
Some time ago, I discussed security in Oracle databases with a customer and explained the role structure in the Oracle database. I explained to him that ultimately it’s the …
Another world shattering topic: analyzing tag clouds. This article describes a very simple first step for some analysis at database level of tags that have been associated with database …
An advert for myself. Wow! How cool is that… The local Oracle User Group Holland starts on the 16th of April with a new series of presentations …
Last Wednesday Quest organized a seminar in Amsterdam on the performance of the Oracle database and the programs you write for it. There were three presentations. Development Application Testing …
An Application Context in the Oracle Database is a name in-memory collection of key-value pairs. Applications can store values in an Application Context – using a package associated with …
In this blog I will show you how easy it is to build a process with Oracle Workflow. This demo consist of an automatic step (plsql function) and …
During the 7Up workshop, a workshop geared towards experienced developers who want to get up to speed with everything that happened in Oracle since release 7, one of the …
For the last two days the AMIS 7Up Workshop took place in our office in Nieuwegein. The training consists of two SQL and another two days of PL/SQL. During the first …
In a project where i am working on, we needed to show an image and the image should be change when a user would like to do that. For …
When I was in Chicago for the OPP2008 and APEXposed event I talked to someone who seems to have trouble understanding bulk operations in PL/SQL. I helped him out …
My challenge of the day: a query that returns aggregate values. And that can be manipulated dynamically to sometimes aggregate grouped by one dimension, sometimes along multiple or …
Op 3,4,10 en 11 december organiseert AMIS weer de 7Up training. In vier dagen worden de deelnemers wegwijs gemaakt in de nieuwe mogelijkheden die Oracle biedt. Veel mensen zijn …
We Dutchies are in luck. Mr. Thomas Kyte will be in Holland on the 3th of November presenting "11 Things about 11g" on the Logica premises during a …
Last night, the AMIS crew that visited the Oracle Open World conference reported their findings in a 3.5 hour session. In segments on SOA & BPM, Middleware, Database, Oracle …
Real Time SQL Monitoring is more or less old news because it was build-in in Oracle version 11.1.0.6.0. The documentation can be found in the Oracle® Database Performance Tuning …
“Exadata – Extreme Performance Warehousing“, that’s how the presentation on the last Friday morning from Oracle Open World started (Orig. Presentation Title was “Oracle’s New Database Accelerator: Query Processing …
Maybe the following question will arise after reading the title: Oracle Workflow isn’t that obsolete technology? The answer can be very short: Yes it is. (Read the SOD on …
Sunday 21 September 2008 at Oracle Open World, I had the opportunity to present my method “GAPP” once more (HOTSOS 2008 and Planboard may 2008). This time I also …
Larry yesterday did his keynote here at Oracle Open World introducing the “Oracle(R) Exadata Storage Server”. This morning I attended a session about the technical details behind the server. …
A few hours ago, Larry did his keynote here at Oracle Open World 2008. The big announcement that had loomed over the conference has been made. Oracle – in …
I just completed my second presentation here at Oracle Open World. It discusses Application Development inside and with the Database, introducing and discussing quite a few trends, concepts, best …
Let me be clear, I am not a RAC guy, but while using the schedule builder this year, one presentation had a definite hint to the upcoming 11gR2 release. …
Recently I was working on an RSS feed aggregator – a SQL Merge statement that through the use of httpuritype and XMLTable scans multiple RSS feeds and merges the …
![Oracle SQL and PL/SQL: juggling with user defined types (ADT) and XMLType – for creating an ADT based XML Service API]({"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"} "Oracle SQL and PL/SQL: juggling with user defined types (ADT) and XMLType – for creating an ADT based XML Service API")