Screenshots

Although things are run from command line or behind program code, things talk better with omages, so here is a little sample of screenshots :

JDBMS_LOB

Comparing CRC32 from the loaded BLOB and the filesystem version.

JDBMS_MIMETYPES

Retrieving Mime Types straight from BLOBs.

Verifying the Mime Type by editing it.

Testing JDBMS_MIMETYPES and showing the test table.

Testing JDBMS_MIMETYPES on a filesystem file from sqlplus*, and showing the file from operating system command.

JDBMS_CHECKSUM

Testing JDBMS_CHECKSUM : Getting a file's CRC32 from sqlplus.

Testing JDBMS_CHECKSUM : Getting a BLOB's CRC32 from sqlplus.

JDBMS_COMPRESS

Trying to open the zipped BLOB (1/6)

Verify that the zipped BLOB is still readable. (Entry Name and Comment auto-generated (2/6)

Reading auto-generated comments on zipped BLOB in WinRAR (3/6)

JDBMS_COMPRESS : Unzip BLOB with JDBMS_COMPRESS into a BLOB and check CRC32, if Mime Type can be retrieved, and test to read the on the fly unzipped BLOB (4/6)

Unzip BLOB with JDBMS_COMPRESS into a BLOB and check CRC32, if Mime Type can be retrieved, and test to read the on the fly unzipped BLOB (4/6)

JDBMS_COMPRESS : Test ZIP/UNZIP BLOBs on dedicated test tables with virtual columns that use JDBMS functions, and verify that we retrieve the right initial BLOB. (5/6)

Test ZIP/UNZIP BLOBs on dedicated test tables with virtual columns that use JDBMS functions, and verify that we retrieve the right initial BLOB. (5/6)

Test the ZipEntries function to get zip BLOB contents like a table. (6/6)

JDBMS_XMPP

Oracle getting live on XMPP

JDBMS_XMPP : scott sending a message to prslump (both locally hosted on my local Openfire) from sqlplus. (2/)

scott is alive and talks !

Making reports/statistics on your XMPP Buddies (Rosters) from standard and simple relational queries. (2/)

Getting your xmpp live address book from a select statement. (2/)

Send a message to a list of available recipients thanks to a NVARCHAR2 csv list of recipients

Send a message to a list of recipients (while one of them is offline) thanks to a NVARCHAR2 csv list of recipients

JDBMS_XMPP : Send a message to a list of recipients. Notice that in this case, recipient list is provided thanks to a simple select to make integration easier.

Send a message to a list of recipients. Notice that in this case, recipient list is provided thanks to a simple select to make integration easier.

JDBMS_JACKSUM

Generate the ed2k html url of a file from sql

Generate the crc32 of a BLOB from sql and format output

Getting all supported Jacksum checksum algorithms.

Reporting on implemented checksums (checksum variants)

JDBMS_FILESYSTEM

JDBMS_FILESYSTEM : Extract Path and filename from an absolute filename

JDBMS_TWITTER

JDBMS_TWITTER : Post a message on a Twitter account from sqlplus.

JDBMS_TWITTER : Query a given user status as a table.

JDBMS_TWITTER : Make statistics on your friends (here their location).

JDBMS_TWITTER : Perform queries on your friends in a convenient way.

JDBMS_TWITTER : Parse your (or any other Twitter account) favorite s.

JDBMS_TWITTER : Query the direct messages you have in your inbox.

JDBMS_TWITTER : Query the direct messages you have sent.

JDBMS_TWITTER : Get your own followers.

JDBMS_TWITTER : Get the followers of a given Twitter account.

JDBMS_TWITTER : Send a Message from sqlplus*.

JDBMS_QRCODE

JDBMS_QRCODE : Encode a simple Text into a QrCode from sqlplus and insert it into a test table.

JDBMS_QRCODE : Have a look at the QrCode in the table (here from SQL Developer), and dump it to local disk.

JDBMS_QRCODE : Decode the QrCode from ZXing online decoder.

JDBMS_QRCODE : Get the text back from ZXing online decoder.

JDBMS_QRCODE.decode_qrcode : Get the text back straight from the BLOB that contains the QrCode.