Although things are run from command line or behind program code, things talk better
with omages, so here is a little sample of screenshots :
Comparing CRC32 from the loaded BLOB and the filesystem version.
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.
Testing JDBMS_CHECKSUM : Getting a file's CRC32 from sqlplus.
Testing JDBMS_CHECKSUM : Getting a BLOB's CRC32 from sqlplus.
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)
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)
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)
Oracle getting live on XMPP
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
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.
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_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 : 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.