IMPORT & EXPORT from/to compressed files directly…

Well, a simple method to import(export) directly to(from) compressed files using pipes. Its for Unix based systems only, as I am not aware of any pipe type functionality in Windows. The biggest advantage is that you can save lots of space as uncompressing a file makes it almost 5 times or more. (Suppose you are uncompressing a file of 20 GB, it will make 100 GB) As a newbie I faced this problem, so thought about writing a post. ...

June 6, 2007 at 8:57 PM · 3 min · 628 words · Amardeep Sidhu

NO_DATA_FOUND…

I was going through Eddie Awad’s blog. There was one post about an article about NO_DATA_FOUND exception in Oracle. Both the posts you can find here and here. Do read. It is really interesting. Sidhu

April 13, 2007 at 1:01 PM · 1 min · 35 words · Amardeep Sidhu