摘要:
set serveroutput ondeclare l_fee_xl number(18, 2);begin select nvl(西药费, 0) into l_fee_xl from tmp_zy_invoice_list_611; dbms_output.put_line(to_char(l_... 阅读全文
摘要:
CREATE GLOBAL TEMPORARY TABLE tmp_table_name ON COMMIT PRESERVE ROWS as select * from table_name; 阅读全文