2014/08/28

[Oracle] How to Create Before Insert Trigger

›
Requirement Here has one of my table schema, and the first column, SEQ_NO, will be assigned serial number which value will be get from SE_F...
2014/08/27

ORA-17004 : Invalid Column Type

›
Problem I am using JPA(Java Persistence API) as my persistence tier technology to write data into Oracle database. Here is the database sch...
2014/08/22

Oracle : DBMS_OUTPUT

›
Requirement We would like to print debugging information from stored procedures, packages or triggers For example. We have an merge...
2014/08/18

Oracle Reserved Word: UID

›
Problem Assume we would like to retrieve information from UAA001V1 (Oracle database view). Here has its schema. We can utilize this...
2014/08/12

java.lang.ArithmeticException: Non-terminating decimal expansion; no exact representable decimal result

›
Problem As I execute the following code snippet public static void main(String args[]) { BigDecimal one = new BigDecimal(1); ...
2014/07/29

四項成功選股原則

›
筆記一下漫步華爾街一書提到的四項成功選股原則： 只購買至少維持五年盈餘成長超過平均的股票 可以到以下網站取得相關資訊:  http://goodinfo.tw/ 不購買股價高於合理價值的股票 透過本益比來判斷，目前價格是否超過其價值。作者不斷強調， 只要買進...
2014/07/27

2014/07 Travel

›
石碇千島湖 石碇雲海國小 基隆八斗子忘憂谷 基隆八斗子忘憂谷
2014/07/11

[iReport] How to format text style in text field

›
Requirement The first row in this report, the report name will be appended "總預算\n" before report name. And "總預算" should...

[iReport] How to apply conditional formatting to your text fields

›
Requirement In iReport, I wish to apply different formats to my text fields based on different conditions.  For instance, when "融資項目別...
2014/07/08

ORA-30926: unable to get a stable set of rows in the source tables when Merging tables

›
Problem When I executed the merge SQL statement in my web application MERGE INTO FMS434FB T1 USING ( SELECT ACCYR AS ACCYR , ...