Sponsorised links
December 2008
October 2008
Les fonctions analytiques
by ms_michel
Permettent d'appliquer une fonction (somme, moyenne...) à un ensemble de lignes définies par rapport à la ligne courante ce qui permet de calculer aisément des sommes cumulées, des moyennes mobiles et d'accéder aux valeurs de la ligne précédente...
A Simple Example of Oracle Analytics: Running Totals
by ms_michel
Analytic_Fuction(«Any-Legal-Expression usually just a column»)
over (
«Partition-By-Clause»
«Order-By-Clause»
)
Sponsorised links
August 2008
Online Ad: Oracle Web 2.0
by kuroyagi
"Oracleは、印刷媒体への広告を削減し、オンラインおよびOOHに注力し、イベント集客力を高め、Web 2.0ツールを活用してオンラインのエンゲージメントを高めている。"
June 2008
Les vues matérialisées (Materialized Views)
by ms_michel
& 1 other
Une vue matérialisée (VM) est un moyen simple de créer une vue physique d'une table. Comme son nom l'indique et à la différence d'une vue standard, les données sont dupliquées. On l' utilise à des fins d'optimisation de performance, lorsque le select associé est particulièrement complexe ou lourd, ou pour faire des réplications de table.
May 2008
April 2008
March 2008
February 2008
22% annuels : le juste prix de la maintenance selon SAP - Blogs - ZDNet.fr
by kasi77
(via)
SAP propose donc un taux équivalent à celui d'Oracle.
Oracle, PostGIS et MySQL : éléments de comparaison
by Yann_L
Etude complète au format PDF.
Cette étude des bases de données spatialisées a pour but de comparer 3 systèmes de gestions de bases de données offrant la capacité de stocker et de gérer de l'information géographique : MySQL, PostgreSQL et la cartouche PostGIS, Oracle et les cartouches spatiales "Locator" (fournie par défaut avec Oracle) et "Spatial" sous la forme payante.
December 2007
Oracle Certification
by index
# Training with free exam questions
# Study guide
# Interactive online exam simulator
# Discussion board
Download of the day: Oracle VM
by camel
Virtualization is the process of abstracting computing resources such that multiple operating system and application images can share a single physical server, bringing significant cost-of-ownership and manageability benefits. Through its Oracle VM product, Oracle offers scalable, low-cost server virtualization for heterogeneous applications.
Oracle VM is free server virtualization software that fully supports both Oracle and non-Oracle applications, and is three times more efficient than other server virtualization products.
Consisting of Xen’s open source server software and an integrated Web browser-based management console, Oracle VM provides an easy-to-use graphical interface for creating and managing virtual server pools, running on x86 and x86-64-based systems, across an enterprise.
November 2007
Oracle : lutte contre le terrorisme ou délit de facies ? - PC INpact
by mbertier
(via)
Si votre nom a des racines nord-africaines, vous êtes automatiquement soumis à une procédure de vérification qui a presque l’odeur d’un délit de facies. Par contre, si votre nom fleure bon les origines nord-américaines, le bon Oracle disparaît et le logiciel vous est servi sur un plateau. Pour preuve, nous avons testé cet enregistrement en fournissant comme nom successivement Mohamed Ben Ibrahim et John Brown
xpress2people
by freedogme
société de services en ingénierie informatique, installée à Paris, spécialisée dans l'expertise informatique.
October 2007
Mastering Oracle Python, Part 3: Data Parsing
by pvergain
There are countless reasons for parsing data, as well as tools and techniques to do it. But even the "right" tool may be insufficient when you need to do something new with the data. The same concerns exist for the integration of heterogeneous data sources. Sooner or later, the right tool for the right job happens to be a programming language.
Oracle offers some very powerful utilities for loading, processing, and unloading data. SQL*Loader, Data Pump, external tables, Oracle Text, regular expressions—it's all there. Yet there is often a need to do things outside the database (or, trivially, perhaps you just weren't granted the necessary database privileges).
Python delivers possibilities for efficient data parsing at a high level. The extensive standard library and many modules available for free on the Internet make it possible to work with data logic rather than dissecting bytes by hand.
Mastering Oracle Python, Part 2: Working with Times and Dates
by pvergain
Starting with the Python 2.4 release, cx_Oracle handles DATE and TIMESTAMP datatypes natively, mapping values of such columns to Python datetime objects from the datetime module. This offers certain advantages as datetime objects support arithmetic operations in-place. Built-in time zone support and several dedicated modules make Python a real time machine. The transition between Python and Oracle date/time datatypes is completely transparent to developers thanks to cx_Oracle's mapping mechanisms.
Python developers might find Oracle's date arithmetic a bit odd at first, but only with a few tips it becomes completely clear and very reasonable. This part of the series will give you an in-depth understanding of date arithmetic from both Oracle and Python's point of view. Each of them offers rich support for handling date/time datatypes, so it is the programmer's choice which one to rely on. If you tend to put application logic inside the database or whether you prefer to encapsulate date/time operations in the application itself, the seamless integration of Oracle with Python offers you maximum flexibility with limited programming effort.
Mastering Oracle Python, Part 1: Querying Best Practices
by pvergain
Among the core principles of Python's way of doing things there is a rule about having high-level interfaces to APIs. The Database API (in this case the Oracle API) is one example. Using the cx_Oracle Python module from Computronix, you can take command over the Oracle query model while maintaining compatibility with Python Database API Specification v2.0.
The model of querying databases using DB API 2.0 remains consistent for all client libraries conforming to the specification. On top of this, Anthony Tuininga, the principal developer of cx_Oracle, has added a wide set of properties and methods that expose Oracle-specific features to developers. It is absolutely possible to use only the standard methods and forget about the "extra" ones, but in this installment you won't be doing that. The concept of universal database wrappers might work in some cases but at the same time, you lose all the optimizations that the RDBMS offers.
