How to enable order by effect of distinct in Oracle 10g db?

alter system set "_gby_hash_aggregation_enabled"=false sid='*';

How to check oracle database character set?

select *
from nls_database_parameters
where parameter = 'NLS_CHARACTERSET'

美股落底10指標(摘錄自聯合晚報)

1. 股市單日或連續兩天大跌(超過一成)
2. 美國財政部長換伏克爾
3. 通用汽車(GM)倒閉一百天
4. 金價飆到2000美元
5. 道瓊指數一次更換兩支成份股
6. 股市連續爆大量
7. 單月失業人口達百萬
8. 股市遇利空不跌
9. 熱門跌大跌
10. CNBC財經台停播
    

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.

Mimic the required column

Using color r100g100b70

 

Excel 中的Distinct

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

查到用這個方法, 還不錯

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

留在blog上, 以便以後自己查

大掃除最好用的是去污劑

昨天在家中大掃除, 地磚不是光滑, 相對容易積垢, 用浴室穩潔, 無效, 去霉劑, 無效, 洗碗精, 無效,

最有效的是黃色瓶子, 天工, 去污劑!!!

想想老祖先用的東西, 還真有效,

不過也跟它存在的形式有關啦, 它是粉狀的, 應該顆粒比較大,

跟地磚能夠磨擦, 當然也會比較容易弄乾淨囉,

提供給大家參考看看!