2020/08/31

[Travel] 202008 苗栗

›
 舊山線鐵道自行車 龍騰斷橋 蓬萊溪護魚步道
2020/08/10

[Windows] How to specify multi-line command on command prompt?

›
Problem Here is my original command to generate database schema document: java -jar "C:\schemaspy\schemaSpy_5.0.0.jar" -dp ...
2020/08/09

[Oracle] CASE Statement example

›
Requirement 以下是用來將幣別轉換為代號的邏輯 case 幣別   when 'NTD' then '01'   when 'USD' then '51'   when '...
2020/08/08

[Java] [Apache Freemarker] 如何在 ftl 做設定，印製年、月、日，且年份採用民國年

›
Requirement 假設我希望在輸出結果檔，印製年、月、日，且年份採用民國年，該如何在 ftl 做設定？ How-To ftl 的 code snippet 如下： <#-- 取得現在時間 --> <#assign aDateTime =...
2020/08/07

[Oracle] [SQL Developer] How to change language in Oracle SQLDeveloper?

›
Problem How to change language from Transitional Chinese to English in Oracle SQL Developer? How-To 1. Go to   C:\<SQLDeveloper Pa...
1 comment:
2020/08/06

[Oracle] ORA-02287: sequence number not allowed here

›
Problem Assume I create a sequence as bellows: create sequence seq_test start with 1 increment by 1 ; As I try to get t...
2020/08/05

[Java] [Apache Freemarker] How to compute total price in ftl ?

›
How-To You can assign a variable, added value in the loop, then print the value in the end. <#assign total = 0> ${"水果名稱...
2020/08/04

[Java] [Apache Freemarker] How to count list size in ftl ?

›
How-To You can make good use of size to count list size as bellowing: <#assign total = 0> ${"水果名稱"?right_pad(10)}${"...
2020/08/03

[Mac] [VMware Fusion] Keyboard 錯亂

›
Problem 由於我的 VM 有時候會接上 Windows OS，有時候會接上 Mac OS。 當作業系統轉換時，複製、貼上、全選的按鈕有時候會轉換失敗，例如在 Mac 系統，打開 Windows 10 VM，若要做全選，Mac 應該是 command + A： 但...
2020/08/02

[Oracle] [SchemaSpy] Catalog (-cat) was not provided and unable to deduce catalog, wildcard catalog can be used -cat %

›
Problem When I try to generate schema document via SchemaSpy, I got the following error message: Catalog (-cat) was not provided and una...
2020/08/01

[IntelliJ] Shortcut to upper case

›
Problem Assume I have an insert sql statement as bellows: insert into test (...) values (...); If I would like to convert SQL reserv...
2020/07/31

[Travel] 東北角

›
南子吝山
2020/07/30

[Travel] 台北書畫院與琴道館

›
台北書畫院 台北琴道館
2020/07/10

[Oracle] PLS-00215: String length constraints must be in range

›
Problem When I tried to create a stored procedure package as bellows: CREATE OR REPLACE PACKAGE PG_TEST_001 AS v_last2Month ...
2020/07/09

[Java] How to read file with encoding Cp937?

›
Problem How to read file with encoding Cp937? How-To Here has code snippet: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 import ja...
2020/07/08

[Oracle] Retrieving JSON in Oracle

›
Problem Assume I would like to select a CLOB column with JSON value, it looks like: { "test_no" : "9999" , "y...
2020/07/07

[閱讀筆記] 窮查理的普通常識 (7/7)

›
人們往往沒有認知到，人世間大多數結果都是不公平的，而且道德規範有時候必須不公平，才能取得最好的效果。過於追求公平，會給社會制度帶來嚴重的功能障礙。容忍對某些人有一點不公平，以便對所以人更公平，是我向你們所有人推薦的模式。 凱因斯：大致的正確好過精準的錯誤 (Better...