Question:
Consider the following table
While seq is supposed to be a continous series of figures, this is not the case. How to detect the range of “holes” within the data?create table t ( seq int );
For example, assume t contain the following:
t
——-
1
2
6
8
The values indicating 3-5 and 7 should be returned.
The funny part in this question is that you need to return valuesoutside the data. But those data can be derived by the data easily
部新電腦買了不足三個月…中間更有一個月因為底板維修沒用過。即是說，實際用了不過兩個月
Boot windows 突然要檢查硬碟，之後發現有四個 bad sector，已經深感不妙（維修的話就要重裝。沒有 floppy drive，裝 windows 極為痛苦）。之後更恐怖的事發生了！！出現藍畫面，在未看清楚它說什麼時已經 reboot，試了幾次，終於看到有關訊息，原來 registry 壞了！！
手足無措之際，想有 windows 有個「last good」的選項，一試之下終於 boot 著了！
最迫切的問題已算初步解決，但仍要維修…唉…
I am going to migrate some data from 8i to 10g. Using export and import seems a reasonable choice. However, considering that there are 70GB of data. The time to unload and reload the data, and the temporary disk space to hold the dump file seems to be avoided.
So, Transportable Tablespace seems a good idea…
舊公司有個 project 要找我善後，今天去拿了隻 DVD
是一個 VMWare 的 Virtual Machine，共 6GB！！剛好 VMWare Server 早幾天正式推出，現正下載中，呵呵！！
唉，舊公司現在家附近（比地鐵站近），公司離家這樣近多好！！
拿了去維修差不多一個月，打電話罵過幾次，昨日終於取回
但不知何故，昨天每次把底皮放入機殼內，立即不能 boot 機，四時多才睡…
今日再接再厲，一切順利，重投闊別近一月的 windows 懷抱
希望佢以後生生性性，聽聽話話
為了環保或省錢而在買買電腦時沒選軟碟機，你會發現在即使普遍認為 windows 易裝易用，裝 windows 卻可以絕不簡單。這篇文章講述在絕望之時，如何出奇制勝。
（請注意，本文所述方法不可助你在 Intel Pentium D 8xx 系列 CPU 安裝 64-bit Windows）
Assuming you have just bought a new computer. Either for environment protection or for saving some money, you did not bought a floppy drive.
You soon find that even though Windows is always considered user-friendly, installing it into modern hardware but no floppy driver can be tricky.
| S | M | T | W | T | F | S |
|---|---|---|---|---|---|---|
| « Jul | Sep » | |||||
| 1 | 2 | |||||
| 3 | 4 | 5 | 6 | 7 | 8 | 9 |
| 10 | 11 | 12 | 13 | 14 | 15 | 16 |
| 17 | 18 | 19 | 20 | 21 | 22 | 23 |
| 24 | 25 | 26 | 27 | 28 | 29 | 30 |
| 31 | ||||||
(0)