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...
2014/02/10

How to convert year from Western to Chinese in Oracle? (在Oracle中如何將西元年轉民國年)

›
Requirement Assume we had a table which contains all work days, and recorded in CALENDAR_DATE column with date data type. According cus...
2014/02/07

Quick way to build prototypes - Moqups

›
Official site - https://moqups.com/home/ Moqups is a nifty HTML5 App used to create wireframes, mockups or UI concepts, prototypes dependi...
2014/01/15

2013-14 日本八天七夜

›
橫濱夜景 東京鐵塔 原宿街頭 皇居 吾妻橋夜景 東京天空樹 東京車站夜景 台場夜景 淺草寺 六本木夜景 六本木大蜘蛛
2014/01/09

Solution to ORA-00911(invalid character, 字元無效)

›
Problem As I would like to execute an insert SQL statement, it throws ORA-00911 error. After googling, it recommend to "remove the inv...
2013/12/24

Cannot Import Java Source Code via Astah Pro

›
Problem When I used Astah Pro to do import java code But it show the error which complain encoding issues: Solution As we do import...

An internal error occurred during: "Initializing Java Tooling" from Eclipse

›
Problem One day as I startup my eclipse it show the error as bellows: Solution Step1. Close Eclipse Step2. Go to your eclipse wor...
2013/12/05

How to pad a string with spaces when size of data is unknown in Microsoft SQL Server

›
Requirement When I select a character data with varchar(6) from Microsoft SQL Server.... And these data should have fixed length in rep...
2013/12/04

How to display column footer immediately without any spaces after details band

›
Problem This is my report design in iReport: Here is the Detail property and Column Footer property setting: But...as I generate ...