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

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 {} \;

 

 

敗犬的由來

「美麗又能幹的女人，只要過了適婚年齡還是單身，就是一隻敗犬；平庸又無能的女人，只要結婚生子，就是一隻勝犬。」─酒井順子

 「敗犬」二字頻頻出現。這當然是日本女作家酒井順子寫於2003年底的暢銷書－「敗犬的遠吠」

 

感謝Vincent的分享 ;)

How to make IE8 compatible with Oracle EBS R12

In IE8 when you access Applet form of R12 will show the following error.

Solution : Stop the XSS Filter to avoid the error

 

How to enable order by effect of distinct in Oracle 10g db?

alter system set "_gby_hash_aggregation_enabled"=false sid='*';

How to check oracle database character set?

select *
from nls_database_parameters
where parameter = 'NLS_CHARACTERSET'

Canonical format in XML Publisher Date Format

 

To use the Microsoft format mask or the Oracle format mask, the date from the XML data source must
be in canonical format. This format is: YYYY-MM-DDThh:mm:ss+HH:MM
where
• YYYY is the year
• MM is the month
• DD is the day
• T is the separator between the date and time component
• hh is the hour in 24-hour format
• mm is the minutes
• ss is the seconds
• +HH:MM is the time zone offset from Universal Time (UTC), or Greenwich Mean Time

An example of this construction is: 2005-01-01T09:30:10-07:00
The data after the "T" is optional, therefore the following date: 2005-01-01 can be formatted using either date formatting option. Note that if you do not include the time zone offset, the time will be formatted to the UTC time.

Mimic the required column

Using color r100g100b70

 

Excel 中的Distinct

最近常被問到, 就跑去Google了一下

查到用這個方法, 還不錯

=IF(COUNTIF(Sheet1!$A$2:A2,Sheet1!A2)=1,Sheet1!A2,"")

留在blog上, 以便以後自己查