Overblog Tous les blogs Top blogs Technologie & Science Tous les blogs Technologie & Science
Suivre ce blog Administration + Créer mon blog
MENU

Francois Degrelle's blog

Articles Oracle Forms, PL/SQL, Java, J2EE

Publicité

Forms-Javabean tutorial

Forms-Javabean tutorial

This is a Javabean component that allows to display a Jslider Read the Forms-Javabean : a JSlide component in your Forms application Francois

Lire la suite
Publicité

Forms-Javabean tutorial

Forms-Javabean tutorial

This is a Javabean component that allows to display a JfileChooser dialog box with image preview Read the Forms-Javabean Open-dialog box with preview image Francois

Lire la suite

Execute a function which name is stored in a string

Sometimes, on forums, I see questions about dynamic SQL. This is one of them: "Hello, I would like to execute a function wich name is stored in a string. How could I do ?" The solution for this kind of problem is allways the dynamic SQL: Connected to:...

Lire la suite

Forms-Javabean tutorial

Forms-Javabean tutorial

This is a new Forms-Javabean tutorial that shows how to display in a Forms application buttons with HTML labels Forms-Javabean button with HTML label Francois

Lire la suite
Publicité

The TRUNC() function

ON NUMBERS This function allows to make two types of action on a number: - Keep the number of wished decimals (precision > = 0) - Centre the whole part of a number in a range (precision < 0) Example of preservation of the decimal part

SQL> select...
                        

Lire la suite

Oracle Database 10g Sets New World Record For Performance

Oracle Database 10g Sets New World Record For Performance Francois

Lire la suite

DBMS_PROFILER

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....

Lire la suite

Dynamic cursor

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...

Lire la suite
Publicité

My first English pronunciation lesson...

"Three witches watch three Swatch watches. Which witch watch which Swatch watch?" I can, now, clean-up my screen... Francois

Lire la suite

How to encrypt/decrypt strings with the dbms_obfuscation_toolkit package

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...

Lire la suite