1 解决sql太长的问题
2
CREATE GLOBAL TEMPORARY TABLE tmp_a(
cuid VARCHAR2(400)
) ON COMMIT DELETE ROWS;
3 insert into...
4 查询
5 回话关闭后,临时表数据自动清空
2
CREATE GLOBAL TEMPORARY TABLE tmp_a(
cuid VARCHAR2(400)
) ON COMMIT DELETE ROWS;
3 insert into...
4 查询
5 回话关闭后,临时表数据自动清空