Webinar on Edition Based Redefinition
On February 13th I will be giving a webinar on Edition Based Redefinition hosted by Red Gate Software.I will be talking about how EBR can be used. It will …
Category: Database
Hotsos Revisited 2013
January 28, 2013
AMIS, Architecture, Big Data, Database, DBA Oracle, Oracle, PL/SQL, XML
No Comments
Van 3 tot en met 7 maart vindt in Irving, Texas, het internationale Oracle performance Hotsos Symposium plaats. Dit jaar belooft het symposium een garantstelling voor inhoudelijk hoogstaande presentaties …
OTN Yathra 2013 – The six city Oracle tour of India
The Oracle ACE directors and Java champions are organizing an evangelist event called ‘OTNYathra 2013’ between 15th & 27th February 2013. The event is sponsored by the Oracle Technology …
Basisregistraties Adressen en Gebouwen – Het importeren van Kadaster BAG data in een Oracle Database
Vorig jaar heb ik behoorlijk wat vragen gekregen over of er een tool was, een methodiek, om BAG data van het Nederlandse Kadaster in een Oracle database te krijgen …
ADF interaction with business service – an ongoing discussion
January 20, 2013
Databases, Java, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, SOA
No Comments
The ADF framework strongly suggests if not dictates a certain application architecture. Through ADF BC (Business Components) – the predominant business service implementation with ADF – applications will typically …
How-to backup Oracle RAC 11gR2 Database with RMAN
![How-to backup Oracle RAC 11gR2 Database with RMAN]({"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"} "How-to backup Oracle RAC 11gR2 Database with RMAN")
RAC and single instance RMAN backup is similar, but… Backup of a 11gR2 RAC database is similar to that of a single instance 11gR2 database. There is an important …
Advanced SQL to find valid periods – juggling with outer joins, running totals and analytical functions
After teaching the Advanced SQL Masterclass recently, one of the attendees confronted me with an interesting challenge for me to solve with all the tools I had been discussing …
AMIS vat Oracle OpenWorld samen in speciale whitepaper
Als sluitstuk van de jaarlijkse Oracle OpenWorld conferentie brengt AMIS een whitepaper uit. Een handzaam document waarin het volledige verhaal van Oracle OpenWorld 2012 is gebundeld. Een team van …
Book review: Oracle APEX Best Practices
Oracle APEX Best Practices explains how to build robust and secure APEX applications. The authors have a proven track record in the Oracle APEX world. The intended audience of …
The Very Very Latest in Database Development – slides from the Expertezed presentation
I have just completed my first ever presentation on the Expertezed.com network – http://www.expertezed.com/ , a reprise from my session on Oracle OpenWorld 2012. This presentation includes a number …
AMIS Masterclass Advanced SQL – scherp je SQL skills in een pittige en praktijkgerichte dag – maandag 10 december
November 21, 2012
APEX, Database, Databases, Java, Oracle, Oracle Application Development Framework, PL/SQL
No Comments
Of je nu ‘klassieke’ Oracle applicaties ontwikkelt, met APEX bezig bent, een SOA landschap inricht of een Java/JEE (bijvoorbeeld ADF) applicatie bouwt: het fundament van veel van wat je …
The APEX of Business Value… or: the Business Value of APEX? Cloud takes Oracle APEX to new heights!
The attraction of APEX has increased tremendously with the recent launch of the Oracle Cloud. APEX already supported departmental development and deployment of business applications with minimal involvement from …
OOW 2012: The yearly AMIS Review from Oracle Open World and JavaOne – slides available
Yesterday (16th October), 10 days of the end of the yearly Oracle show in San Francisco, AMIS organized its ‘Review from Oracle Open World 2012’ session with an overview …
OOW 2012: Little things make me happy
Yesterday evening we had the annual “We went to OOW and this is what’s new in the world we call Oracle” at AMIS. Starting around 5pm and ending around …
Configure FMW servers with Puppet
October 13, 2012
Architecture, Continuous Delivery, DBA Oracle, Development Tools, Java, Oracle WebLogic Server, SOA, Tools
No Comments
When you have many development servers or cloud servers which runs Oracle software and then you know that configuration management of those servers is very important and must be …
OOW 12: The Oracle Cloud strategy – explosive stuff or vaporware?
Oracle Open World 2012 was the cloud conference. There can be no doubt about the central theme of the conference. In week that had clear skies throughout, Oracle kept …
Kom kennismaken met AMIS en doe mee met uitdagende projecten
Hierbij nodigen we je uit om met ons kennis te komen maken. Ben jij een (junior) Oracle consultant die een stap verder wil maken? Wil je verder groeien en …
OOW 2012 – The Big Stories
The show is over, the visitors are on their way home. The process of digesting the announcements, roadmaps and rumors – confirmed or not – can proceed in full …
OOW 2012: The Very Very Latest in Database Development (CON4792)
Database development in the Oracle Database is crucial for creating well balanced multi tier applications. This presentation describes a number of useful facilities and application architecture considerations around the …
Re-ordering without procedural code or using a sequence
Question from one of my customers: “Please help me find an update statement that’s able to re-order a primary key after a delete.. and by the way.. you are …
OOW 2012: Is PL/SQL still alive?
Yesterday Bryn Llewellyn, Distinguished Product Manager, did a session called “PL/SQL Enhancements brought by the latest generation of database technology”. The room was packed. For the upcoming release of …
OOW 2012 – And was there news on the XMLDB front…?
Just finished my Birds of a Feather XMLDB panel session in the Marriott Hotel and now looking back on a event full day. It all started of with a …
How to build an IM (XMPP) solution with Oracle APEX and Websockets
October 1, 2012
Architecture, Database, Development Tools, Oracle, PL/SQL, Web/Java, WebCenter
No Comments
Using Kaazing Websocket Gateway and OpenFire Scenario: If you, for example, have a webshop and a webshop online support application for internal use, this solution will let the webshop customer …
OOW 2012 – Larry Ellison’s Keynote Announcements: Exa, Cloud, Database
Last night, Oracle Open World 2012 kicked off with the keynote session by Larry Ellison. In just under one hour, and with a novelty for Larry watchers (no more …
JavaOne 2012: Thinking Through Java Enterprise Performance (BOF 4712)
Performance of Enterprise Java Applications is a requirement and usually a challenge. Business requirements on systems can be stiff, successful systems can easily be overloaded and complex application architectures …
OOW 2012 – It will be a great Conference…
For me it all started out very stressful. I overslept yesterday, or the day before, and noticed that it already was 08.25 AM. My flight would leave at 09.50, …
OOW 2012: Questions to get answered during this conference
The show of the year is around the corner: on Sunday it will all start again, the Oracle Open World conference. Tens of thousands of developers, architects, administrators, project …
OOW 2012: My Schedule
This will be my third time attending Oracle Open World and I’m really looking forward to the event. It is very hard to make a schedule, there are so …
Uitnodiging: Kom kennismaken met AMIS
September 13, 2012
AMIS, Architecture, Business Process Management (BPM), Cloud, Data Warehousing & BI, Database, DBA Oracle, Development Tools, IT, Java, Mobile, Oracle, Oracle Application Development Framework, Oracle WebLogic Server, PL/SQL, Project Management, Software Development, Software Engineering, Web HTML5 CSS3, Web/Java
No Comments
Hierbij nodigen we je uit om met ons kennis te komen maken. Ben jij een (junior) Oracle consultant die een stap verder wil maken? Wil je verder groeien en …
Oracle RDBMS 10GR1: solution to avoid character encoding in XML with UPDATEXML
September 12, 2012
AMIS, Database, Databases, Java, Oracle WebLogic Server, Software Development, Software Engineering, Web HTML5 CSS3, Web/Java, XML
No Comments
On a recent project, I ran into a problem with an XML document, that had to be enclosed within another XML document, generated from a database query. The problem …
Dinsdag 18 september: Oracle Open World & JavaOne 2012 Preview mini-conferenties – 12 presentaties op 1 avond
Van 30 september tot 5 oktober is San Francisco weer het domein van tegen de 45.000 deelnemers aan de Oracle Open World en JavaOne conferenties. Ruim 2000 presentaties worden …
Quick introduction of what and why of Oracle Database Edition Based Redefinition
Availability is a highly desirable aspect of Fusion Middleware application. Planned downtime therefore sounds quite silly. However, the introduction of changes to applications has typically been associated with the …
Reduce occurrence of ORA-04068 while upgrading PL/SQL packages by moving global variables to Application Context
This article will argue against the use of (stateful) global PL/SQL variables – as they are both a potential problem for stateless web applications and the availability experienced by …
Compare tables with the minus operator, even if they contain clobs and/or blobs.
I wanted to compare the content of two tables with identical layout quickly with the minus set operator, but ran into a couple of errors, caused by clob and …
Oracle Enterprise Manager Cloud Control 12.1.0.1 – Agent Installation, Issues and Solutions
Currently busy for a client to install and configure Oracle Enterprise Manager 12c for database and more administration across the globe. These environments were configured and setup by a …
Select a blob across a database link, without getting ORA-22992
Just a quick blog about a simple trick to select a blob across a database link, especially for a collegue of mine, Harry Dragstra. Say, you have a table …
Notifying ADF applications of database changes – fast and lean using Active Data Service for Server to Client Push – Part Two
Yesterday I wrote that in two articles, I would demonstrate how we can ensure that changes in the database – new, changed or deleted data – can rapidly be …
Notifying ADF applications of database changes – fast and lean using Database Query Result Change Notification – Part One
In two articles, I will demonstrate how we can ensure that changes in the database – new, changed or deleted data – can rapidly be reflected in ADF based …
AMIS proud sponsor of the SQL Challenge
SQL today is the foundation for any successful application. Whether it is a SOA implementation, an ADF or APEX application, a Forms application or any other usage of the …
Advert: Dutch preview event ‘Collaborate 12’
March 31, 2012
AMIS, Announce / Events, Database, IT, Oracle, Oracle E-Business Suite, PL/SQL
1 Comment
‘COLLABORATE 12: Technology and Applications Forum for the Oracle Community’ is de grootste Oracle gebruikersgroep conferentie ter wereld en wordt jaarlijks georganiseerd in de Verenigde Staten. Het is hét …