Oracle-insert into加日期

方法一：新增欄位設定不為空且預設值為sysdate

方法二：在insert語句中加sysdate

insert into T_XZ_CASEINFO
  (case_id,
   case_no,
   case_type,
   casestate,
   cause_action,
   admin_area,
   caselocroadid,
   caselevel,
   case_source,
   unitid,
   deptid,
   case_time,
   checkdate,
   registdate,
   casefiledate,
   caseenddate,
   casesealdate,
   casecancledate,
   relatedcaseid,
   memo1,
   memo2,
   isbatchflag,
   ismodifyflag,
   caseuniquecode,
   ZHIDUI,
   LAOXITONG,
   DEFAULTTIME)
Values
  (:s,
   :s,
   :s,
   :s,
   :s,
   :s,
   :s,
   :s,
   :s,
   :s,
   :s,
   :s,
   :s,
   :s,
   :s,
   :s,
   :s,
   :s,
   :s,
   :s,
   :s,
   :s,
   :s,
   :s,
   2,
   1,
   sysdate)