Posts tagged Oracle
Getting started with your career (in Dutch)
Als bezoeker van deze blog ben je bezig met het maken van mooie oplossingen en nieuwe uitdagingen op technisch gebied. AMIS nodigt je uit om ons team te komen versterken. AMIS wil je op het gebied van Oracle en Java uitdagen de volgende stap in je carriëre nemen.
AMIS merkt al enige maanden dat de markt voor Oracle en Java opdrachten aan het aantrekken is en maakt dat concreet met het uitvoeren van innovatieve opdrachten.
Om je een beeld te geven van het werk bij AMIS volgt hieronder een lijst met de trajecten waar we de afgelopen maanden aan gewerkt hebben.
- OSB / SOA Suite implementatie bij een grote informatieverwerkende organisatie.
- Realisatie in ADF 11g van een backend applicatie voor een internetwinkel.
- Realisatie van een SAAS oplossing op basis van Hibernate, Seam en RichFaces.
- Realisatie van een medisch registratiesysteem in ADF.
- Advies op het gebied van het gebruik van ADF 11g in combinatie met JHeadstart voor een energiebedrijf.
- Realisatie van een SOA / BPEL implementatie voor een pensioenfonds.
- Realisatie van een administratiesysteem voor een verzekeraar buiten Nederland (EU) in ADF 11g en JHeadstart.
- Oracle XML DB implementatie voor een grote bank.
- Realisatie van een More >
How to use an outerjoin to synchronise data
0There 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 statement, but this is not always possible. Mind, for example, the need to update more than one table, or updating the data using an api. As an example we want to grant and revoke privileges on database objects. Tables needing select, insert, update and delete privileges, packages execute and views select privileges. The table and packages also get the grant option for the select and execute privilege. (more…)
My First Steps with RAC One Node 11gR2 (11.2.0.2)
6I’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 we had ‘laying’ around to install a RAC One Node Cluster. I also used that cluster to get some hands on experience with ASM but that is not the topic for this post, so I will not go into that further.
I assume that installing the software is a breeze for everyone who has some experience with RAC and who has read the manual so I will not go into that as well. Once you have fulfilled the prerequisites it’s a matter of next, next, finish. (more…)
Android puts Oracle on the (Google) map.
0For 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 Oracle database. For this purpose I developed an Android app that stores speed traps that users may hit while driving, into an Oracle database. The app also retrieves these speed traps from the database and draws them onto a Google map:
Fig. 1 After pressing the Android device’s menu button, two menu options ‘Retrieve’ and ‘Report’ (speed traps) appear.
Fig. 2 After pressing the ‘Retrieve’ option all speed traps already stored in the database appear as markers on the map.
Oracle 11g SOA Suite – Service-enable a Query Using the Database Adapter’s Execute Pure SQL Option
2The Database Adapter is a powerful tool to expose data and PL/SQL code in your service applications. If you want to quickly service-enable a custom-made query, you definitely may want to explore the “Execute Pure SQL†option of the Database Adapter.
This tutorial will show how to service-enable a query step by step using the Database Adapter with Pure SQL.
Business Case: Retrieving Department InformationAssume you have written a query that retrieves information for departments in your database and you want to service-enable this query. The query optionally accepts two arguments: a department ID and a department name. Selection on a part of the department name is possible and selection is case-insensitive. If the arguments are both empty, all departments will be returned by the query.
The query we are talking about here does not only contain columns that are mapped 1-on-1 on database columns but also a concatenation expression and calculated columns using analytical functions. Therefore the “Execute Pure SQL†option of the Database Adapter is a logical choice to expose this custom-made query.
JavaOne 2010 – Keynote by Thomas Kurian – Java Strategy and Directions
0JavaOne started this morning with the first many dozens sessions and the Java Pavilion & Exhibition hall. The official kick off so to speak took place tonight, with Thomas Kurian’s keynote, in which he unfolded Oracle’s plans for Java. He wants to make it abundantly clear how important Java is to Oracle, how important the unity of the community around Java is and how urgent it is for him (almost on a personal level) to see the Java platform and community regain momentum, after a period of FUD and near stand-still. His keynote contained a number of very concrete statements and plans that Oracle intends to execute. He did not necessarily say this out loud – but between the lines I clearly read that Sun had fantastic ideas but not necessarily the capacity (and at some point obviously the budget) to deliver on them and that Oracle intends to bring its ability to execute and deliver (see for example the acquisition and subsequent integration of BEA and others) to the table and get Java moving once more.
His announcements included:
- Java SE 7 will be available in the Summer of 2011 -provided JCP joins in and approves.
- Java SE 8 will follow in 12-18 months after SE 7 – provided JCP….
- the More >
Recent Comments