Oracle Development Tools
Knowledge Center Oracle Development Tools
Book review: Oracle APEX Best Practices
0Oracle APEX Best Practices explains how to build robust and secure APEX applications. The authors have a proven track record in the Oracle APEX world.
- Iloon Ellen Wolff working in Oracle Support and is closely involved with the Oracle Database Cloud Service . A few years ago, I attended an Oracle Seminar presented by Iloon. The title was Application Express : Best Practices (rings a bell?).
- Alex Nuijten, a collegue, is well known about his presentations about database features like analytic functions (features as in functionality, not the Oracle definition: unexpected behavior not classified as a bug ).
- Learco Brizzi which was one of the builders of the Dance-Tunes application, one of the first web shops build in HTMLDB, the old name of APEX. A nice example which convinced me that you can use APEX to build enterprise applications in APEX and make money with it.
Build and release OSB projects with Maven
0With Maven we are able to build & deploy OSB projects. The artifacts generated by Maven called snaphosts and releases can be automatically uploaded to a software repository. These versioned OSB jars can then be downloaded by the OSB Servers and deployed ( this can be a Test, Acceptance or a Production OSB Server).
In this blogpost I will guide you through this OSB build and release process, so you can do the same with or without Hudson or Jenkens
For this blogpost I will use this maven test project on github, this also contains a working OSB Eclipse Workspace which you can use for your own testing.
First step is to create a Maven POM file and put this on the Eclipse Workspace or Project level. The Workspace pom should build the whole workspace and the pom in a project only that particular OSB project.
The pom always start with the groupId & artifactId and a version. A normal Maven build will always have an number with snapshot as version, a release will build the OSB project without snapshot and automatically will update the version to a higher number and commits the updated pom.xml with the new higher snapshot version.
For releases we need to provide a version repository and in More >
ADF Mobile : Your First Navigation and Device Interaction
0Now ADF Mobile is generally availble, it is now time to create your first ADF Mobile application. In this post I will show you how to create a simple application that contains of two pages with navigation. A bonus for this post is that you will see how to get a picture from the filesystem (or by using the device camera) from within your ADF mobile application (more…)
Configure FMW servers with Puppet
0When 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 repeatable. When you configure and install all that software by hand, then you also know that the chance is high that those servers are not exactly the same. This can lead to many configuration issues, tons of documentation pages and days for a new environment is released.
With Puppet of puppetlabs you can automate installations and configuration of all these servers and check the status or read the configuration of the servers. Puppet is open source and it works perfectly with VMware or cloud providers like amazon. There is also Puppet Enterprise which is free up to 10 nodes.
If you want to learn Puppet you can follow this guide and download the puppet test VirtualBox or VMware image.
On github I made a puppet wls module which can retrieve all the Oracle WebLogic software, domains + weblogic artifacts, running nodemanager + weblogic servers data and displays these values as facts in the Puppet Dashboard.
Second part of the puppet module are scripts to automatically install the following
More >
Kom kennismaken met AMIS en doe mee met uitdagende projecten
0Ben jij een (junior) Oracle consultant die een stap verder wil maken? Wil je verder groeien en ontwikkelen tot principal consultant? AMIS geeft je de kans om die stap te zetten. Bij ons krijg je de ruimte om te experimenteren én te leren samen met de experts op je vakgebied.
Laat ons in een vrijblijvend gesprek vertellen welke mogelijkheden we je kunnen bieden. Neem voor een afspraak met een van onze consultants contact op met Eva.van.der.kleij@amis.nl of bel haar op 030-6016000. Je bent van harte welkom.
AMIS merkt dat haar concept van hoogwaardige en kennisintensieve dienstverlening erg succesvol is. Onze toekomst ziet er erg aantrekkelijk uit met interessante opdrachten bij toonaangevende klanten. Vandaar dat we op zoek zijn naar uitbreiding van ons team.
Denk niet direct dat je hiervoor te weinig kennis of ervaring hebt: jouw toekomstige ervaren collega’s doen niets liever dan jou verder helpen. Ons trainingsprogramma voorziet in een grote diversiteit aan opleidingen en tijdens onze interne kennissessies kun je op veel terreinen iets van je collega’s opsteken. Concreet hebben we de volgende vacatures:
Re-ordering without procedural code or using a sequence
5Question 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 not allowed to use PL/SQL, triggers or a sequence, because we cannot change anything in the app schema”. Updating a PK seemed a bit odd, but then I was told about a composite PK over 2 columns, with the second column a number, meant to always start with 0 and ascending per value in the first column, and – most importantly! – without any holes in de numbering.
At first I couldn’t see a way to use pure SQL for this request, and thought of PL/SQL loops and using a temporary table. But after some time I came up with a solution, using row_number() and rowid. I think it’s a nice example of being pressed to think in sets instead of row based processing, with the solution being short, fast, and rather elegant. Try it yourself!
– create test table
create table t1( name varchar2(100), seqnr number(4), note varchar2(30));
alter table t1 add ( constraint t_pk primary key ( name, seqnr));
– insert test data
insert into t1 values ('harry', 0, 'test record 100');
insert into t1 values ('harry', 1, 'test record 101');
insert into t1 values More >
Recent Comments