Sponsorised links
June 2009
Ressources techniques
by sdaclin
Sponsorised links
April 2009
Oracle / Sun : 10 000 postes pourraient être supprimés
by kasi77
Oracle rachète Sun pour 7,4 Md$
by kasi77
(via)
Tutoriels Oracle, SQL, PL/SQL, DBA
by dszalkowski
& 1 other
Oracle - Club d'entraide des développeurs francophones
by dszalkowski
& 1 other
March 2009
OraMore • View topic - The Minimum Requirements to Use Export and Import DataPump
by night.kame
Note: If the errors reproduce after (re-)granting the privileges, then the directory on disk may have been created after the directory object was created. In that case:
- drop the directory object in the database;
- ensure that the directory exists on the filesystem on the server where the Oracle database is installed, and that the Oracle user has access to it;
- re-create the directory object in the database;
- grant the read and write privileges on the directory object to the user(s) who connect to the database when starting the expdp / impdp job.
Devenez fou avec Oracle en une leçon.
February 2009
ADOdb Database Abstraction Library for PHP (and Python) for MySQL, PostgreSQL, Microsoft SQL Server, Oracle, Firebird, Interbase, LDAP, Access, VFP, DB2 and many other databases
by Spone
& 13 others
Oracle: Deleting Duplicate Rows Efficiently
by night.kame
(via)
If you’ve made the mistake of forgetting a primary key on your table, it can be frustrating to find a way to delete all of the duplicate rows without deleting the initial instances.
S'applique aussi dans le cas où on a sous-estimé les capacités de ses collègues à toujours réinventer les erreurs de débutants (traduction : sans contrôle permanent, le développement informatique n'est rien, et même comme ça, ça n'est pas suffisant).
January 2009
The Johnnynine Weblog - How to view the Oracle sql cache / sql history
by night.kame
select * from v$sqlarea;
[#HHH-817] Aggregate projection aliases should not be applied to where-clause - Hibernate JIRA
by night.kame
2 comments
(via)
This is perfectly reasonable SQL. Oracle should support it.
Bug ouvert depuis trois ans. Visiblement chez JBoss, on préfère laisser filer plutôt que de reconnaître qu'on s'est vautré dans son commentaire.
December 2008
Mokka mit Schlag » You Can’t Trust the Cloud
by karlcow
Les gens se réveillent petit à petitTraditional payware like Oracle, Perforce, and Microsoft Office had lockin issues, but at least you controlled the software. Vendors couldn’t (usually) shut you down just because they decided your app no longer fit their business model. Cloud vendors can, and you have little to no recourse when they do.
November 2008
Egoboo
by parmentierf
& 2 others
SQL Anywhere
by ms_michel
October 2008
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»
)
September 2008
PHP Bugs: #17079: setlocale changes the internal representation of floats
by night.kame
2 comments
The system uses Oracle for persistence, where the decimal separator is a comma, as is a custom in that country. So numbers came in from Oracle, and then PHP was unable to process them correctly. For example, if a client had a debt of 25,12€, and the client paid 5€, then the comparison ($paid_amount > $debt) said incorrectly that the paid amount was more than the debt. Result: hundreds of wasted man-hours. In the end we recompiled PHP without that "fix".
Oui, chez Zend aussi on aime faire de la grosse daube.
