Oracle 11g - BLOB and BFile support for SQL Plus « Business Intelligence

Oracle 11g - BLOB and BFile support for SQL Plus

Posted by Venkatakrishnan J on September 17, 2007

I happened to come across one other new feature in Oracle 11g with respect to SQL Plus. SQL Plus now supports the use of blobs and bfiles in your queries. This is what the documentation has got to say about this “Queries in SQL*Plus now support BLOB columns.This feature allows you to verify the contents of BLOB columns.”. Pretty interesting feature.

This is what i get in 10g.

And this is what i get in 11g.

This entry was posted on September 17, 2007 at 4:52 pm and is filed under All Posts, Oracle 11g. . You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

2 Responses to “Oracle 11g - BLOB and BFile support for SQL Plus”

Paweł Barut Says:
September 17, 2007 at 7:10 pm
How about table with some rows?
Venkatakrishnan J Says:
September 17, 2007 at 7:58 pm
Thanks for your comments Pawet. I have updated the article with some more screenshots and ofcourse with some data.