US Season & Time
There are 4 seasons (in order):
1. Spring
2. Summer
3. Autumn
4. Winter
There are 2 times:
- Daylight Time
Move 1 hour ahead at 2am every second Sunday on March (loss 1 hour). Ex: 2am 14 March 2010
- Standard Time
Move back 1 hour at 2am every first Sunday on November (gain 1 hour). Ex: 2am 7 Nov 2010
I Wanted To Change The World
By Unknown Monk, 1100 A.D.
When I was a young man, I wanted to change the world. I found it was difficult to change the world, so I tried to change my nation.
When I found I couldn’t change the nation, I began to focus on my town. I couldn’t change the town and as an older man, I tried to change my family.
Now, as an old man, I realize the only thing I can change is myself, and suddenly I realize that if long ago I had changed myself, I could have made an impact on my family. My family and I could have made an impact on our town. Their impact could have changed the nation and I could indeed have changed the world.
Great time, Good friends, Nice Easter Camp
I just came back from Easter camp retreat carried by one of HOPE church care group. It was 3 days 2 nights retreat in Tanjung puteri golf resort Johor Bahru Malaysia. Actually I didn’t have any plan to join this retreat. I’m not part of their church and I was afraid I would feel lonely there. My childhood friend who was supposed to accompany me canceled joining the retreat. I was also sad during that week, I organized something but it didn’t run as I expected. Even at the last day before the departure day, I kept wondering whether I would go or not.
Surprisingly it was very nice there. The programs were not boring. It’s not like ’seminar’ which can make you sleepy because you need to listen what the speaker says all the time. For me, it’s more like outing. I enjoyed the sharing sessions (TEDUH). The topics were interesting. It makes me more value the time I have and not afraid of obstacles since it makes me stronger. Although the game (runaway and free concert) was a bit screwed or unprepared, we could still enjoyed it. We helped each other and laughed a lot during the game. Instead of getting closer to old friends, I also met some new friends. Han2 and Joni who are always cool. We2 who is always ‘crazy’. Yen Nee who is always fun. Wiliam and Steven who are the magicians and good in ‘liar card game’. Renny who is very open and to the point. And many unique friends that I can’t mention one by one. Overall I really had a great time and good friends in this easter camp. For all the guys who joined, hope your balls didn’t turn into raisin! 
 |
| From Others |
Oracle cheat sheet
- SQLPlus short connection
sqlplus <username>/<password>@<ipAddress>:<port>/<sid> [@<scriptfile>]
Ex:
sqlplus user/pass@192.168.1.10:3267/MYDB @test.sql
- MySQL limit equivalent
Ex:
SELECT last_name FROM
(SELECT last_name, ROW_NUMBER() OVER (ORDER BY last_name) R FROM employees)
WHERE R BETWEEN 51 and 100;
Alternative:
select *
from ( select a.*, rownum rnum
from ( YOUR_QUERY_GOES_HERE -- including the order by ) a
where rownum <= MAX_ROWS )
where rnum >= MIN_ROWS;
Linux cheat sheet
- show disk usage: du
- show disk capacity: df
- search word from file inside directory:
find /start/dir -exec grep -q my_search_word {} \; -print
- search files with specific name inside directory (HP-Unix, maxdepth=1):
find . \( ! -name . -prune \) \( -name “*TEST1*.ps” -o -name “*TEST2*.ps” \) -mtime +30 -type f
find /parent/child \( ! -name child -prune \) \( -name “*TEST1*.ps” -o -name “*TEST2*.ps” \) -mtime +30 -type f
- display before+after line with matched specific pattern (Solaris):
nawk 'c-->0;$0~s{if(b)for(c=b+1;c>1;c--)print r[(NR-c+1)%b];print;c=a}b{r[NR%b]=$0}' b=2 a=1 s="SEARCH_STRING" <file_name>
- display running process command args (Solaris):
pargs -a <pid>
/usr/ucb/ps -lawwx