A dynamic "IN" clause within a PL/SQL block

Oracle PL-SQL

Par Francois Degrelle

It is not the first time i see some posts on forums that ask: How can I make a dynamic IN clause within a PL/SQL block when the list of values for the IN clause is provided with a string or a table column ? I have seen, on the ORAQA a post that explains...

Lire la suite

Kind of LONG_RAW_TO_VARCHAR2 function

Oracle PL-SQL

Par Francois Degrelle

I have just seen a recent Laurent Schneider's blog entry about selecting from a LONG column http://laurentschneider.blogspot.com/2006/01/select-from-test-where-mylong-like.html. Then i remember another question on this same forum where the guy need to...

Lire la suite

Forms Javabean : Get the Forms applet parameters

Oracle Forms

Par Francois Degrelle

This is a Javabean component that allows to retrieve the Forms applet parameters. Read the article Francois

Lire la suite

Hex to decimal

Oracle PL-SQL

Par Francois Degrelle

I have just read the Jeff Moss article concerning Hex to decimal conversion and vice versa. In this article we can find some great conversions routines. This is one that allows to convert hexadecimal numbers greatest than 255 to a decimal format: CREATE...

Lire la suite

Forms javabean : a Javabean timer

Oracle Forms

Par Francois Degrelle

This is a Javabean that allows to replace the internal Oracle Forms' timer Read the article Francois

Lire la suite