摘要： 1. execute DDL 2. we need to concatenate query about the table name and condition. we have three method to execute dynamic query 1.execute immediate 2 阅读全文

摘要： before : we use null and assign string value to CLOB object directly. but it will enter the performance issue to print the content in the loop: v_clob 阅读全文

摘要： SELECT dept.DEPARTMENT_CNAME, gcc.segment2 dept, fdh.ASSIGNED_TO_NAME full_name, fl.segment1 || '.' || fl.segment2, fa.ASSET_NUMBER, fa.description, fdh.UNITS_ASSIGNED, fb.date_placed_in_service, fdh.BOOK_TYPE_CODE, fai.invoice_number, fa.ATTRIBUTE_CATEGORY_CODE, fa.SERIAL_NUMBER, fa.TAG_NUM 阅读全文

摘要： 1.在Collection Plans中連接Collection Elements對應後臺qa_results.character欄位，是添加的先後順序排序的2.COPY elements注意後續添加的elements會插入到前面，導致copy后對應的qa_results.Character值變化。 阅读全文