Do SQL ISO standards matter?
No, the SQL ANSI/ISO standards do not matter to me because of two reasons: Continue reading…
5 Comments | Filed in Oracle | Tags: iso, standardOracle Responds to the Password Hashing Algorithm Paper
In response to the recent publication by Joshua Wright and Carlos Cid, entitled “An Assessment of the Oracle Password Hashing Algorithm“, Oracle has just sent out the following e-mail to its customers (I got it a few minutes ago): Continue reading…
Comments Off | Filed in Oracle | Tags: password, SecurityDUAL behavior change
While reading the book Expert Oracle Database Architecture, I noticed a very important bit of information about the DUAL table. In 10g, Oracle does not do a full table scan on DUAL if it does not need to. This is not the case in versions prior to 10g. To illustrate: Continue reading…
5 Comments | Filed in Oracle, Tips | Tags: 10g, dualInsert into DUAL
On the Oracle-l mailing list, Jared Still posted a message about a little experiment he did which concluded that Oracle (10gR1) always makes sure that DUAL returns one and only one row even if it contains more than one row.
I have repeated the experiment on my Oracle 10g XE database (Important: Do not do this dangerous stuff on your production database. Never insert/delete/update DUAL): Continue reading…
9 Comments | Filed in Oracle | Tags: 10g, dualAdvice regarding the so-called Oracle Voyager Worm
This morning when I was checking my work e-mail from home, I found this e-mail from “Oracle Global Product Security” in my in-box: Continue reading…
Comments Off | Filed in Oracle | Tags: Security, wormPodcast about Oracle DB XE
In case you have not noticed it yet, there is a new podcast on OTN: “Oracle vice president Tom Kyte talks about Oracle Database 10g Express Edition (XE)–the new, free, and small-footprint Oracle Database release-and its benefits for developers, DBAs, and ISVs”. Listen.
Comments Off | Filed in Oracle | Tags: xeAjax bathroom cleaner and more
Yes, there is that and there is also “Asynchronous JavaScript and XML”.
Jesse James Garrett, the person who invented the acronym AJAX, defines it:
Ajax isn’t a technology. It’s really several technologies, each flourishing in its own right, coming together in powerful new ways. Ajax incorporates:
- standards-based presentation using XHTML and CSS;
- dynamic display and interaction using the Document Object Model;
- data interchange and manipulation using XML and XSLT;
- asynchronous data retrieval using XMLHttpRequest;
and JavaScript binding everything together.
Comparison between MS SQL 2005 and Oracle 10g
I stumbled upon a a technical white paper that provides a feature comparison between MSSQL 2005 (Yukon) and Oracle 10g databases. Here are a few points I noted from the paper, quoting:
Continue reading…
