Articles Oracle Forms, PL/SQL, Java, J2EE
This 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 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 suiteSometimes, 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 suiteON 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
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 suiteBecause 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 suiteHow 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