Death of the End Date – How LAG and LEAD help fight redundancy
![Death of the End Date – How LAG and LEAD help fight redundancy]({"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"} "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 …
Category: Languages
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 …
PL/SQL Profiling
How do you trace performance issues and bottlenecks in your PL/SQL applications? Since 8i the Oracle database has been equiped with the profiling tool dbms_profiler. It is quite simple …
Improvements in Oracle SCM Check Out and Check In mechanism (better Oracle Designer Source Code Control)
Oracle SCM – the Software Configuration Manager – provides the backend source code control services for Oracle Designer. It offers among other things functionality for Version Control: Check In, …
XML technologies
This picture contains a handy overview, with links, of all (?!) XML (related) technologies, specs, acronyms etc. A similar overview is also available for java.
Building Check In protection into Oracle Designer/Oracle SCM – Check In only by the user that did the Check Out
One of the peculiarities – that word once took me three minutes to pronounce more or less correctly during a workshop in Melbourne, Australia and I vowed never to …
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 …
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 …
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 …
Book Review: Beginning Oracle Programming
Title: Beginning Oracle Programming Authors: Sean Dillon, Christopher Beck, Thomas Kyte with Joel Kallman and Howard Rogers Publisher: Apress ISBN: 1-59059-286-7 Publication Date: Sep 2003 Website: http://www.apress.com/book/bookDisplay.html?bID=253
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 …
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 …
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 …
Ant, Stored Procedures and dbms_output
Running sql (scripts) from ant using the ant task is quite easy and straight forward. Unfortunately, the ant sql task is not really suited for running pl/sql, e.g. exec …
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 …
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 …
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 …
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 …
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 – …
About nulls in the database
The july/august edition of Oracle Magazine has a very interesting article by Lex de Haan and Jonathan Gennick about Nulls (‘nothing to worry about’) in the database. Although I …
Oracle's Forms Strategy – Does it exist? ODTUG 2005 Wrap Up (part 1)
I do not understand Oracle’s strategy with regard to Oracle Forms. If such a thing really exists. Oracle has made it very clear that Development Tools are only considered …
Oracle Database 10g Release 2 – SQL and PL/SQL Features
Arup Nanda writes about new features for the upcoming Oracle 10gR2 release, targeted at the end of June 2005. In this article, he discussues new SQL and PL/SQL features. …
Day Two of the ODTUG 2005 Conference – Oracle's Development Tools Strategy, JDeveloper free?, JHeadstart and more…
ODTUG 2005 is under way. 600 Oracle Developers, users of Oracle Forms and Designer, JDeveloper and Portal, Discoverer and Reports and many other Oracle technologies, have gathered in the …
Day One of the ODTUG 2005 Conference – first impressions and my first presentation: 10g Top 3 SQL and PL/SQL
The show is back in town, and so am I. Precisely one year a go, the ODTUG crowd assembled in Scottsdale, Arizona. This year we all flocked to New …
Oracle's Disappearing Act: Flashback Query
Did you ever find yourself in a situation where you accidently deleted a number of records which you shouldn’t have? And to top it off, committed the changes? I …
Book Review: Mastering Oracle PL/SQL: Practical Solutions
Title: Mastering Oracle PL/SQL: Practical Solutions Authors: Christoper Beck, Joel Kallman, Chaim Katz, David C. Knox, Connor McDonald Publisher: Apress ISBN: 1-59059-217-4 Publication Date: Dec 2003 Website: http://www.apress.com/book/bookDisplay.html?bID=276 More …
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 …
Mastering XML DB – COUNT and SUM
May 20, 2005
AMIS, Announce / Events, Database, Databases, DBA Oracle, IT, Web HTML5 CSS3, XML
5 Comments
Working for years with Oracle’s relational environment, XML DB is a completely different kind of beast. You’re confronted with all the languages and techniques the XML environment has to …
Bursting Reports, an easier way to distribute parts of your report
Ever had someone ask you:â€?I have this Oracle Report that I need to email or print to file. I have to run this report multiple times with only one …