xstream_field_order 1. XMLSequence : annotation which will be used for TestXml class 2. TestXml : Class for xstream fields 3. PartialSeqFieldKeySorter: customize the sort fields, defined fields which you will display in XML import com.thoughtworks.xstream.converters.reflection.FieldKey; import com.thoughtworks.xstream.converters.reflection.FieldKeySorter; import com.thoughtworks.xstream.core.util.OrderRetainingMap; import java.lang.annotation.Annotation; import java.lang.reflect.Field; import java.util.LinkedHashMap; import java.util.Map; import java.util.Set; public class PartialSeqFieldKeySorter implements FieldKeySorter { […]
Read MoreChange blob to clob，vice versa in oracle
Conditions 1. blob not save too much content, and text 2. backup blob text to clob 3. oracle v11 blob to clob –Add new clob column ALTER TABLE TABLENAME ADD (CLOB_COLUMN CLOB); –copy blob value to clob UPDATE TABLENAME SET CLOB_COLUMN = UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(BLOB_COLUMN,2000)); –drop blob ALTER TABLE TABLENAME DROP COLUMN BLOB_COLUMN; –rename clob column, name […]
Read MoreApple script: Backup Mac Notes to PDFs
1. Open Notes and click folder you want to backup 2. Open script and copy content to Mac ScriptEditor and run, or choose scpt to run in ScriptEditor 3. Gen pdfs 4. OS: Catalina 10.15.X Can further modify based on it set cnt to 58 set i to 0 tell application “System Events” repeat cnt […]
Read More