PL/SQL
-
编辑 删除
Oracle Materialized view
Third party system has one table, we want to fetch new changeddata into one table.It means that the new table should contain all added data or deleted data or updated data. 1. Source systemCreate table xx_testCreate materialized log...
-
编辑 删除
ref cursor ,动态SQL
DECLARE<br /> TYPE ref_cursor IS REF CURSOR;<br /><br /> v_ref_cursor ref_cursor;<br /><br /> CURSOR cur_get_order IS<br /> SELECT organization_id,<br /> organization_code<br /> ...
