在达梦8中的存储过程中,要把查询到一个表里的所有数据并把查询到的数据存到临时表里SQL该怎么写啊已经创建好临时表了,
按照下面的这个SQL来改
select ID into temp01 from PDGXK.SGZ_CHK;
select id into temp01(临时表名) from PDGXK.SGZ_CHK(查询到的表)
回答 0
暂无回答
aandb
可以insert 临时表 select * from 数据表；
例如这样：
CREATE OR REPLACE PROCEDURE PRO_TEST
AS
V_SQL_I VARCHAR2(4000);
V_SQL_D VARCHAR2(4000);
BEGIN
V_SQL_I:= ‘INSERT INTO TEST SELECT * FROM SYSOBJECTS’;
EXECUTE IMMEDIATE V_SQL_I;
V_SQL_D:=‘SELECT * FROM TEST’;
EXECUTE IMMEDIATE V_SQL_D;
END;
可以insert 临时表 select * from 数据表；
例如这样：
CREATE OR REPLACE PROCEDURE PRO_TEST
AS
V_SQL_I VARCHAR2(4000);
V_SQL_D VARCHAR2(4000);
BEGIN
V_SQL_I:= ‘INSERT INTO TEST SELECT * FROM SYSOBJECTS’;
EXECUTE IMMEDIATE V_SQL_I;
V_SQL_D:=‘SELECT * FROM TEST’;
EXECUTE IMMEDIATE V_SQL_D;
END;
CALL PRO_TEST();