/* web.common.insertFileInfo */ INSERT INTO FILE_INFO ( FILE_SEQ , FILE_NO , FILE_SIZE , FILE_TYPE , ORIGINAL_FILE_NAME , FILE_NAME , FILE_PATH , REG_USER , REG_DATE , LAST_DATE ) VALUES ( #{file_seq} , (SELECT COALESCE(MAX(FILE_NO),0)+1 FROM FILE_INFO WHERE FILE_SEQ = #{file_seq}) , #{file_size} , #{file_type} , #{original_file_name} , #{file_name} , #{file_path} , #{user_id} , TO_CHAR(NOW(), 'YYYYMMDDHH24MISS') , TO_CHAR(NOW(), 'YYYYMMDDHH24MISS') )