It’s almost Friday, a day before our flight. Lucas and I will be off to San Francisco on Saturday morning. Lucas will give some lectures on OOW 2006; I will mostly be pinpointing on XML (DB). On the side, I will try to consume some great lectures on performance (Tom Kyte, Jonathan Lewis, among others), try to see a little from San Francisco and enjoy the OOW 2006 atmosphere. The temperature over there will be on average 24Â° Celsius with a lot of sunshine.
After you have read the blog posts the websites of Sergio Leunissen, Eddie Awad or the “Ask Mr. Ed” website, you may wonder, if that was all you could do with those “magic” double quotesâ€¦
Probably not, I know of at least one other neat “trick” you can do with itâ€¦
Ever tried the following?
SQL> create user “=:Marco:=” identified by “Username is Invalid”;
You won’t make life easy though, because now you will have to use the double quotes to login as follows:
When you use VMware Server software to move or clone VMware Linux guest machines, you are asked by the VMware software if it should update the configuration file. When updating the configuration file, as requested by the software, your once working network settings wonâ€™t work anymore.
The following will help you to get on your way resolving these network problems, caused by MAC addresses, which are now out of sync…
I signed up a while ago for the SUSE Cool Solutions mailling list and I saw a very good step-by-step from Michel Bluteau regarding “Installing Oracle 10g R2 Database on SLES 10″. Although it is not yet a supported environment; it is very good post on how to install Oracle on SUSE Linux.
AMIS has been proven worthy to test the upcoming release of the 11gR1 database. After entering a lot of data in questionnaires and filling in project plans, AMIS got the approval to enter the test program. Last night I had my first 11gR1 (standard demo install) database installed on RedHat ES 3 and I must say;
Working for years with Oracleâ€™s relational environment, XML DB is a completely different kind of beast. Youâ€™re confronted with all the languages and techniques the XML environment has to offer – XML, XML Schema, XSLT, Xpath, DTD, DOM, SAX, etc,etc,etc – plus the ones you know from Oracleâ€™s (object) relational (database) world â€“ SQL, PL/SQL, java, OCI, java, etc.
I am currently working for a customer, who implemented the XML DB functionality in a new system. The total amount of XML data is roundabout 200 Gb. The XML data is split-up in 4 tables, 2 tables containing an XMLType column (XML Schema based, CLOB storage) and 2 XMLType tables (XML Schema based, Object Relational storage).
Some XML documents are more than 200 pages printed data and fairly complex in their structure , sometimes as big as 3 to 4 Mb. So it’s a real challenge to get the data you want, in a decent time period. Even simple questions like â€œgive me a count ofâ€¦ï¿½? or â€œsummerize the following numbersâ€¦ï¿½? can be tricky if you are dealing with complextype constructions/elements. Usage of COUNT and SUM can be tricky in an XML environment.
The following will give you more insight in Oracle SQL/XPath solutions and the need for a clear understanding of your XML Schema’s and the solutions presented by the Oracle database.