Articles Oracle Forms, PL/SQL, Java, J2EE
Un nouveau forum francophone vient d'être créé sur l'incontournable site de Developpez.net. Il s'adresse aux étudiants/dévelopeurs APEX. Pour tous les développeurs APEX de Belgique, Suisse, Canada, Luxembourg, Afrique, etc. et ceux qui causent la langue...
Lire la suiteFor those people who don't want to hear about anything else than PL/SQL, here is Web 2.0 framework that lets you build world class Web applications with only PL/SQL! Formspider apps run using 100% AJAX, DHTML and JavaScript without the need to know any...
Lire la suiteHere is a code snippet showing how you can test if a file exists on a web site (that you have access, of course). It uses the UTL_HTTP database package. DECLARE url VARCHAR2(256) := 'http://sheikyerbouti.developpez.com/tmp/f6_menus/menudef.mmb'; username...
Lire la suiteIt is frequently asked how to load a BLOB table column from the content of an external file. This can be achieved by using the DBMS_LOB package's functions. Sometimes it is also useful to extract the BLOB content back to a file. Here is a procedure that...
Lire la suiteI've just discovered that Laurent Schneider has published a book about "Advanced Oracle SQL Programming". As I already know and have learned from him, I am pretty sure this book would be a gold mine.
Lire la suiteThis a small function that allows to sort the content of a string (ASCII sort).It use a collection or records to do the job: CREATE OR REPLACE FUNCTION sort_string(pc$string IN VARCHAR2) RETURN VARCHAR2 IS TYPE typ_rec IS RECORD(lettre VARCHAR2(10), nbre...
Lire la suiteIt 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 suiteI 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 suiteI 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 suiteThis is a small function that allows to extract tokens from a string. CREATE OR REPLACE FUNCTION Split ( PC$Chaine IN VARCHAR2 , -- input string PN$Pos IN PLS_INTEGER , -- token number PC$Sep IN VARCHAR2 DEFAULT ',' -- separator character ) RETURN VARCHAR2...
Lire la suite