Video : APEX_DATA_PARSER : Convert simple CSV, JSON, XML and XLSX data to rows and columns

Today’s video is a quick demonstration of using the APEX_DATA_PARSER package to convert simple CSV, JSON, XML and XLSX data into rows and columns.

If you want the copy/paste examples and the test files, you can get them from this article.

Yet another reason why you should always install APEX in your databases.

The star of today’s video is Kosseila.HD, also known as BrokeDBA, complete with sun glasses, basket ball and a rattling watch. 🙂

Cheers

Tim…

Video : SQL/XML (SQLX) : Generating XML using SQL in Oracle

Another video fresh off the press.

If videos aren’t your thing, you can always read the article the video is based on.

The star of this video is Kevin Closson. Kevin’s a really nice guy and has a brain the size of a planet, but you know somewhere in the back of his mind he’s wondering what it would be like to hunt you down, kill you and mount your head above his fireplace. 🙂

Cheers

Tim…

Video : XMLTABLE : Convert XML into Rows and Columns using SQL

Here’s an Easter present for everyone out there. 🙂

If you are not a fan of videos, you can read the article it’s based on here.

The cameo in this video is Mike Hichwa of APEX fame, along with a rather rowdy bunch who try to muscle into the video. See the outtakes at the end.

Cheers

Tim…

Something old and something new…

A couple of articles crept out of the last couple of days.

First a revamp of an old article about XML over HTTP to bring it in line with some of the stuff I’ve been presenting recently.

Next, something new that caught my eye to do with auditing in 11gR2.

I know it’s hard to get excited about auditing, but this stuff is pretty neat.

Cheers

Tim…