Francois Degrelle's blog
about some Oracle technologies 
How to encrypt/decrypt strings with the dbms_obfuscation_toolkit / dbms_crypto packages Oracle 9i dbms_obfuscation_toolkit package CREATE OR REPLACE PACKAGE Cryptit AS FUNCTION encrypt( Str VARCHAR2 ) RETURN RAW; FUNCTION decrypt( xCrypt VARCHAR2 ) RETURN...
It is not the first time I see this question on forums: "How can I restrict the values of my LOV, that the end user cannot select twice the same ?" One solution is to use a record group with a WHERE clause that excludes the records that has just been...
When you deliver an application, the job is not really complete if it is not shipped with a help system. Sometimes, for small projects, the budget allowed does not take into account the help system. (talking about buying a tiers robot help maker solution...
A few weeks ago, I wrote an article about how to get data and data structure from a single Select order. At this time, I did not know what implementation I could do with this concept.Today, I know. This article shows how you can build a complete application...
Because I like anything which is "dynamic", I have played with the DBMS_SQL package. My goal was to send any Select order to a procedure and get a collection of records and a datastructure to manipulate these records. So, this is the trick: CREATE OR...
Since the 10g version, when you drop a table, you could see another table in the USER/ALL/DBA_TABLES views. The name of this new table looks a little bit funny, like : BIN$B9405sOZRq2GkbE/z5Gwaw==$0 What is this ? This is the new RECYCLEBIN feature that...
Since I am a very big fan of the music of Frank Zappa, i get everything i can fin about him. Here is some of his best quotations: Stupidity is the basic building block of the universe. There is no hell. There is only France. Don't mind your make-up, you'd...
The DBMS_PROFILER package allows to determine the time taken by each instruction of your code. At the same time, you could also see the internal processing time for the basic instructions. Of course, these times depend on the power of the test machine....
Sometimes, we need, in an application, to extract some table rows to a flat file.This is a PL/SQL procedure that allows to extract the rows of a table, or the INSERT ordrers. You can download the script here Extraction_table procedure CREATE OR REPLACE...
Hello there, If you like funny people, have a look at this drummer . He's (Steve Moore) just crazy on his set ! He made my day Have a good time, Francois
Sometimes I see questions on forums on how to handle frames at runtime. Of course, at this moment, there is no standard built-in available.This is a workaround that allows to create and handle frames at runtime. Read the article
Hello, Here's a 8 minutes video , similar to what I presented last May (2012) at AMIS Francois
After a long time without any change, here is a major version that allows the user to display/edit (almost) any SQL order in a dynamic table-block. Get the new version Francois
This version comes with the Text-Item gradient background feature: Get it now .
See the new features .
This version comes with 3 great new features: Show_In_Rect to show/hide items depending on the mouse location JRE6 Desktop feature to open, print, mail, browse local files new DrawLAF Open/Save file Dialog Get it now .
Here is a PJC that hide parts of a text item . It is usefull to hide the begin or the end (or any part actually) of a phone number or a credit card or anything else. Get the PJC
Here is a Pluggable Java Component from Andreas Weiden, to have expandable/collapsable canvas. It allows a simple Push Button Item to expand/collapse the whole content of a canvas like a Tree item. Get it now
The new 1.6.4 version is out with dynamic Popup Menus and Sortable Table-blocks. Get it now
Here is a Simple Horizontal Scrolling Marquee Java Bean proposed by Omama Khurshid. Get it now
The new Forms Look and Feel Project 1.5.2 version is out with a few new enhanced text features. You can, now, fill the texts with pre-defined patterns or image, and also draw rotated texts. Get it now
Here is a Java Bean from Jesus Vallejo that returns the date / time of major cities. It runs with JInitiator. Read the article
The new Forms Look and Feel Project 1.3.8 version is out with new features about the current record visual attributes. Get it now
Andreas Weiden has started a blog about Oracle technologies in general, and Oracle Forms in particular. Nice to see the Forms community so alive
So, the Oracle Forms Java Bean contest is over. With 19 entries sent, it is a success. All you have to do, now, is to vote !
