Are you an Oracle-related blogger? Are you attending Oracle OpenWorld this year? If you answered yes to both questions, then you are invited to attend the yearly blogger meetup at the ThirstyBear Restaurant and Brewery, Tuesday September 23rd at 7:00 PM.
Mark Rittman has been the person organizing the blogger meetup events for the past few [...]
On July 1st, blogs.oracle.com was migrated to a new platform, Six Apart’s Movable Type Enterprise on top of Oracle Content DB. The list of Oracle related blogs (authored by Oracle employees and non-employees) has moved to this page on the Oracle Wiki. Only Oracle employees are eligible to host blogs on blogs.oracle.com.
Along with the migration [...]
Links to interesting, educational, informational, or just plain fun websites…
1613 Records Found, that’s the number of sessions currently up on the Oracle OpenWorld content catalog. I know I’ll be attending the AppsLab Session that Jake just blogged about and a few more. But, it looks like the sessions’ schedule hasn’t been posted yet.
I’ll be on a panel with several other Oracle ACE Directors discussing [...]
In part 1, we reviewed HTTPURIType and DBURIType. Let’s now go over a few examples of more advanced XML using the SQL functions XMLTable and XMLQuery, Oracle’s native support for XQuery.
SQL functions XMLQuery and XMLTable are defined by the SQL/XML standard as a general interface between the SQL and XQuery languages. XMLQuery and XMLTable let [...]
Here are some cool and useful things you can do with XML using pure SQL in an Oracle database.
HTTPURIType
The HTTPURIType provides support for the HTTP protocol. It uses the UTL_HTTP package underneath to access the HTTP URLs. With HTTPURIType, you can create objects that represent links to remote Web pages (or files) and retrieve those [...]
VirtualBox, Virtual PC, VMware Workstation and a few other software packages help you create and run multiple virtual machines on your desktop or laptop enabling you to run multiple operating systems simultaneously on a single computer.
My personal favorite is VirtualBox (recently acquired by Sun Microsystems), not only because it is freely available as Open Source [...]
Links to interesting, educational, informational, or just plain fun websites…
David Aldridge’s post about OVERLAPS caught my attention. I did not know that you could do something like this in Oracle:
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jun 12 22:06:24 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> connect eddie/awad
Connected.
SQL> SELECT *
2 FROM dual
3 [...]
Amazing what you can do with ANYTYPE, ANYDATA, ANYDATASET, DBMS_TYPES, DBMS_SQL and pipelined table functions implemented using the interface approach. You can end up with a dynamic sql mashup like you’ve never seen before, and pivot like you’ve never pivoted before. Of course, if you’re on Oracle DB 10g or below, you can never pivot [...]