ODI Reference Website

http://www.business-intelligence-quotient.com/?cat=56

row count of DML

I always forgot how to know how many rows effected by pl/sql DML statement.

 

SQL%ROWCOUNT

 

Just want to memorize it

Happy Farm Rush

I have no idea why the little funny free game can result people complaint about the service is unavailable, the dogs are not doing their job, etc.

But it seems that, as long as the game company want to earn more money, they need to improve the service more.

No pains no gains. Isn't it?

I got a baby

Share my child's birth with you.

He was born on 2009/08/30 morning.

He was 3365g, 50cm.

 

To every male in this world,

Females are very great animal.

They bear huge pain then bear the babies.

 

I'd like to show my best salute to them!

How to know the code name of each Ubuntu version?

According to http://blog.websitestyle.com/index.php/2007/01/18/how-to-find-out-your-ubuntu-version-name/

1) Applications -> Accessories -> Terminal
2) Type the following at the prompt:
cat /etc/lsb-release
3) It should output something similar to mine, which looks like this:
DISTRIB_ID=Ubuntu
DISTRIB_RELEASE=6.10
DISTRIB_CODENAME=edgy
DISTRIB_DESCRIPTION="Ubuntu 6.10"

My result would be
eric@eric-asus-nb:~$ cat /etc/lsb-release
DISTRIB_ID=Ubuntu
DISTRIB_RELEASE=8.04
DISTRIB_CODENAME=hardy
DISTRIB_DESCRIPTION="Ubuntu 8.04.3 LTS"
eric@eric-asus-nb:~$

cpio usage

Oracle usually will use the cpio format as the installation binary.

But I used to use cpio -idvm < *.cpio to extract the file .

But encountered the error

cpio: 0511-903 Out of phase!
cpio attempting to continue...

cpio: 0511-904 skipping 732944 bytes to get back in phase!
One or more files lost and the previous file is possibly corrupt!

This made me hate the cpio format.

Today I finally found the correct usage

cpio -idcmv < *.cpio

 

Remove file according to date

I always forgot the syntax.

So I decide to write it down in my Blog.

 

find . -name '<pattern>' -exec rm -f {} \;

 

find . -atime +<n day> -exec rm -f {} \;