Posts by s1mple:
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 [...]
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 [...]
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 \( ! [...]