The Blob - Slicing and dicing in Oracle
Nicoleta Mustatea, Peter Jansen · ResearchSpace (University of Auckland) · 2007
At The University of Auckland Library we successfully tried another approach in demystifying the BLOB: slicing it in Oracle by employing existing functions in Voyager. All we have done is to invoke these functions into our SQL statements and in no time at all we obtain the information we want. We can run these queries in 3 different environments: Oracle’s own SQL+ Microsoft Access (in Pass-through Queries) SQL Server 2000 The advantages of using this approach are: Speed of execution Data extraction is server side therefore independent of Microsoft Access VB. Possibility to schedule the query to run at fixed intervals. (in SQL Server) The simplicity of using what is already in the Voyager database is making this melange of Oracle and SQL server queries not only chic but also efficient.