Archive for October 2008
mysql 一個特別的 delete command
delete tbl_item_fetch_img a
from tbl_item_fetch_img a,tbl_item b
where a.hid = b.hid and b.company = ‘CTC’
Oracle trigger sample
CREATE OR REPLACE TRIGGER SET_items_LSUPDATE
AFTER INSERT OR UPDATE
ON items_FILE REFERENCING NEW AS New OLD AS Old
FOR EACH ROW
DECLARE
OLDG_NO NUMBER(14);
BEGIN
SELECT COUNT(*) INTO OLDG_NO FROM BIDLEADER.items_LASTUPDATE WHERE G_NO=:Old.G_NO;
IF OLDG_NO >= 1 THEN
UPDATE BIDLEADER.items_LASTUPDATE SET G_LASTUPDATE=SYSDATE WHERE G_NO=:Old.G_NO;
ELSIF OLDG_NO=0 THEN
INSERT INTO BIDLEADER.items_LASTUPDATE VALUES (:New.G_NO, SYSDATE);
END IF;
END SET_items_LSUPDATE;
敦化南路上的台灣欒樹
 |
為台灣特有樹種且名列世界十大名木之一。
台灣欒樹有個美麗的洋名，就叫做「台灣金雨樹」。 至於為何稱四色樹？因從滿株綠葉到開花時呈黃色，結果時又轉為紅褐色，直至蒴果乾枯成為褐色而掉落，共有四色，觀賞期特長，而稱之。本省到處都有栽植。 每年初秋開花時柔黃色的圓錐花簇密生樹頂，遠望就像金雨灑落。 —– 當台灣欒樹落葉的時節 , 開車經過, 路兩旁飛落下來的葉子就像下雨一般 , 細細碎碎的撒下在人行道上 , 美! |
linux / putty ssh tunnel setting
在 HOST A 下
# # ssh -D 8000 -C -N -f user@remote.monster.tw #
-D bind 一個 “dynamic” 的port ,
-C 壓縮 ,
-N 不執行任何 command ,
-f 背景執行,
在 HOST A 下 netstat -an | grep LIST 可以看到
tcp 0 0 127.0.0.1:8000 0.0.0.0:* LISTEN
若本機為 linux , dynanic 的連法:
ssh -NfD 8000 -p 2200 rimmon@safe.server.tw
– 在本機建立一個 port 8000 的 listen 透過 ssh 連到 safe.server.tw 的 ssh port 2200 去.
// ——
screen :
http://digitalpbk.blogspot.com/2009/05/ssh-proxy-windows-linux-orkut-bypass.html
bike : 板橋 to 新竹 / 73KM
2008, 10/5 , 氣溫 25度 , 天氣晴, 6點出發 , 到新竹時 9點多 , 騎乘時間 , 3小時20分 , 均速 22KM/HR , 碼錶距離 73KM, 中間休息2次 , 一次吃麵包 , 一次去 7-11 補水
以下是的 google earth 剪圖是用 HOLUX m-241配合 monster 寫的 KML2CSV service 簡化了一些休息點跟路上等紅燈的點 , 看起來 google map 在台1線的路網跟 GPS 定位點還蠻合得來的…
一步一步刻記憶 – 跑竹崙路 / 熊空 / 一百甲
從上次騎了這條路線 “2008.0824 獨騎三峽 109 縣道 竹崙 熊空” 後, 就打定主意要用跑的來一次, 於是今天一早就把這件願望解決了.
真的! 用跑的記憶比較深刻 , 而且這等陡坡, 用跑的還覺得比較輕鬆咧…. 這次有特別注意 aska 說的竹林 , 然後上山的路有3個比較陡的坡, 最陡的就是那個竹林.
路跑前輩說 , 冬天來跑會有霧整個山很美 , 五月後會比較悶 , 夏天他們跑完都在橋下沖涼, 這應該是最讚的享受呀!
今天氣溫24度, 晴 , 竹坑橋開始 , 上山 44分 , 下山 35分
上次用騎的上山 37分
下圖是 google earth 剪下來的 , 看起來 google map 在這邊的路網圖沒有對好 , 那個圈起來的附近有兩座橋, 竹坑橋是底下那一個.
Oracle 小筆記
– Create sequence
create sequence TEST_SQ
minvalue 1
maxvalue 9999999999
start with 21
increment by 1
cache 20;
select test_sq.nextval from dual
select test_sq.currval from dual
https://172.20.10.6:5500/em/console/logon/logon
https://172.20.10.6:5500/em/console/aboutApplication
sqlplus sysman/sysman
sqlplus sysman/oracle
sqlplus system@”(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=DB1)))”
lsnrctl status
sqlplus /nolog
emctl status
emctl start dbconsole
emctl stop dbconsole
/etc/init.d/vmware-tools status
/etc/init.d/vmware-tools
lsnrctl start
[oracle@localhost ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.4.0 – Production on Tue Sep 30 01:46:26 2008
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup;
ORACLE instance started.
Total System Global Area 314572800 bytes
Fixed Size 1267236 bytes
Variable Size 180357596 bytes
Database Buffers 130023424 bytes
Redo Buffers 2924544 bytes
Database mounted.
Database opened.
conn / as sysdba
shutdown immediate
emctl start dbconsole
Oracle Enterprise Manager
https://localhost:5500/em/console/aboutApplication
sqlplus /nolog
SQL*Plus: Release 10.2.0.3.0 – Production on Wed Oct 1 18:50:04 2008
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
SQL> conn scott/password@db1
UTF8 / BIG5 / PUTTY / SHELL / SCREEN 真難搞系列
因為工作上都要改成 UTF8 , 所以很多以前熟悉的工具都要作一番改變 , 於是順手記在這邊 , 免得又忘記了.
我的 .screenrc
caption always "%-Lw%{= BW}%50>%n%f* %t%{-}%+Lw%<"
bind b encoding big5 utf8
bind u encoding utf8 big5
我的 .bashrc
EDITOR="/usr/bin/vim"
我的 putty setting
[video] Pink Floyd – Comfortably Numb
[youtube]http://tw.youtube.com/watch?v=0wtiNzci1Wc[/youtube]
Hello.
Is there anybody in there?
Just nod if you can hear me.
Is there anyone home?
Come on, now.
I hear youre feeling down.
Well I can ease your pain,
Get you on your feet again.
Relax.
I need some information first.
Just the basic facts:
Can you show me where it hurts?
There is no pain, you are receding.
A distant ships smoke on the horizon.
You are only coming through in waves.
Your lips move but I cant hear what youre sayin.
When I was a child I had a fever.
My hands felt just like two balloons.
Now I got that feeling once again.
I cant explain, you would not understand.
This is not how I am.
I have become comfortably numb.
Ok.
Just a little pinprick. [ping]
Therell be no more –aaaaaahhhhh!
But you may feel a little sick.
Can you stand up?
I do believe its working. good.
Thatll keep you going for the show.
Come on its time to go.
There is no pain, you are receding.
A distant ships smoke on the horizon.
You are only coming through in waves.
Your lips move but I cant hear what youre sayin.
When I was a child I caught a fleeting glimpse,
Out of the corner of my eye.
I turned to look but it was gone.
I cannot put my finger on it now.
The child is grown, the dream is gone.
I have become comfortably numb.
