如果只是查询没有出现"未连接 到ORACLE"错误!
SELECT SEQ_BM_SIGNUPDETAILID.NEXTVAL,
'2006-2007-2' AS STIME,
A.COURSENO,
A.COURSENAME,
A.COURSENO AS CO
FROM (SELECT DISTINCT CJ.COURSENO, CJ.COURSENAME
FROM CJ_SCOREFINAL CJ
WHERE 1 = 1
AND CJ.GRADEYEAR IN (2003)
AND ((TRUNC(CJ.TOTALSCORE) < 100 AND TRUNC(CJ.TOTALSCORE) >= 60) OR
(CJ.TOTALSCORE IN (-42, -41, -31, -21, -11)))) A但是将查询的结果插入到另一个表里,就会出现这个错误~!!!!CREATE TABLE BM_SIGNUP_SELTEMPTAB11 AS
SELECT SEQ_BM_SIGNUPDETAILID.NEXTVAL,
'2006-2007-2' AS STIME,
A.COURSENO,
A.COURSENAME,
A.COURSENO AS CO
FROM (SELECT DISTINCT CJ.COURSENO, CJ.COURSENAME
FROM CJ_SCOREFINAL CJ
WHERE 1 = 1
AND CJ.GRADEYEAR IN (2003)
AND ((TRUNC(CJ.TOTALSCORE) < 100 AND TRUNC(CJ.TOTALSCORE) >= 60) OR
(CJ.TOTALSCORE IN (-42, -41, -31, -21, -11)))) A
SELECT SEQ_BM_SIGNUPDETAILID.NEXTVAL,
'2006-2007-2' AS STIME,
A.COURSENO,
A.COURSENAME,
A.COURSENO AS CO
FROM (SELECT DISTINCT CJ.COURSENO, CJ.COURSENAME
FROM CJ_SCOREFINAL CJ
WHERE 1 = 1
AND CJ.GRADEYEAR IN (2003)
AND ((TRUNC(CJ.TOTALSCORE) < 100 AND TRUNC(CJ.TOTALSCORE) >= 60) OR
(CJ.TOTALSCORE IN (-42, -41, -31, -21, -11)))) A但是将查询的结果插入到另一个表里,就会出现这个错误~!!!!CREATE TABLE BM_SIGNUP_SELTEMPTAB11 AS
SELECT SEQ_BM_SIGNUPDETAILID.NEXTVAL,
'2006-2007-2' AS STIME,
A.COURSENO,
A.COURSENAME,
A.COURSENO AS CO
FROM (SELECT DISTINCT CJ.COURSENO, CJ.COURSENAME
FROM CJ_SCOREFINAL CJ
WHERE 1 = 1
AND CJ.GRADEYEAR IN (2003)
AND ((TRUNC(CJ.TOTALSCORE) < 100 AND TRUNC(CJ.TOTALSCORE) >= 60) OR
(CJ.TOTALSCORE IN (-42, -41, -31, -21, -11)))) A
后面还要跟字段如 create table tablename
( id ,name) as
select ...............
我觉得问题在于create table BM_SIGNUP_SELTEMPTAB11 as + 与后面的select 语句配合。