Category: Oracle
One characteristic of professional applications is their manageability. How easy is it for run-time Database and Application Server Administrators to work with the application, especially when there are issues …
For one of my current ADF projects, the customer has asked for a Rich Text Editor – to allow the end user to easily edit Email-messages that are sent …
Oracle BPEL has a special Activity called “Java Embedding”, that allows you to include some “inline” Java code into a BPEL process. Unfortunately, you don’t get Java type-in support …
Row generation is a very useful technique for many (semi-)advanced SQL Queries. We have discussed various methods for row-generation in previous articles on our weblog. Examples are the CUBE …
With the new 11g feature Virtual Columns, we can (almost) declaratively implement dynamic constraints, such as: salaries can not be increased by more than 10% employee records can only …
I stood up at 07 o'clock and after a great meal in a restaurant, I attended my first session: Tapio Lahdenmäki's presentation about "Rethink your Indexes". A lot of …
Oracle 11g introduces Virtual Columns. “What do we need Virtual Columns for, aren’t real ones more useful?” you might wonder. And what are they to begin with? A virtual …
Thursday morning, somewhere between 11.00 and 11.03 hours, the Miracle Express left from Anjo Kolk's home. From the almost 40 Dutch participants of Miracle (Oracle) Open World event, 12 …
Oracle 9i started introducing Flashback technology into the Oracle RDBMS. Flashback unlocks the UNDO data already available in the Oracle database for read-consistency, for other applications. Using Flashback queries …
Pivoting is all the rage. Turning rows into columns. You can do it in Excel, in all BI/OLAP tools and we could do it in Oracle using clever tricks …
I was verifying a custom application installation in E-Business Suite for a customer lately. While looking for the documentation the installation was done with, I came across Metalink Note …
The PIVOT operation is one frequently discussed when talking about more advanced SQL Queries. Pivoting is the process of switching rows and columns, and is for example an advanced …
One of the interesting new pieces of functionality in Oracle 11g is offered by the DBMS_COMPARISON package. This package allows us to compare two tables – or two views …
It’s the day before Miracle Oracle Open World 2007. Tomorrow the (Dutch) Miracle Express will leave and will make its way from Garderen to Lalandia, Denmark. Hopefully arriving with …
This pattern was ‘invented’ by our SOA-architects team integrating the Oracle SOA Suite and the Oracle e-Business Suite in an existing IT-landscape. The trickle-feed integration pattern can be used …
One of our ADF projects has a customer determined to develop an application with a modern, appealing user interface. To that end, they hired a User Interaction Designer, who …
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 …
The live demo presented by Carl Backstrom as presented to the attendees of the Apex European Training Days is now publicly available! You can review at Carl’s blog , …
GlassFish is the first open source application server to have implemented the JEE specification. Basically it is the open source version of Sun Java System Application server. Last night …
JDeveloper 11g will gives us wonderful charts. Colorful, powerful, exhilerating etc. But since it is not yet production, I might just write this little story about yet another way …
Oracle partners with IDS Scheer, a market leader in business analysis software, to further expand its offering with respect to Service Oriented Architectures. As a result of this co-operation, …
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) …
It is nagging… I got an email from that you are able to download the handouts from ODTUG until half September (download them now, 1/2 September they will be …
I just came across this website "I love PL/SQL, and…", one of Steven Feuerstein’s website. If you ever attended a seminar given by Steven, you already know that he …
This (for this site) is a strange post… I am looking for a consultancy job. Nothing new here, but only a strange way to make this visible to the …
Some time ago I wrote an article on SOA Suite Build, Deployment and Test Automation. A section of the article was devoted to automating builds and deployments for Oracle …
The other day one of my colleagues asked me if it is possible to create a copy of a table with all the content in it. He wanted to …
Oracle SOA Suite comes with a collection of adapters that allow you to easily tap into a number of technologies from BPEL Processes or from ESB Services. Want …
This is definitly a post worthy as one of the members of the BAAG. The work was extensive (setup, config, install, checking) and afterwards the outcome could have been …
Introduction Is it possible to package java classes which are invoked through WSIF along with the BPEL Suitcase generated by bpelc? I’ve noticed that when generating and deploying the …
If you are a regular user of the FORALL statement, you are probably also familiar with this message: PLS-00436: implementation restriction: cannot reference fields of BULK In-BIND table …
In Oracle 11g database it is possible to make a table really read only, also for the owner of that table. Until now a table could only be made …
A new feature in the Oracle 11g database is the ‘Function Result Cache’. When you create a function with the new clause ‘RESULT_CACHE’ the result of the function is …
The order in which triggers of the same type fire is arbitrary. But in Oracle 11g the create trigger statement has a FOLLOWS clause. With the FOLLOWS clause you …
In a recent project I was working on JSF page that needed to display the result of a calculation performed on values taken from various bean properties. The beans …
Oracle SQL Developer offers the ability to create reports with graphs in it. A number of reports are included with the tool, unfortunately a report which shows information based …
Dit artikel is de on-line tegenhanger van de rubriek Puzzelen met SQL die verschijnt in de Optimize, het vakblad voor Oracle ontwikkelaars in Nederland. In dit on-line artikel kunnen …
What is the most common way of testing PL/SQL code? I think it is using DBMS_OUTPUT and manually verifying the results. Is it the best way of testing code? …
In a recent article – ADF Faces File Uploading – It is really that simple! – I described how to set up file uploading with ADF Faces. Using the …
One particularly type of interaction in web applications is typically a little bit tricky. Requiring additional analysis of the frameworks used. For me personally it was even the way …
![Oracle 11g – Virtual Columns – to publish derived column values without storing them. And more…]({"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 11g – Virtual Columns – to publish derived column values without storing them. And more…")