Category Archives: Oracle Database

Parameterized views in Oracle

Last week I came across an interesting problem. Problem: I want to centralize my average assets calculation in one place and different downstream systems should be able to consume it. For example: Cognos reports should be able to use this, … Continue reading

Posted in Oracle Database, PL/SQL | Tagged , , , | Leave a comment

Loading and unloading files using Oracle Database

Problem :I need to store files in my Oracle database. When requested the files need to be unloaded to a server in their original format. For storing files (gif/pdf/doc/jpg) a BLOB data type will be used.

Posted in Oracle 11g, Oracle Database | 5 Comments