2014/03/31

How to set Static IP Address from command line

›
Requirement Owing I need to move workplace from office to customer site lately, I need to change my laptop's IP address as I change  wo...

Bat(Batch) script 執行出現出現中文亂碼問題

›
Problem I edit a batch script which be used to set IP address netsh interface ipv4 set address name="區域連線" source=static address...
2014/03/27

投資的最高境界是「不交易」！

›
這篇文章不錯 [quote 1]「掌握波段，比殺進殺出要賺得多。」 [quote 2]大盤K值從高處滑落到20附近，就開始買，一路往下買，回彈到80以上，就一路往上賣。 [quote 3]「停損」當然是最重要的一招。 只要持股跌了10%到15%，就該執行停損，認賠出場。...
2014/03/25

How do I insert a record if it does not exist in Oracle?

›
Requirement Here has two report items as following: Each year has its own report items, ex. 102年度--未滿一年之短期融資, 103年度--未滿一年之短期融資, 102年度--...
2014/03/20

How to create a Boolean field in Oracle

›
Problem If we would like to create a field, it will store the information if this datum had create by external system or be added by manual...

How to set the width of modal dialog

›
Problem User claimed they do not want to see the scroll bar in the modal dialog. How do I set the width of dialog manually? Solut...
2014/03/13

Error: ng:areq Bad Argument

›
Problem I have a html page with 2 tabs. As I entered this page, it occurred javascript errors with "Error: ng:areq" and link ...
2014/03/12

ORACLE/PLSQL: ADD_MONTHS FUNCTION

›
Requirement If we would like to do month calculation in SQL, how to do it? Solution Oracle provided a build-in ADD_MONTHs function for u...
2014/03/05

How to resolve ORA-01790

›
Problem When I use UNION ALL syntax to union two select SQL statement, Oracle throw "ORA-01790 expression must have same datatype as c...
2014/02/28

2014/02 Travel

›
自由廣場
2014/02/27

Oracle: how to do insert if data doesn't exist

›
Here is my database schema: Requirement If we cannot find data via ROC_YM, primary key, in FMS415FA, then it should insert specific ROC...
2014/02/26

Oracle: how to UPSERT (Update or Insert)

›
Assume we have a requirement to read text file which sent by external system, and the UPSERT operation either updates or inserts a row in a ...
2014/02/21

Create Oracle Function

›
Here is a SQL statement: SELECT ROC_YM FROM FMS451FA The result is  Owning to client's requirement, we need to add slash bet...
2014/02/20

Online SQL Formatting Tool

›
In some situations, we may need to figure out the report bugs via extracting SQL statement from console or log file. But the SQL statement n...

常用JavaScript function整理

›
//取得今年民國年 function getCurrentYear(){ var date = new Date(); return date.getFullYear() - 1911; } //取得當下月份 functi...
2014/02/17

Oracle MERGE statement

›
If you would like to select rows from one or more sources for update or insertion into a table, you can make good use of MERGE statement.  ...
2014/02/14

2014 春節旅遊

›
嘉義-九華山地藏庵 光影旅行者《陳澄波百二互動展》嘉義展 (原來陳澄波也是228受難者) 日本皇居對照 嘉義市史蹟資料館 嘉義市植物園 隙頂二延平步道
2014/02/13

How to use UNPIVOT to Convert Columns into Rows

›
Here is our original data structure: We would like to turn columns into rows: Here is our original SQL statement: SELECT ROC_YM, ...
2014/02/11

Oracle Analytic functions

›
The general syntax of analytic function is: Function(arg1,..., argn) OVER ( [PARTITION BY <...>] [ORDER BY <....>] [ ] )  Th...