public marks

PUBLIC MARKS with tags oracle & database

2013

2010

Referential Integrity with Virtual Columns

by ms_michel
Création d'une clé étrangère sur une colonne virtuelle pratique dans la cas où on doit se coltiner des bases de données mal conçues (mais à partir de Oracle 11 uniquement)

Using TABLE INHERITS in Oracle and PostgreSQL to provide consistency

by ms_michel
Un article qui explique comment définir une structure de table de base puis de la réutiliser dans toutes les autres tables. Utilisable pour avoir automatiquement certaines colonnes dans toutes les tables : identifiant, date création, date modification, utilisateur qui a fait la création, utilisateur qui a fait la dernière modification...

2009

Utilisation de LINQ avec la base MySQL

by ms_michel (via)
Un tutoriel qui explique comment utiliser LINQ (en fait DBLinq) avec une base de données autre que SQL Server (en l'occurrence MySQL)

2008

2007

cx_Oracle

by jdrsantos
cx_Oracle is a Python extension module that allows access to Oracle databases and conforms to the Python database API specification. This module is currently built against Oracle 9.2.0 and 10.2.0.

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.

2006

Active users

astrochoupe
last mark : 24/04/2013 12:55

Hieroglyphe
last mark : 26/03/2013 09:23

ms_michel
last mark : 23/04/2010 09:18

jdrsantos
last mark : 12/10/2007 14:13

pvergain
last mark : 05/10/2007 07:45

asoares
last mark : 17/07/2007 11:22

maxxyme
last mark : 22/03/2007 13:50

gkojax
last mark : 08/02/2007 02:43

sdaclin
last mark : 31/01/2007 08:23

pomoxp
last mark : 11/12/2006 12:37

Mintolf
last mark : 04/12/2006 08:55

Clichop
last mark : 04/12/2006 08:55

sz2006
last mark : 04/12/2006 08:55