顯示具有 Computers and Internet 標籤的文章。 顯示所有文章
顯示具有 Computers and Internet 標籤的文章。 顯示所有文章

2009年11月2日 星期一

ODI Reference Website

2009年11月1日 星期日

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 Wink

2009年8月7日 星期五

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:~$


2009年5月25日 星期一

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


 

2009年5月8日 星期五

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

 

 

2009年4月9日 星期四

敗犬的由來

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

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

 

感謝Vincent的分享 ;)

2009年4月1日 星期三

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


 

2009年2月17日 星期二

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.

2009年1月14日 星期三

Excel 中的Distinct

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

查到用這個方法, 還不錯

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

留在blog上, 以便以後自己查戴太陽眼鏡