How to calculate average on DATE columns ?

Oracle PL-SQL

Par Francois Degrelle

I 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 suite

Oracle collections : What is good to know

Oracle PL-SQL

Par Francois Degrelle

Let's see how to define, initialize and handle Oracle collections with SQL, PL/SQL and Forms. See the Collections paper Francois

Lire la suite

Forms - A dynamic report launcher

Oracle Forms

Par Francois Degrelle

This 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 suite

2005 TopTen Award Winner

Other

Par Francois Degrelle

http://www.wintercorp.com/VLDB/2005_TopTen_Survey/TopTenWinners_2005.asp Francois

Lire la suite

100% Dynamic

Oracle Forms

Par Francois Degrelle

A 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 suite