rramasam.blogspot.com
Rajalingam Ramasamy: Import BLOB into a Binary File
http://rramasam.blogspot.com/2006/07/import-blob-into-binary-file.html
Thursday, July 13, 2006. Import BLOB into a Binary File. Recentlt I read through an example which explains "How to dumpt the blob files in a file". CREATE OR REPLACE JAVA SOURCE NAMED "BlobHandler" AS. Import java.lang.*;. Import java.sql.*;. Import oracle.sql.*;. Import java.io.*;. Public static void ExportBlob(String myFile, BLOB myBlob). Bind the image object to the database object. Open streams for the output file and the blob. File binaryFile = new File(myFile);. Byte[] buffer = new byte[size];.
rramasam.blogspot.com
Rajalingam Ramasamy: July 2006
http://rramasam.blogspot.com/2006_07_01_archive.html
Thursday, July 13, 2006. Import BLOB into a Binary File. Recentlt I read through an example which explains "How to dumpt the blob files in a file". CREATE OR REPLACE JAVA SOURCE NAMED "BlobHandler" AS. Import java.lang.*;. Import java.sql.*;. Import oracle.sql.*;. Import java.io.*;. Public static void ExportBlob(String myFile, BLOB myBlob). Bind the image object to the database object. Open streams for the output file and the blob. File binaryFile = new File(myFile);. Byte[] buffer = new byte[size];.
rramasam.blogspot.com
Rajalingam Ramasamy: Performance Tuning : NOT IN and NOT EXISTS
http://rramasam.blogspot.com/2006/07/performance-tuning-not-in-and-not.html
Thursday, July 13, 2006. Performance Tuning : NOT IN and NOT EXISTS. Today I have found an interesting problem. There was a SQL like. SELECT * FROM supply ms. WHERE ms.supply type code = 'REQ'. AND NOT EXISTS (SELECT 1. FROM requisition lines prl. WHERE prl.requisition line id =. The table supply and requisition lines tables supposed to have very high number of records. Though on first site I didnt find anything abnormal, something triggered me to check the plan. 1:SELECT STATEMENT Cost=67,52.
rramasam.blogspot.com
Rajalingam Ramasamy: May 2007
http://rramasam.blogspot.com/2007_05_01_archive.html
Thursday, May 31, 2007. I always wanted to use the desktop blogging tool for blogspot. Because I am tiered of converting the white spaces in to to ensure my indentation is retained (because I use code and explain plan tree structures in the blog). But unfortunately I could not find any intuitive tool for the new blogspot. Finally here is the news, the latest version of Windows Live writer (version 1 beta2) supports blogspot! It supports white spaces and tabs (in which I am interested more). This does a...
rramasam.blogspot.com
Rajalingam Ramasamy: September 2008
http://rramasam.blogspot.com/2008_09_01_archive.html
Monday, September 29, 2008. Why the first rows hint is not working? When we plan for any summary display, the first thought comes to our mind is, 'I don't need all 50k the records meeting this criteria; I just need the first five records in this specific order'. But the SQL in place may ultimately hit all the 50k records to find out the five records we need! That would drive us crazy, wouldn't it? Let us look at the original sql, trace and the problems. 160; CATEGORY I...FROM PLRV. SELECT ...
rramasam.blogspot.com
Rajalingam Ramasamy: Why the first rows hint is not working?
http://rramasam.blogspot.com/2008/09/why-first-rows-hint-is-not-working.html
Monday, September 29, 2008. Why the first rows hint is not working? When we plan for any summary display, the first thought comes to our mind is, 'I don't need all 50k the records meeting this criteria; I just need the first five records in this specific order'. But the SQL in place may ultimately hit all the 50k records to find out the five records we need! That would drive us crazy, wouldn't it? Let us look at the original sql, trace and the problems. 160; CATEGORY I...FROM PLRV. SELECT ...
rramasam.blogspot.com
Rajalingam Ramasamy: Windows Live writer
http://rramasam.blogspot.com/2007/05/windows-live-writer.html
Thursday, May 31, 2007. I always wanted to use the desktop blogging tool for blogspot. Because I am tiered of converting the white spaces in to to ensure my indentation is retained (because I use code and explain plan tree structures in the blog). But unfortunately I could not find any intuitive tool for the new blogspot. Finally here is the news, the latest version of Windows Live writer (version 1 beta2) supports blogspot! It supports white spaces and tabs (in which I am interested more).
rramasam.blogspot.com
Rajalingam Ramasamy: Performance: Useful Cursors
http://rramasam.blogspot.com/2007/05/performance-useful-cursors.html
Saturday, May 19, 2007. Cursors are more handy in many situations when we want to deal with only a specific set of records. Let us say I want to select the latest transaction date from a transaction table based on a specific criteria for a specific period. I have two choices. Select max(trx.transaction date). Where trx.item = :B1. And trx.transaction date between :Period date from. And :Period date to;. Select trx.transaction date. Where trx.item = :B1. And :Period date to. Fetch a into x date;. Do not h...
rramasam.blogspot.com
Rajalingam Ramasamy: Wubi : Ubuntu as a Windows program.
http://rramasam.blogspot.com/2007/05/wubi-ubuntu-as-windows-program.html
Wednesday, May 09, 2007. Wubi : Ubuntu as a Windows program. Wubi is a Windows-based Ubuntu Linux installer that lets you run the OS on your Windows XP box- no partitions, bootloaders or Live CDs required. I have tried download the installer from http:/ www.cutlersoftware.com/ubuntusetup/wubi/en-US/index.html. The default installer is just 9MB. But the installation downloads the remaining files from net. The OS installed just like another program in windows OS. This can be even uninstalled fr...
