是否可以用子查询创建临时表
create global temporary table t_emp(empno,ename,sal,deptno)
as
(select empno,ename,sal,deptno from emp)
on commit delete rows;
这个语句错了,怎么改。
create global temporary table t_emp(empno,ename,sal,deptno)
as
(select empno,ename,sal,deptno from emp)
on commit delete rows;
这个语句错了,怎么改。
as
select empno,ename,sal,deptno from emp;