Articles Oracle Forms, PL/SQL, Java, J2EE
This 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 suiteThis is a simple PL/SQL package that allows to insert, update and check existence of users in the LDAP. The package Specification CREATE OR REPLACE PACKAGE Pkg_Ldap IS /* * Package to handle the LDAP From PL/SQL * All functions use the DBMS_LDAP package...
Lire la suiteI have seen an interresting question on a forum about how to calculate average on DATE columns. It is not possible to calculate average on non-numeric values: SQL> SELECT AVG( creation ) FROM paragraphes 2 / SELECT AVG( creation ) FROM paragraphes * ERREUR...
Lire la suiteLet's see how to define, initialize and handle Oracle collections with SQL, PL/SQL and Forms. See the Collections paper Francois
Lire la suiteThis is a tutorial and an Oracle Forms tools that demonstrate how, in a single dialog, to launch any report with 0 up to 10 parameters. Read the Dynamic Report Launcher Francois
Lire la suitehttp://www.wintercorp.com/VLDB/2005_TopTen_Survey/TopTenWinners_2005.asp Francois
Lire la suiteA 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...
Lire la suiteWhen 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...
Lire la suiteThis is a PL/SQL procedure that allows to display the integrity referential path for a table. The result on a single table looks like the following : ------------------------------------------------------------------- Integrity referential constraints...
Lire la suiteSince 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...
Lire la suite