aaa

BEGIN;
UPDATE m_gen_tax_number
SET invoice_id = -99,
invoice_doc_type_id = -99,
invoice_doc_no = '',
invoice_doc_date = '',
version = 0,
update_user_id = -3,
update_datetime = to_char(NOW(), 'YYYYMMDDHH24MIss')
WHERE  tenant_id = 10
AND tax_no = '007-21.40684275';

SELECT * FROM m_gen_tax_number WHERE  tenant_id = 10
AND tax_no = '007-21.40684275';
--rollback