Oracle Label Security, the easy way to secure your data
Besides VPD (as described in my previous posts) and views with functions you can also secure your data using Oracle Label Security (OLS). OLS, in contrast to the other …
Category: IT
AMIS Query – donderdag 29 september 2005 – Java Server Faces en ADF Faces, van vergezicht tot standaard View technologie
(this event on JSF and ADF Faces will take place in Nieuwegein, The Netherlands and will be Dutch-spoken. Hence this announcement in Dutch) AMIS Query: Java Server Faces, van …
Standard for Database Development – Getting rid of USER from PL/SQL and SQL – no longer is USER equivalent to End User
Many applications built in the Client/Server era made use of the fact that every end user had his or her own Database User Account and every Database Connection and …
VPD part 2; The added functionality in 10g
In my prior post about VPD I stated that VPD is not a new functionality Oracle added to 10g Enterprise Edition. In fact it was already available in the …
Introducing Spring Framework – Overview presentation and demonstration for Oracle Consulting
Last week, I had the opportunity to present on the Spring Framework for the Oracle Consulting Java Professional Community at Oracle The Netherlands. Having worked at Oracle for over …
Virtual Private Database, securing your data
I was not that aware of the fact that there were other (better) ways to secure data without using functions in views until I was involved in a project …
SQL Question: Find overlap in periods – using Analytical Functions (LAG and LEAD)
Today one of my colleagues asked me “What again was your query for finding overlaps in a table with periods, demarcated by start_date and end_date. I think he was …
Spring and Oracle ADF – registering a POJO Spring JDBC based Business Service as Data Control
In several previous posts, I have wondered about the potential for combining the ADF Binding Framework and the IDE capabilities around ADF in Oracle 10g JDeveloper with the Spring …
Firefox Search Plugin for Amis Technology Blog
Following the Search Plugins for askTom and Oracle Docs, I created a search plugin for the Amis Technology Blog. Installation: Simply unzip the Amis Search Plugin in the Searchplugin …
Repository Object Browser – Invoking the full property palette for any secondary element
The Repository Reports in the Oracle Designer web-interface Repository Object Browser provide an overview of the most useful properties of the most important components of the elements in the …
Role of the Database in a J2EE Architecture – Dumb Data Store? Only Data Tier? Also Business Tier?
The other day, we had a very interesting debate about the role of the database in (our) Java/J2EE projects and architectures. Should you limit the use of the database …
Introducing Spring JDBC – frequently the best introduction of Spring in an organization
Spring consists of a number of modules, such as the IoC Container, AOP, MVC, Persistence, DAO and Remoting. These modules are relatively losely coupled: some can be used without …
On Line Documentation for Oracle 10gAS 10.1.2 – including ADF Documentation
For the on-line documentation for release 10.1.2 of the Oracle Application Server, see http://download-uk.oracle.com/docs/cd/B14099_10/web.htm. It contains besides others links to documentation on the ADF (Application Development Framework), such as …
Integration between Repository Object Browser and Headstart Utilities Quality Reports
The Repository Object Browser is a valuable web-based interface to the Oracle Designer and SCM Repository, as I discussed in a recent post: Installing the Oracle Designer Web Interface …
Installing the Oracle Designer Web Interface – Repository Object Browser (dig up that little nugget)
One frequently overlooked component of Oracle Designer is its Web Interface: the Repository Object Browser. Added in 2003 to Designer 6i and 9i as well as in 2004 to …
Some small improvements for CDM RuleFrame (including code)
After a year full of stuff like Spring, UIX and ADF, JHeadstart, Struts and JSF, XSL-T and the likes, PL/SQL and SQL, I had a bout of nostalgia this …
Enhancing Web Applications with AJAX, XMLHttpRequest, UIX – Report from An AMIS Ten Minute TechTalk
I was kindly requested recently to do a brief – and it was stressed several times that it really had to be brief, not something I am particularly well-known …
Create JavaScript Debug Console using DIV and innerHTML
Interesting thread on Experts Exchange, on how to develop a standard facility to do debugging inside web-pages: JavaScript: How to print log messages to Firefox JavaScript console in my …
Oracle Lite Part 1, how to get started
This post is the first one of a set that I will write about Oracle Lite. I have been working with Oracle Lite and I am impressed. Not by …
O'Reilly European Open Source Convention – 17-20 October 2005, Amsterdam
The 2005 O’Reilly European Open Source Convention brings together diverse projects and communities from across the continent and around the world to address the changes and challenges unique to …
Hierarchical query with nodes from different tables – DEPT and EMP nodes in one tree
Hierarchical queries using CONNECT BY logic are discussed quite frequently. Often in terms of EMP, the famous demo table that has a self referencing foreign key – MGR to …
AMIS en het "remote werken" in de Automatisering Gids
De Autmatisering Gids besteedt deze week aandacht aan de pilot rondom remote werken die sinds eind mei – het AMIS weekend – binnen AMIS loopt. Alle medewerkers hebben een …
AMIS WebLog crosses the 500,000 marker – half a million post-reads in just over a year
Yesterday we – that is: this AMIS Technology Weblog – had our 500,000th post-read. Over half a million times, someone has read one of our articles! The AMIS Technology …
Getting Hibernate3 to work in JDeveloper 10.1.3
Our company focuses mainly on Oracle related products. Our Java developers use JDeveloper in combination with JHeadstart to build web applications. But that doesn’t mean we’re not interested and …
Bill of Materials and Hierarchical Queries – Which Component contains a component that…
My two previous posts discussed presenting data in a tree-like fashion and filtering hierarchical data sets on certain query conditions while still returning a tree-like result set. This post …
Selecting a 'pruned tree' with selected nodes and all their ancestors – Hierarchical SQL Queries and Bottom-Up Trees
Hierarchical queries return data in a tree like structure. The query is performed by walking the tree that is made up of parents and children, each non-root-node linked to …
Great Oracle Forms 'plugin' – multirecord table column resize/sort/move around
Developed by Francois Degrelle, this is a great enhancement for any Oracle Forms 9i or 10g application: a simple to install plugin that allows users to resize columns in …
Use Data Tree in List of Values Window – ADF BC and UIX and JHeadstart
Recently I have had several occasions where I had to implement a List of Values, allowing the users to select a value from a large set of reference values. …
Oracle Rules… the world?? Design and Run-time Rules Engine – also for PL/SQL?
I was triggered by the news item on OC4J on OTN’s homepage, ” Download Oracle Application Server 10g (10.1.3) Developer Preview 4 – including … Oracle Rules” to resume …
Oracle Warehouse Builder suddenly stops working?
![Oracle Warehouse Builder suddenly stops working?]({"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 Warehouse Builder suddenly stops working?")
Did you recently try to start your OWB client and found that it suddenly did not want to start? Well you’re not the only one. All OWB users around …
NL-JUG Fall Conference – Call for Papers
NL-JUG J-Fall 2005 Call For Papers Deadline: august 31, 2005 On October 12th 2005 the J-Fall, the fall-conference of the NL-JUG will be organized. The theme of this conference …
Oracle Warehouse Builder – 10gR2 Paris release – Even if you do not build warehouses…
AMIS is participating in the Oracle Warehouse Builder Paris Release Beta program. Unfortunately I have not had too much time for in depth involvement myself. However, from what I …
New shipment of books – the Summer 2005 shipment is in
It is getting harder and harder to keep track of all the books coming into and going out of our library. The shelves never get full as all new …
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 …
New HTML Form element: Radio Select – Combining Radio Button and Select items
It has always been a bit of a tricky discussion, when to use a group of Radio Buttons and when to use a Select (List) in an HTML Form. …
Feuerstein is coming to Amsterdam
On september 8, 2005 Quest Software will organize a training seminar in Amsterdam by Steven Feuerstein. It will cover two topics: 1. Correcting PL/SQL Worst Practices and 2. Survey …
Using Oracle Enterprise Search (Text Searches)
Last week I attended a Theme meeting of the Dutch Oracle Usergroup (OGH). The topic was called “Zoek en Gij zult Vinden” (“Search and you will find”) by Wouter …
Oracle text
The Dutch Oracle Usergroup (OgH) organized a session about (text) searching capabilities of Oracle technology. The presentation was done by Wouter van de Weghe of Oracle and consisted of …
SVG Viewer for Firefox
The Adobe SVG Viewer is a viewer for Scalable Vector Graphics like charts and graphics and, as I found out, is used by Oracle in web-applications. It’s downloadable at …
Migrating Oracle Reports – JDAPI style
Presenting at ODTUG can lead to unexpected things to happen. For instance people actually reading my paper and seeking advice with their migration issues. Whaw! In my paper – …