(SELECT COUNT(*) AS n, classname
FROM classInfo AS c1
GROUP BY classname)
INTO t 这种写法报错
FROM classInfo AS c1
GROUP BY classname)
INTO t 这种写法报错
解决方案 »
- ora-00913 : 值太多
- 创建表提示datetime无效数据类型
- oracle中QUEST_PPCM_SQL_TEXT这个表是干嘛用的
- oracle中怎样取得表a中字段的个数? 急急!!
- 想学Oracle,请大家推荐一本入门的电子书,最好从图形界面进入的,谢谢!
- *****关于pro c *******
- oracle查询语句中的取位问题
- 如何写过程
- vs 2012 连接数据库时出现的错误:尝试加载 Oracle 客户端库时引发 BadImageFormatException。如果在安装 32 位 Oracl
- oracle 32位如何从R1升级到R2,求补丁和具体步骤。谢谢!!
- oracle 10g 求自动增加字段SQL语句
- 求把UNION ALL 的SQL语句改得高效些
FROM (SELECT COUNT(*) AS n, classname
FROM classInfo AS c1
GROUP BY classname)
INTO t
SELECT *
FROM (SELECT COUNT(*) AS n, classname
FROM classInfo AS c1
GROUP BY classname)
应该
create table t2 as (SELECT COUNT(*) AS n, classname
FROM classInfo AS c1
GROUP BY classname)