Oracle – 使用 to_number 函數把 varchar 轉換至 int

當資料如果是數字但所儲存的 Column Type 為 varchar 時，當在排序如下所示：

image

那如要正確的排序時可以使用 to_number 這個函數來把 varchar 轉至 int 後才排序.

image

留言

張貼留言

這個網誌中的熱門文章

WPF - 窺探 Flow Diagram Designer 的設計

最近收到一個很好玩的 Requirement，提供 Data Sources, Charts, Filters 等組件可讓 User 隨意組合這些元件為一個 Flow 並執行取得結果, 這讓我回想到三年前 WPF 出來時在網路上看到有好心人士提供了其作法和 Source Code, 想不到現在有這 Requirement 需要它了, 真的是太感謝這些好心人士了，那在此記錄一下這些相關的文章, 以防之後還有類似的需求時, 好方便瀏覽. Part 1 – Drag, resize and rotate items on a canvas Part 2 – Toolbox, drag & drop, rubberband selection Part 3 – Connecting items Part 4 – Open/Save, Cut/Copy/Past/Delete and print
閱讀完整內容

WPF – Getting Started with MVVM

I've been working with MVVM and WPF for a couple of weeks now. I decided to log what I've learned here. Here goes a getting started tutorial with MVVM. Download the source code . The Model-View-ViewModel pattern was introduced by John Gossman to effectively utilize the functionality of WPF. Since then, MVVM has been used in a number of WPF applications with very impressive results. MVVM has three components: Model: It is your data or classes that represent entities in your application. It normally contains no WPF-specific code. View: This is the User Interface element visible to the user. Its DataContext is its ViewModel. ViewModel: It contains all the data that needs to be displayed and procedures to modify the model at will. The magic about MVVM is that the ViewModel knows nothing about the View. You see that this is very loosely coupled. The View knows the ViewModel but the ViewModel does not know the View. You can very easily replace the View without affecting t...
閱讀完整內容

EasyUI – datebox 中如何自定日期格式化

在 datebox 中提供了二個 method ，一個為 formatter，另一個為 parser，這二個 method 是用來自定日期格式化的. formatter 是在顯示時如何選擇日期後將其格式化為所需的格式. parser 是在選擇好日期後告訴控件如何去解析自定義的格式. 將日期格式化為 yyyy-mm-dd 的格式如下所示： $('$dd').datebox({ formatter: function(date){ return date.getFullYear()+'-'+(date.getMonth()+1)+'-'+date.getDate(); }, parser: function(date){ return new Date(Date.parse(date.replace(/-/g,"/"))); } });
閱讀完整內容