and now we present… 11g and Apex on Ubuntu
![and now we present… 11g and Apex on Ubuntu]({"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"} "and now we present… 11g and Apex on Ubuntu")
Thanks to a completed messed-up Windows (I managed to demolish my network connections beyond repair) and a helpful tutorial from Dizwell’s blog (thank you oh so very much!) I …
Category: Development Tools
KC "Kennismaken met Application Express" – Presentation available for download
On Thursday the 22nd of November 2007 Patrick Sinke and I did a presentation and a small workshop about Oracle Application Express. We gave an introduction of this Oracle …
Importing Access applications into Apex
Some time ago I’ve been experimenting with the Apex 3.0 feature that migrates entire Access applications to Application Express. It took me a lot of time because I found …
First impressions of the European Application Express Training
This week Patrick Sinke and I attended the first edition of the European Application Express Training (EAET). With only a few months of experience with Oracle Application Express (APEX) …
How to execute a search by pressing the ENTER key in UIX
July 27, 2007
Development Tools, IT, Java, Oracle Application Development Framework, Web/Java
2 Comments
Many end users are used to pressing enter after inserting one or more search terms in an HTML form. Many, if not most, online search engines support this. Unfortunately, …
Four Dutch Experts in ODTUG Kaleidoscope Expert Panel Session
June 19, 2007
AMIS, Databases, Development Tools, IT, Java, Oracle, Software Development, Tools, Web HTML5 CSS3
No Comments
From different posts on this blog it should be clear by now: the ODTUG Kaleidoscope conference has taken off. I am writing this post as I am attending the …
Are Index Scans always good……
During my work a lot of times I have heard the same rumour. Lots of people are stating that when a system is doing index scans the system is …
Java Platform Debugger Architecture (JPDA) with Tomcat, OC4J, Eclipse, IntelliJ IDEA and JDeveloper
With JPDA it is possible to propagate changes to compiled classes to the server immediately. This is very handy when youĆ¢ā¬ā¢re debugging your class files. With some older applications …
How to trace a java application through a connection pool using DBMS_MONITOR
April 4, 2007
Database, DBA Oracle, Development Tools, Java, Oracle, Oracle WebLogic Server, PL/SQL, Web/Java
3 Comments
Much has been written on how to trace database sessions through a java application in all sort of different techniques. Since Oracle 10g a new technique is added to …
How upgrading to Apex 3.0 spoiled my weekend!
Allright, that is an exaggeration. Hugely. But it cost me some headache before I realised what was my problem. I still had HTML DB 1.6 running and I thought …
Sizing Oracle EBS 12i
I wanted to find out how ‘big’ the new Oracle EBS 12i release really is. So, I downloaded the software from Edelivery and created a stage area. From the …
Changing background in Oracle EBS 11i
It would be nice to have your own company logo as background in the Oracle E-business suite. Default the background is white, but the following steps will put your …
XML-Publisher 5.6.2, datasource and users
XML-Publisher
Quality Check for Domains in Oracle Designer – fighting problematic AVCON check constraints
One of the things that you never expect to go wrong will of course go wrong anyway, as I experienced today at one of my customers’ sites. We ran …
Using Object Libraries for advanced Oracle Designer Form Generation – adding popup menus to all updateable text items
For the past four weeks, AMIS has been host to the Oracle Discovery, a training program – some might say a boot camp – for nine junior Oracle developers, …
Using an Oracle database link to connect to Excel
August 4, 2006
Data Warehousing & BI, Database, Databases, Development Tools, Oracle, PL/SQL
5 Comments
Recently I had to extract data from 5 Access databases and 4 Excel files and merge the dataĀ intoĀ an Oracle table. OneĀ method was toĀ export the data fromĀ Access to Oracle via …
Oracle Warehouse Builder
Wauw! What a great presentation about Oracle Warehouse Builder tonight! At the end of the evening the presenter, Raymond de Vries, told me: ‘it was my first presentation for …
One Analytic Function can do more than a thousand lines of code…
My colleague Alex Nuijten did a very fine presentation on Oracle Analytical Functions during the recent ODTUG 2006 conference in Washington DC. His paper for this conference was nominated …
Automatic continuous compilation of webforms on linux/unix
July 19, 2006
AMIS, DBA Oracle, Development Tools, Oracle, Software Development, Software Engineering
6 Comments
Automatic continuous compilation of webforms on linux without X-terminal In the webforms world you it is not uncommon to compile a webforms application on a linux/unix application server, after …
Sleeping with the enemy: .Net at the 2006 ODTUG conference
From June 17th until June 21st I attended the ODTUG conference in Washington DC. I focused mainly on .Net and Apex. In Holland quite a few customers are moving …
Demo application advanced Forms features (ODTUG 2006 version)
Demo application advanced Forms features (ODTUG 2006 version) Last June, I held a presentation at the ODTUG conference in Washington DC Ć¢ā¬ÅOracle Forms: Productivity with new choicesĆ¢ā¬Ā. During this …
ODTUG 2006 Conference Handouts/Presentations available
June 30, 2006
Data Warehousing & BI, Database, Development Tools, IT, Java, Oracle, Oracle WebLogic Server, PL/SQL
No Comments
Last night, the ODTUG 2006 Conference Committee announced that all handouts and presentations from this year’s (well, in fact that is last week’s) conference are available for download from …
ODTUG 2006 – Overview – KC Oracle Development Tools
Donderdag 29 juni presenteerden Alex, Aino, Matthieu en Lucas over hun belevenissen tijdens ODTUG 2006. Hun verhalen liggen vast in een dozijn weblog-artikelen en worden verder ondersteund door de …
ADF Faces for MyFaces is now called Trinidad
June 12, 2006
Development Tools, IT, Java, Oracle, Oracle WebLogic Server, Software Development, Software Engineering, Tools, Web HTML5 CSS3, Web/Java
1 Comment
Earlier this year Oracle donated their JSF UI components from ADF Faces to the Apache Software Foundation. Since ADF is more than a set of UI components it was …
The Belgians beat us again…
A great example based on APEX was posted by Dimitri Gielis. See http://wc2006.shellprompt.net for the FIFA world Cup 2006 apex example. Chapeau Dimitri!
IN or EXIST or doesn’t it matter
In my previous post about package constants I mentioned the application I am working on right now. They gave me the task to speed up the application since performance …
Wrong use of constant packages
On my recent project we have a large package holding constants values. From a design point of view this is a very elegant solution because this way the constants …
Oracle and resilvering on AIX
Oracle and resilvering data on Mirrored Logical Volumes on AIX How to set up your storage with regards to Mirror Write Consistency Suppose you have or plan to implementĀ an …
Construct a "Save" URL syntax for the Oracle Reports Server
For a customer had to create an Oracle Forms functionality which would need to make several requests to the Oracle Report Server. The customer wanted me to generate a …
Oracle Forms: Productivity with new choices
Last Monday we had a KC meeting, where we discussed the latest features of Oracle Forms (OF). Basically these features break up into two categories: Oracle Forms Pl/Sql features …
Session on XML Publisher – The Successor to Oracle Reports?
April 2, 2006
Data Warehousing & BI, Development Tools, IT, Java, Oracle, Oracle E-Business Suite, PL/SQL
6 Comments
Last week, my colleague Marcos guided us through the still relatively new Oracle offering called XML Publisher. During a session of our Knowledge Center on Oracle Development Tools, we …
Improve your Web Forms deployment using the Java JDAPI library
Did you (or one of your customers) ever encounter ORA-00942 (table or view does not exist) while working in a (Web) form? No, then you can skip this post. …
KC Development Tools HTML DB evening report
Thursday the 1st of December the Knowledge Centre Development Tools held an evening about HTML DB. There was quite some interest in this topic regarding the amount of registrations …
Oracle 10gR2 – Conditional PL/SQL Compilation
For one of our sessions for the Knowledge Center Oracle Server Development I had to prepare a presentation and demonstration on new Oracle 10gR2 features in SQL and PL/SQL …
Reporting made easier using XML Publisher
Oracle announces in the November/December issue of Oracle magazine that it will release XML Publisher as a standalone version. This is very good news for all the users that …
Oracle JDeveloper 10.1.3 EA1 New Features
It is not yet a production release, but hey: who cares when you see what it contains in terms of new functionality. Apart from the UIX design time support …
On Software Engineering
On August 4 we had a session on software engineering. The aim of the session was to share knowledge and experience about the way we develop software and to …
PLDOC, documenting your PL/SQL directly from the database
Ever asked a PL/SQL code developer to create documentation for his code, the way Javadoc is able to create for Java code? It is possible using the open-source tool …
DB utilities – splitting generated DDL scripts
Have you ever tried to split the DDL scripts generated by Designer? Pretty tough, isn’t it? Well, I have a nice solution for you: the Perl script sql_split.pl splits …
Storing your Oracle Reports in the database
One can come up with several reasons to store your Oracle Reports output. Especially in cases where it needed to prove to authorities that the document you delivered was …