不太懂。只是得到这个结果,楼上的视图多好。 如果只是简单生成一个表的话可以这样 或者想要知道过程怎么写的,可以看看下面代码。 create procedure p_test20141011 as begin excute immediate 'create table tbl_test20141011 nologging as SELECT MEMBER_ID , REGISTER_DATE,MEMBER_POSITION,MEMBER_CARD_ID FROM MENBER_INFO WHERE 1=2'; ---------创建一个空表 insert into tbl_test20141011 SELECT MEMBER_ID , REGISTER_DATE,MEMBER_POSITION,MEMBER_CARD_ID FROM MENBER_INFO WHERE MEMBER_CARD_ID IS NULL; ----向空表中插入需要数据 commit; end;
如果只是简单生成一个表的话可以这样
或者想要知道过程怎么写的,可以看看下面代码。
create procedure p_test20141011
as begin
excute immediate 'create table tbl_test20141011 nologging as
SELECT MEMBER_ID , REGISTER_DATE,MEMBER_POSITION,MEMBER_CARD_ID FROM MENBER_INFO WHERE
1=2'; ---------创建一个空表
insert into tbl_test20141011
SELECT MEMBER_ID , REGISTER_DATE,MEMBER_POSITION,MEMBER_CARD_ID FROM MENBER_INFO WHERE
MEMBER_CARD_ID IS NULL; ----向空表中插入需要数据
commit;
end;