select *
into #aaa
from ccc
where ...
创建临时表的语句在ORACLE中应该如何实现？
看了一下ORACLE的临时表，好像与SQL SERVER有很大不同。
我只要能达到如上的效果就行，寻找最简洁有效的方法。
CREATE GLOBAL TEMPORARY TABLE tmpAbilities
(
ABILITYID NUMBER(5),
ABILITYNAME NVARCHAR2(200) ,
ABILITYDEFINE NVARCHAR2(2000) ,
ACTIONDEFINE NVARCHAR2(2000) ,
USECHK NUMBER(1) ,
PREFESSIONALCHK NUMBER(1)
) ON COMMIT PRESERVE ROWS;
INSERT INTO tmpAbilities
SELECT a.*
from Abilities a
WHERE a.PrefessionalChk!=1
UNION
SELECT b.*
from AbilityStandards a
INNER JOIN Abilities b ON b.AbilityID=a.AbilityID AND b.PrefessionalChk=1
INNER JOIN Employees c ON c.PositionCode=a.PositionCode
INNER JOIN UserInfo d ON d.EmpID=c.EmpID
WHERE d.UserID='seahi'
ORDER BY 1;
SELECT a.*
,(SELECT MAX(x1.AbilityID) from tmpAbilities x1 WHERE x1.AbilityID <a.Abilityid) AS PrevAbili
