舊山線鐵道自行車
龍騰斷橋
蓬萊溪護魚步道
2020/08/31
2020/08/10
[Windows] How to specify multi-line command on command prompt?
Problem
Here is my original command to generate database schema document:
If I would like to break it into multiple line, how to do it?
How-To
Add ^ in the end of each line, the updated command is as following:
Here is my original command to generate database schema document:
java -jar "C:\schemaspy\schemaSpy_5.0.0.jar" -dp "C:\schemaspy\ojdbc6.jar" -t orathin -db TEST -s ap_tax -host localhost -port 1521 -u system -p password -schemas "ODS,TS" -charset UTF-8 -o "C:\schemaspy\schema_doc" -norows -hq -css "C:\schemaspy\schemaSpy.css"
If I would like to break it into multiple line, how to do it?
How-To
Add ^ in the end of each line, the updated command is as following:
java -jar "C:\schemaspy\schemaSpy_5.0.0.jar" ^ -dp "C:\schemaspy\ojdbc6.jar" ^ -t orathin ^ -db TEST ^ -s ap_tax ^ -host localhost ^ -port 1521 ^ -u system ^ -p password ^ -schemas "ODS,TS" ^ -charset UTF-8 ^ -o "C:\schemaspy\schema_doc" ^ -norows -hq -css "C:\schemaspy\schemaSpy.css" ^
2020/08/09
[Oracle] CASE Statement example
Requirement
以下是用來將幣別轉換為代號的邏輯
case 幣別when 'NTD' then '01'when 'USD' then '51'when 'HKD' then '52'when 'JPY' then '53'
Example
以下是使用 CASE Statement 的範例
FUNCTION FN_GET_CCY_CODE (i_ccy IN VARCHAR2) RETURN VARCHAR2 IS o_ccy_code VARCHAR2(2) := ''; BEGIN CASE i_ccy WHEN 'NTD' THEN o_ccy_code := '01'; WHEN 'USD' THEN o_ccy_code := '51'; WHEN 'HKD' THEN o_ccy_code := '52'; WHEN 'JPY' THEN o_ccy_code := '53'; END CASE; RETURN o_ccy_code; END FN_GET_CCY_CODE;
2020/08/08
[Java] [Apache Freemarker] 如何在 ftl 做設定，印製年、月、日，且年份採用民國年
Requirement
假設我希望在輸出結果檔，印製年、月、日，且年份採用民國年，該如何在 ftl 做設定？
How-To
ftl 的 code snippet 如下：
Reference
[1] https://freemarker.apache.org/docs/ref_builtins_date.html
假設我希望在輸出結果檔，印製年、月、日，且年份採用民國年，該如何在 ftl 做設定？
How-To
ftl 的 code snippet 如下：
<#-- 取得現在時間 --> <#assign aDateTime = .now> <#-- 只保留日期 --> <#assign aDate = aDateTime?date> <#-- 取出日期中的年份、轉數字，減去 1911 得到民國年 --> 列印年：${aDate?string.YYYY?number - 1911} <#-- 取出日期中的月份 --> 列印月：${aDate?string.MM} <#-- 取出日期中的日期 --> 列印日：${aDate?string.dd}
Reference
[1] https://freemarker.apache.org/docs/ref_builtins_date.html
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 Path>\ide\bin, open ide.conf
2. Add AddVMOption -Duser.language=en in the end of ide.conf
3. Relaunch Oracle SQL Developer
Reference
[1] https://stackoverflow.com/a/30396125
How to change language from Transitional Chinese to English in Oracle SQL Developer?
How-To
1. Go to C:\<SQLDeveloper Path>\ide\bin, open ide.conf
2. Add AddVMOption -Duser.language=en in the end of ide.conf
3. Relaunch Oracle SQL Developer
Reference
[1] https://stackoverflow.com/a/30396125
2020/08/06
[Oracle] ORA-02287: sequence number not allowed here
Problem
Assume I create a sequence as bellows:
As I try to get the next sequence value in my select statement, I get ORA-02287 error
How-To
1. create a function to get the next sequence
2. select value from function
Reference
Uses and Restrictions of NEXTVAL and CURRVAL
Assume I create a sequence as bellows:
create sequence seq_test start with 1 increment by 1;
As I try to get the next sequence value in my select statement, I get ORA-02287 error
select (select lpad(to_char(seq_test.NEXTVAL), 4, '0') from dual) as seq, ......... from ............ where .........
How-To
1. create a function to get the next sequence
FUNCTION FN_GET_NEXT_SEQ_VAL RETURN VARCHAR2 IS v_next_seq_val VARCHAR2(4) := ''; BEGIN select lpad(to_char(seq_test.NEXTVAL), 4, '0') into v_next_seq_val from dual; return v_next_seq_val; END FN_GET_NEXT_SEQ_VAL;
2. select value from function
select FN_GET_NEXT_SEQ_VAL() as seq, ......... from ............ where .........
Reference
Uses and Restrictions of NEXTVAL and CURRVAL
CURRVAL and NEXTVAL can be used in the following places:VALUESclause ofINSERTstatements- The
SELECTlist of aSELECTstatement - The
SETclause of anUPDATEstatement
CURRVAL and NEXTVAL cannot be used in these places:- A subquery
- A view query or materialized view query
- A
SELECTstatement with theDISTINCToperator - A
SELECTstatement with aGROUPBYorORDERBYclause - A
SELECTstatement that is combined with anotherSELECTstatement with theUNION,INTERSECT, orMINUSset operator - The
WHEREclause of aSELECTstatement DEFAULTvalue of a column in aCREATETABLEorALTERTABLEstatement- The condition of a
CHECKconstraint
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.
Result
You can assign a variable, added value in the loop, then print the value in the end.
<#assign total = 0> ${"水果名稱"?right_pad(10)}${"單價"?right_pad(5)}${"訂購數量"?right_pad(10)} ${"-"?right_pad(25, "-")} <#list rows as row> <#assign total += row.price * row.quantity> ${row.name?right_pad(10)}${row.price?left_pad(5)}${row.quantity?left_pad(10)} </#list> ${"-"?right_pad(25, "-")} 總筆數：${rows?size?left_pad(10)} 總金額：${total?left_pad(10)}
Result
水果名稱 單價 訂購數量 ------------------------- apple 50 20 avocado 60 2 banana 70 1 cherry 80 10 coconut 90 1 durian 100 3 ------------------------- 總筆數： 6 總金額： 2,380
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:
Result
You can make good use of size to count list size as bellowing:
<#assign total = 0> ${"水果名稱"?right_pad(10)}${"單價"?right_pad(5)}${"訂購數量"?right_pad(10)} ${"-"?right_pad(25, "-")} <#list rows as row> <#assign total += row.price * row.quantity> ${row.name?right_pad(10)}${row.price?left_pad(5)}${row.quantity?left_pad(10)} </#list> ${"-"?right_pad(25, "-")} 總筆數：${rows?size?left_pad(10)} 總金額：${total?left_pad(10)}
Result
水果名稱 單價 訂購數量 ------------------------- apple 50 20 avocado 60 2 banana 70 1 cherry 80 10 coconut 90 1 durian 100 3 ------------------------- 總筆數： 6 總金額： 2,380
2020/08/03
[Mac] [VMware Fusion] Keyboard 錯亂
Problem
由於我的 VM 有時候會接上 Windows OS，有時候會接上 Mac OS。
當作業系統轉換時，複製、貼上、全選的按鈕有時候會轉換失敗，例如在 Mac 系統，打開 Windows 10 VM，若要做全選，Mac 應該是 command + A：
但是不知道什麼原因，必須用 control + A：
操作的不一致性，讓使用上很困擾。
How-To
雖然不知道根本原因，透過以下步驟可以解決此問題，且不需重開虛擬機。
1. VMWare Fusion => Virtual Machine => Settings
2. 點選 Keyboard & Mouse
3. 點選 Profile => Make Default Profile
由於我的 VM 有時候會接上 Windows OS，有時候會接上 Mac OS。
當作業系統轉換時，複製、貼上、全選的按鈕有時候會轉換失敗，例如在 Mac 系統，打開 Windows 10 VM，若要做全選，Mac 應該是 command + A：
但是不知道什麼原因，必須用 control + A：
操作的不一致性，讓使用上很困擾。
How-To
雖然不知道根本原因，透過以下步驟可以解決此問題，且不需重開虛擬機。
1. VMWare Fusion => Virtual Machine => Settings
2. 點選 Keyboard & Mouse
3. 點選 Profile => Make Default Profile
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:
I used schemaspy-6.1.0 and graphviz-2.38.
How-To
The root cause is uncertain, but this problem can be resolved by adding
Reference
[1] https://github.com/schemaspy/schemaspy/issues/616
When I try to generate schema document via SchemaSpy, I got the following error message:
Catalog (-cat) was not provided and unable to deduce catalog, wildcard catalog can be used -cat %
I used schemaspy-6.1.0 and graphviz-2.38.
How-To
The root cause is uncertain, but this problem can be resolved by adding
-cat "%" in your command line.Reference
[1] https://github.com/schemaspy/schemaspy/issues/616
2020/08/01
[IntelliJ] Shortcut to upper case
Problem
Assume I have an insert sql statement as bellows:
If I would like to convert SQL reserved words to upper case as bellows:
Any shortcut to fulfill this requirement in IntelliJ?
How-To
Assume I have an insert sql statement as bellows:
insert into test (...) values (...);
If I would like to convert SQL reserved words to upper case as bellows:
INSERT INTO test (...) VALUES (...);
Any shortcut to fulfill this requirement in IntelliJ?
How-To
2020/07/31
2020/07/30
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:
I got this error message from SQL Developer:
How-To
This error message resulted from the missing length in variable declaration, it should be fixed as following:
When I tried to create a stored procedure package as bellows:
CREATE OR REPLACE PACKAGE PG_TEST_001 AS v_last2Month VARCHAR2 := ''; PROCEDURE SP_Get_LAST2MONTH(i_dataId IN VARCHAR2, o_last2Month OUT VARCHAR2); END PG_TEST_001; /
I got this error message from SQL Developer:
PLS-00215: String length constraints must be in range
How-To
This error message resulted from the missing length in variable declaration, it should be fixed as following:
CREATE OR REPLACE PACKAGE PG_TEST_001 AS v_last2Month VARCHAR2(8) := ''; PROCEDURE SP_Get_LAST2MONTH(i_dataId IN VARCHAR2, o_last2Month OUT VARCHAR2); END PG_TEST_001; /
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:
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 java.io.IOException; import java.nio.charset.Charset; import java.nio.file.Files; import java.nio.file.Paths; import java.util.stream.Stream; .... pubilc void readAndPrintContent(String file) throws IOException { try (Stream<String> stream = Files.lines(Paths.get(file), Charset.forName("Cp937"))) { stream.forEach(log::debug); } catch (IOException e) { throw new IOException("fail to read file, error : " + e.getMessage(), e); } } |
2020/07/08
[Oracle] Retrieving JSON in Oracle
Problem
Assume I would like to select a CLOB column with JSON value, it looks like:
How to select test_no value (i.e. "9999") in Oracle?
How-To
Using JSON_VALUE to fulfill this requirement:
Reference
https://www.red-gate.com/simple-talk/sql/oracle/json-for-absolute-beginners-part-4-retrieving-json-in-oracle/
Assume I would like to select a CLOB column with JSON value, it looks like:
{
"test_no":"9999",
"year":"0108",
"registerDate":"20191031"
}
How to select test_no value (i.e. "9999") in Oracle?
How-To
Using JSON_VALUE to fulfill this requirement:
SELECT JSON_VALUE(JSON_COLUMN, '$.test_no' RETURNING VARCHAR2) FROM test_table
Reference
https://www.red-gate.com/simple-talk/sql/oracle/json-for-absolute-beginners-part-4-retrieving-json-in-oracle/
2020/07/07
[閱讀筆記] 窮查理的普通常識 (7/7)
- 人們往往沒有認知到，人世間大多數結果都是不公平的，而且道德規範有時候必須不公平，才能取得最好的效果。過於追求公平，會給社會制度帶來嚴重的功能障礙。容忍對某些人有一點不公平，以便對所以人更公平，是我向你們所有人推薦的模式。
- 凱因斯：大致的正確好過精準的錯誤 (Better roughly right than precisely wrong.)。
- 無論你們多聰明，總有一些更聰明的人，如果他們真的想騙你，你就會上當。因此，要確定與你們共事的聰明人是值得信賴的。
- 蒙格的普通常識
- 人類社會只有發明了發明的方法之後才能進步，同理，我們只有學會了學習的方法才能進步。
- 在追求知識的過程中，有兩種思維習慣對我影響很大：
- 我們總是老得太快，聰明得太慢。
- 認知往往取決於情境，所以不同的情境通常會引起不同的結論，哪怕是同一個人在思考同一個問題是也是如此。
- 人類誤判的 25 個傾向
- 基金管理系統要求裡專門假裝去做他們做不了的事情，假裝喜歡他們不喜歡的事情。這種生活方式很可怕，卻能拿到很高的薪水。
- 避免因為過去的成功經驗而做出蠢事的破解對策是：
- 波斯使者症候群，這個詞的由來是因為以前古代波斯人會以殺掉使者，來避免壞消息上傳的方法。在很多行業裡，傳遞壞消息的人真的很危險。有時律師知道，如果建議一種不受歡迎卻明智的解決方案，會招致客戶怨恨，所以他們繼續把官司打下去，乃至造成災難性後果。要避免類似下場，正確的對策是：有意識地養成歡迎壞消息的習慣。在Munger自己的波克夏公司裡有一條普遍的規矩：「有壞消息要立刻彙報；只有好消息是可以等待的。」還有就是要保持明智和消息靈通，讓人們知道你有可能從別處聽到壞消息，這樣他們就不敢隱瞞了。
- 托爾斯泰效應：人不會去改變自己，只會為自己的表現找藉口。絕大多數人都會找太多荒唐的理由，試圖讓自己心安理得。組織想要化解「托爾斯泰效應」的對策是：
- 成功投資的關鍵因素之一，就是擁有良好的性格。多數人總是按耐不住，或者總是擔心過度。成功意味著要非常有耐心，又能在知道該採取行動時，主動出擊。只要從失敗的經驗中學習，當你汲取教訓的來源越廣，就能變得更好。
- 社會認同傾向 (Social-Proof Tendency) 可以運用於子女管教。在學的子女，最尊重的是同儕，而不是父母或其他成年人，這種現象主要是由年輕人的基因決定。所以對父母來說，與其對子女耳提面命，不如控制子女朋友的品質，才是明智的作法。
- 易取得性傾向的解決方式與運用方法
- 晚年的最佳保護鎧甲，是一段在老之前被好好地度過生活；一段被用於追求有益知識、光榮功績和高尚品德的生活；過這種生活的人從年輕時就致力於提升自己，並且在其晚年收割最幸福的果實；這不僅是因為有益的知識、光榮的功績和高尚的品德將陪伴他們終生，直到生命最後一刻，也因為它見證了人生的良心和對美好成就的回憶，將會給靈魂帶來無比的安慰。
- 富蘭克林曾說：我們總是太快變老，太慢變聰明；等到你不必再修正時，也差不不多玩完了。
- 巴菲特曾說過：查理蒙格給他最重要的人生禮物 － 戒貪、勇氣和遠見。
- 馬爾薩斯 (Malthus) 陷阱,又稱為「馬爾薩斯災難」，以政治經濟學家托馬斯·羅伯特·馬爾薩斯命名，認為對大部分人類歷史來說，收入停滯的原因是因為技術的進步與發現僅僅造成人口的增加而沒有提高人類的生活水平。只是在1800年左右開始的工業革命才使得一些國家的人均收入大幅增加，同時他們也跳出陷阱。例如過去的中國，人口過多導致每個人只能求溫飽，沒有多餘的能量，加上政府施政不彰、自以為是、坐井觀天，一旦中國跳脫愚蠢的政治體系後，就能跳脫馬爾薩斯陷阱，開始有剩餘產出，前進的速度就會相當驚人。
- 有兩件事情讓投資變得困難
- Warren Buffett：「水管工人是有用的，而理財經理是沒有用的。」凱因斯認為，投資管理是下等行業，大多數投資管理者只會在股市你爭我奪，而那只是零和遊戲。
- 客觀的態度是很重要的，意味著做決定時，能不受情感、期望、恐懼、焦慮、自欺等所有純粹主觀因素的影響。
Subscribe to:
Posts (Atom)