Oracle text
![Oracle text]({"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 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 …
Category: PL/SQL
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 …
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 …
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
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 …
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 …
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: …