blog.gralike.com

Oracle E-Learning Resources

Marco Gralike — Sat, 12 May 2012 14:54:08 +0000

There is a lot of new stuff out there nowadays, regarding products and/or functionality or others. This is also true for Oracle and in short it’s not easy to follow all those innovations and/or new products. So from time to time I have a watch on stuff that interests me on the YouTube Oracle E-Learning …

Advert: Nederlands preview event ‘Collaborate 12′ (Dutch)

Marco Gralike — Mon, 02 Apr 2012 07:36:49 +0000

‘COLLABORATE 12: Technology and Applications Forum for the Oracle Community’ is de grootste Oracle gebruikersgroep conferentie ter wereld en wordt jaarlijks georganiseerd in de Verenigde Staten. Het is hét evenement om bij te zijn wanneer je geïnteresseerd bent niet alleen in Oracle Applications (E-Business Suite, JD Edwards, Siebel, etc.) maar ook in Oracle Technologie in …

Advert: Oracle XML Training With Marco Gralike

Marco Gralike — Thu, 01 Mar 2012 16:03:50 +0000

I was asked by Jože Senegačnik, if I would be would be interested in doing a Masterclass/Seminar in Slovenia and, yes of course, I really liked the idea. So after having a quick look in my agenda, regarding my free time, we started to set things up. This 2 day seminar will take place the …

Advert: ODTUG Webcast – “Thinking Clearly about XML”

Marco Gralike — Wed, 18 Jan 2012 11:30:16 +0000

I will make an first time attempt tomorrow to do a webcast for ODTUG in the US about how to start with XML in the Oracle database kind of topics. The subject was initially inspired by Cary Millsap’s great whitepaper, “Thinking Clearly About Performance”, that is, my attempt of doing an OakTalk during UKOUG 2011. …

Oracle 4 and the User Friendly Interface (UFI)

Marco Gralike — Thu, 29 Dec 2011 23:31:57 +0000

Oracle 5 and the First Appearance of SQL*Plus

Marco Gralike — Thu, 29 Dec 2011 23:27:11 +0000

HOWTO: Using the Oracle XMLDB Repository to Automatically Shred Windows Office Documents (Part 1)

Marco Gralike — Tue, 20 Dec 2011 16:24:58 +0000

People who have attended the UKOUG presentation this year where Mark Drake, Sr. Product Manager XML Technologies / XMLDB, Oracle HQ, and I demonstrated the first principles of the XDB Repository, might have been impressed with its (GEO/KML Spatial, Image EXIF info) capabilities combined with Google Earth. This post will zoom in on how to …

UKOUG 2011: Drag, Drop and other Stuff. Using your Database as a File Server

Marco Gralike — Mon, 12 Dec 2011 12:24:01 +0000

Last Thuesday, Mark Drake, Senior Product Manager and I, delivered a good presentation during UKOUG in Birmingham about how to use your database, via XMLDB functionality, as a file server. The presentation demonstrated as well how you could extent the “standaard” file server (aka your database) functionality with features like, WebDAV driven ACL Security and …

HOWTO: XDB Repository Events – An Introduction

Marco Gralike — Mon, 21 Nov 2011 16:37:41 +0000

Oracle XMLDB Repository Events, IMHO, was one of the coolest functionalities introduced in Oracle 11.1. In principal they are a kind of event “triggers” that get fired during actions / methods on objects in the XDB Repository. One of the disadvantages of this functionality is that they are very “sparsely” documented in the Oracle XMLDB …

HOWTO: Implement Versioning via Oracle XMLDB

Marco Gralike — Mon, 21 Nov 2011 14:07:49 +0000

Since a long time, the database has had some versioning capabilities, long before features like “Edition Based Redefinition” in Oracle 11gR2 appeared. This versioning, via XMLDB functionality, is based on its XDB Repository access to the database. The XDB Repository is a file/folder metaphor that acts as a file server. You can enable this functionality …

UKOUG 2011: Using your Database as a Fileserver

Marco Gralike — Mon, 21 Nov 2011 11:23:27 +0000

One of the coolest things in Oracle 11g and onwards is a functionality called XDB Repository Events. Most of you probably know that based on XMLDB functionality in the database, the database also can be used in a File server kind of way by enabling the XDB Repository HTTP/FTP or WebDAV functionality via DBMS_XDB. XDB …

HOWTO: Consume Anydata via XMLType (and back)

Marco Gralike — Mon, 21 Nov 2011 10:18:36 +0000

This was a small mind exercise on the OakTable website (OakTable Challenge)for a person regarding how to go from a relational table to anydata datatype table and back, which I, of course, approached via an “XMLType” of way thinking. Probably the whole thing is not that practical and/or can be optimized in various ways, but …

Review: The Method-R Profiler

Marco Gralike — Thu, 10 Nov 2011 20:01:43 +0000

I was lucky enough to get my hands on the Method-R Profiler and had a test drive with it. So first of all what is it? As you might expect a profiler, a profiler for Oracle performance problems. The tool makes use of Oracle’s trace facilities. If you have a performance problem with the database …