Business Intelligence – Oracle

Archive for September 17th, 2007

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.     


Posted in All Posts, Oracle 11g | 4 Comments »