Oracle Designer – Keyword Expansion upon Check Out
A little while ago I wrote the article Oracle Designer Check In – synchronize P_VERSION argument on this weblog. In it, I discuss the desirability of having Oracle Designer …
Category: Oracle
Oracle Designer Report – SQL Script for Roles vs. Modules
![Oracle Designer Report – SQL Script for Roles vs. Modules]({"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 Designer Report – SQL Script for Roles vs. Modules")
On my current project, we had a request from the customer to produce an overview of all the (Database) Roles in the Application with a list of Modules, Screens …
Oracle to offer free database
Released on 25th October 2005, Oracle Database 10g Express Edition (Oracle Database XE) is an entry-level, small-footprint database based on the Oracle Database 10g Release 2 code base that’s …
Apache MyFaces 1.1.1 released
The apache foundation has just released version 1.1.1 of MyFaces, a free open source implementation of JavaServer Faces . This release is a minor patch release that fixes a …
Oracle Lite and Java
Oracle lite is a very interesting product. As the name indicates, is it a lite version of the Oracle database and thus capable of running on a PDA, laptop …
Oracle Designer Check In – synchronize P_VERSION argument
As you can probably tell from the topics and nature of my blog-postings recently, I am very deepy involved in a project using classical Oracle development technology such as …
Functional Partitioning
We all know partitioning for performance issues or for storing historical data. But partitioning can also be used for functional purposes such as creating a savepoint in batchrun. Such …
SQL+ connect identifier
Sergio describes on his blog how you can connect with sql+ to to a database without the need of the tnsnames.ora file. This is great, but only available since …
Introducing new Oracle10g R2 features for Application Development (article in Dutch)
For the Fall 2005 issue of OGh Visie, the magazine of the Dutch Oracle User Group, I have written an article introducing the most enticing new features for Application …
OpenOffice.org 2.0 released
“OpenOffice.org 2.0 Is Here” it says on the OpenOffice.org website. Over the past weeks I have been using OpenOffice.org Beta and RCs and I am really impressed by this …
10gR2 New Feature: Asynchronous Commit
Again a very good post on a 10gR2 feature by Natalka Roshak. This time she writes about the Asynchronous Commit in 10gR2. See: 10gR2 New Feature: Asynchronous Commit Asynchronous …
VPD Policy Tester
My VPD policies were causing troubles when I was running the Forms: ORA-28113 Policy Predicate Has Error . I could not easily figure out which Policy it was, as …
Use of TODO tags to quickly generate a tasklist for PL/SQL development
There are quite a few neat tricks we can steal from other technology stacks and communities for use with PL/SQL development. I have recently written an article on AOP …
Steve Adams is in town – Oracle with a calculator
Today I attended the workshop that Steve Adams is giving in the Netherlands this week. We were with a group of four AMIS employees. The day started in a …
Upgrading to JHeadstart 10.1.2.1
Recently I started on a project that was partly built with JHeadstart 10.1.2 on JDeveloper 10.1.2 (build 1811). Since JHeadstart 10.1.2.1 contains so many new features and JDeveloper 10.1.2 …
Dashboard for Oracle Designer – free extension to Repository Object Browser
It can be both quite useful and rather difficult to monitor the events taking place in Oracle Designer and/or Oracle SCM (Software Configuration Manager). Keeping track of all Check …
Learn Once, Work Anywhere (with Choice) an impression of J-Fall 2005
On October 12th I have visited J-Fall 2005 conference of Java Usergroup Netherlands (www.nljug.org). There have been held many presentations, attended by a large public and it has been …
JFall 2005
On oktober 12, 2005, a few of my colleagues and me attended JFall, the second Java conference this year organised by NL-JUG, the Netherlands Java User’s Group. Like JSpring, …
PL/SQL Source Code Control inside the database – After Compile trigger for automatic archiving
Source code control for PL/SQL is often discussed in the organizations that I encounter. The database itself will always hold the latest version of the PL/SQL objects we are …
PL/SQL post compiler to fix TAPI – dealing with the 'TAPI cannot deal with MERGE' problem
Recently I wrote a post about the failure of the TAPI (table API) generated by Oracle Designer to work together with Merge operations: Designer TAPI triggers fail on SQL …
Assasination attempt on MySQL? – Oracle Announces the Acquisition of Open Source Software Company, Innobase
Interesting news on Friday: the Oracle acquisition – the eleventh this year – of Innobase. Innobase? You may very well have never heard of it. Unless you are a …
Designer TAPI triggers fail on SQL MERGE operations
It turns out that the combination of the Table API (TAPI) as generated by Oracle Designer and MERGE operations using the Oracle 9i SQL Merge statement are not compatible. …
Tuple Rules! Using NVL2 and NULLIF.
While working on a current project I ran into the requirement that a column was mandatory, depending on the value of another column. The other way ’round was also …
SQLX How to easily generate XML
I recently had the need to generate XML files based on data stored in relational tables. This was done via an XML DOM implementation on the project I am …
View to select CG$ERRORS from (easing RuleFrame pain using a Table Function)
On my current project I am doing a lot of work with CDM RuleFrame and the Oracle Designer Table API. I just learned that the TAPI cannot survive MERGE …
Poor man's VPD – Virtual Private Database before 8i and in Standard Edition Databases
The concept of Virtual Private Database – aka Row Level Security or Fine Grained Access Control – is quite powerful. Without any impact on the SQL used in the …
Death of the End Date – How LAG and LEAD help fight redundancy
Yesterday just prior to our AMIS Query on ADF Faces I was talking to Toon Koppelaars about quite something else: the end_date column in tables that contain contiguous records …
Small introduction to SQL*Net debugging [client side]
Say it's that day again. You try to connect to a (new) database and once again you are facing SQL*Net problems. Blast!. What can you do? Once in a …
Jdbc, Clobs and Strings
Clob handling in jdbc can be a tedious job, especially because it required the use of Oracle specific extensions. With the 10g release this has been simplified and Clobs …
Summary results for all dates, including the ones that I do not have data for – example of using Partition Outer Join – Oracle10g SQL Feature
Trying to make myself useful by answering some of the questions on the OTN SQL and PL/SQL Forum, I came across this question: Group Above Report problem…not able to …
Oracle Designer and Oracle SCM – Last Date Modified and querying in the ROB
Today I decided to write a small package, an extension, to the Repository Object Browser for Oracle 10g (or 9i) Designer and Oracle 10g SCM. This extension will provide …
Another Pop-Quiz: Whose VPD policy is used when executing SQL in a (definer rights) package?
Virtual Private Database does not let me go. Today I had another burning question to which I could not see the immediate logical answer. I know that when a …
Returning a Ref Cursor based on a PL/SQL Collection
The question on the OTN Forum was: How do i add rows to a pl/sql table and then use the table to open a ref cursor.. Somehow I was …
Good Citizenship – Have Client Applications register themselves with the database
Years ago I have read about the package dbms_application_info for the first time. This is a standard supplied package, shipped with every Oracle Database. It can be used to …
Debugging PL/SQL with DBMS_DEBUG
A very good instruction on the programmatic interface to Orace’s PL/SQL debug facilities. If you do not happen to have a GUI PL/SQL debugger – such as in JDeveloper …
Pop-quiz: VPD policy that depends on a table with a policy…
What happens if the policy function on table A returns a predicate that refers to table B and table B has its own policy. For example: in a Master-Detail …
Select Trigger in Oracle Database – introducing Fine Grained Auditing
Does Oracle provide a SELECT trigger in the same way that we have INSERT, UPDATE and DELETE triggers? No, it does not. However. It does offer something that comes …
Data Profiling with Oracle Warehouse Builder 10gR2 (article in Dutch)
The 10gR2 or Paris release of Oracle Warehouse Builder is attracting a lot of attention. During Oracle Open World 2005 of course, and in a number of Blogs by …
SQL*Plus or Report style Break Groups in SQL Query
Rob just asked me if he could easily create break groups in a normal SQL query, somewhat like BREAK ON in SQL*Plus and break groups in Oracle Reports. The …
Oracle 10gR2 – New Feature: the Rules Manager
I noticed in the Oracle 10gR2 New Features Guide a piece on the Rules Manager. I have not yet figured out what it does exactly. But it certainly sounds …