XSQL rules – CDM RuleFrame business rules classification application
1. Intro
Category: Languages
Preview of Oracle Drive – A Windows WebDAV interface on steroids
Oracle announces a preview release of Oracle Drive. A Windows WebDAV interface on steroids, Oracle Drive combines and surfaces features from both the Windows file system and the Oracle …
ADF and J2EE For Oracle Forms and Oracle Designer Developers
Another attempt by Oracle to lower the threshold for Designer/Forms developers to enter the Java/J2EE world. A page with viewlets, articles, news and useful links. Targeted at Forms Developers, …
Oracle Quiz on SQL and PL/SQL – See Water Burning – paper for ODTUG 2005
![Oracle Quiz on SQL and PL/SQL – See Water Burning – paper for ODTUG 2005]({"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 Quiz on SQL and PL/SQL – See Water Burning – paper for ODTUG 2005")
This paper presents a compilation of quirky questions, tantalizing puzzles and cheeky challenges that will have you wander among many interesting, useful and often surprising features and functionality, sometimes …
Oracle 10g's Finest – The Top 3 SQL and PL/SQL Features new in 10g – paper for ODTUG 2005
Papers for the ODTUG 2005 conference are limited to 10 pages. That is not enough. It never is, by the way. This time, I restricted myself to only three …
Citius, Altius, Fortius – Java Development met Oracle ADF en JHeadstart
We just published an article on ADF and JHeadstart 10.1.2 on our website: “Citius, Altius, Fortiusâ€? –Java Development met Oracle ADF en JHeadstart. It is written for and will …
Anydata and Collections
Steven Feuerstein has written a PLSQL-utility str2list in which he uses dynamic sql to fill collections of different types. While I was playing with the “new” Oracle types ANYTYPE, …
Analytical Power
While working on a Project for one of our Clients, an interesting requirement popped up. What they wanted was the following: “From this list of dates, we need the …
Recompiling invalid objects
I recently witnessed a developer recompiling his schema’s INVALID objects by selecting all the invalid objects from the user_objects table and compiling them. This he had to do 3 …
Anton heralded by Steven Feuerstein as very creative PL/SQL developer
Steven Feuerstein, one of the world’s leading PL/SQL experts, runs a series of column on OTN (Oracle Technology Network). One of the repeating elements of his column is the …
Oracle Open Source: SQLTools
I guess I must have been sleeping all this time… how did I miss this wonderful tool? If you raise your eyebrows now, you either disagree with this statement …
Integrating WebUtil with Designer 10g
This post discusses how you can integrate WebUtil with Designer 10g to generate webforms using the webutil API’s with less post generation actions. Near 100% generation of webforms using …
Declarative Implementation of Mandatory Master-Detail relationship (Order must have Order Lines)
Since at least 1996, I have been involved with specifying and implementing business rules. Whenever possible, business rules are implemented in the database using declarative constraints. Triggers are the …
Oracle Forms Documentation Utility
I noticed (tipped of by Duncan Mills) Oracle Forms XML Explorer, a useful utility – comparable to FoReDoclet, see Alex’ post Oracle Open Source : FoReDoclet – for generating …
Book Review: Mastering Oracle SQL
Title: Mastering Oracle SQL, 2nd Edition Authors: Sanjay Mishra, Alan Beaulieu ISBN:0-596-00632-2 Publication Date: June 2004 More info can be found at website of O’reilly. There’s also a sample …
new JHeadstart Team blog Announces production release
February 19, 2005
AMIS, IT, Java, Oracle, Oracle WebLogic Server, PL/SQL, Web HTML5 CSS3, Web/Java
2 Comments
Oracle’s JHeadstart team does a double whammy, not only do they release the production version of ADF JHeadstart but they announce it on their brand new weblog. As already …
JDeveloper 10.1.2 bug and release schedule
February 19, 2005
AMIS, IT, Java, Oracle WebLogic Server, PL/SQL, Tools, Web HTML5 CSS3, Web/Java
2 Comments
Recently I ran into a bug in JDeveloper 10.1.2 or actually in the ADF Business Components version supplied with it. Calling getAttributesNames() on a viewobject resulted in a nasty …
Oracle Warehouse Builder 10gR2 (beta), a first impression
As in most project the need for a representable test data set existed in a recently started one. The data was available in a small MS Access database (7 …
Lots of little interesting notes on Oracle 9i & 10g – database design, DBA, architecture, performance etc. from the Tom Kyte seminar
Last week, I sat with six colleagues at the AskTom Live – seminar with Tom Kyte. You can see us sitting here in the frontrow. You may have seen …
Pie Charts in SQL – how pathetic can you get?
I have written a number of posts on alternative, far fetched usages of Table Functions. My all-time high thusfar was a post titled Table FUNctions: select a graph in …
Courtesy of Tom Kyte: Generating rows in SQL with the CUBE statement – no dummy table or table function required
In a previous post Making up records in SQL Queries – Table Functions and 10g Model clause I discussed how you can make use of either a Table Function …
(When) Should we embark on ADF JHeadstart?
Organizations currently using JHeadstart 9.0.4.x or 9.0.5.x (for JDeveloper 9i or JDeveloper 10g (9.0.5.x) may wonder whether and when they should pick up the soon to be released ADF …
Publishing PL/SQL Based WebServices
January 24, 2005
Database, IT, Java, Oracle, Oracle WebLogic Server, PL/SQL, Web HTML5 CSS3
2 Comments
This post discusses how a Web Service can be published based on a PL/SQL Package inside the Oracle Database – using Oracle 10g JDeveloper. In this article we will …
Consuming Web Services from PL/SQL – Part II: A pure PL/SQL solution using UTL_HTTP (Oracle 9i or 10g)
This post discusses how a Web Service can be consumed from PL/SQL inside the Oracle Database through the use of the UTL_HTTP supplied package. In this article we will …
Addition to LOG4PLSQL to make loglevel adjustments at runtime.
I have recently used the LOG4PLSQL software for logging in a small application. I missed the possibility to change the logging level at runtime. In the production environment code …
Publish Diagrams in Oracle Designer – create PNG, GIF, TIFF, JPEG and BMP files for Designer Diagrams
Recently I installed Oracle Designer 9.0.4.5 – a maintenance release, released on November 18th. Previous releases were 10g (9.0.4.3) and patch release 9.0.4.4. All these releases contain a new …
XSLT in action – rather trivial tricks for XSLT that I always seem to forget
Recently I dipped into XSLT somewhat more seriously than I had done for quite some time. For some reason, I find XSLT not so intuitive to me that all …
Paper on JDeveloper as tool for PL/SQL Development
Tonight I completed a paper on using JDeveloper as a tool for Database Design and Generation as well as PL/SQL Development. This paper is in Dutch and will be …
Java-XML Binders Compared
Check your XML online
Yesterday I needed to validate some XML against a schema definition. I had a tool for that at hand, but alas, it failed to work. Looking for another way …
Comment from Steven Feuerstein
In the Oracle Magazine of januari/februari 2005 Steven Feuerstein wrote an excellent article about Refactoring for PL/SQL Developers. In this article he uses technologies known in the Java community: …
MERGE!
When I was confronted with the challenge to import about 260 tables from two different Rdb’s into a single Oracle database (9.0.1.x) on a daily basis via a database …
AMIS Query – Oracle BPEL Process Manager Dissected (Thursday 27th January)
BPEL is emerging as the standard for assembling a set of discrete services into an end-to-end process flow, radically reducing the cost and complexity of process integration initiatives. The …
Enabling Role-based security management in Oracle Designer 6i/9i/10g through the Repository Object Browser
Managing users and privileges on countless folders and application systems, configurations and workareas as is the job of the Repository Administrator can be quite a task. Each privilege on …
Pivoting in SQL using the 10g Model Clause
In this post we discuss pivoting of records in SQL - either splitting or merging records. Typically this is done using PL/SQL based Table Functioins, UNION (for splitting records) …
Parallelizing Table Functions (instead of paralysing)
In this post I explore the parallel execution of Table Functions. I was told it could be done, I have seen the examples and now I have tried it …
9.0.4.5 Maintenance Release Oracle Designer available
Today I discovered the 9.0.4.5 maintenance release for Oracle Designer 10g on MetaLink. It has been released on November 18th, so this is not hot news. The 9.0.4.5 is …
Oracle Open Source : SQuirreL
Not too long ago my colleague Zeger Hendrikse gave this presentation on Open Source Databases. Part of this presentation are the Tools available. One of the Tools he mentioned …
Table FUNctions: select a graph in SQL
You may seen some enthousiastic ramblings on Table Functions in earlier posts I have written. This is another one. With approximately 50 lines of code, you can select crude …
Tom Kyte presenting in The Netherlands – 8,9 and 10 February
On February 8, 9 and 10, Tom Kyte will present a seminar – just around the corner, in Utrecht. See Seminar Details for details. The event is organized by …