oracle 查询语句
CREATE PROCEDURE SP_ClassGradeQuery
(TeachingYearId in char(2) ,classid in char(7))
as
begin
begin
select Tb_Student.stuid ,stuName ,sum(Tb_Course.CourseGrade)as 应获总学分
from Tb_Grade,Tb_Student ,Tb_Course
where Tb_Student.stuid = Tb_Grade.stuid and Tb_Grade.CourseId=Tb_Course.CourseId and tb_grade.classid =classid and tb_grade.TeachingYearId=TeachingYearId
group by Tb_Student.stuid ,stuName
end
select Tb_Student.stuid ,stuName ,sum(Tb_Course.CourseGrade)as 已学分
from Tb_Grade,Tb_Student ,Tb_Course
where Tb_Student.stuid = Tb_Grade.stuid and Tb_Grade.CourseId=Tb_Course.CourseId
and (CommonScore*0.1+MiddleScore*0.2+LastScore*0.7)>60 and tb_grade.classid =classid and tb_grade.TeachingYearId=TeachingYearId
group by Tb_Student.stuid ,stuName
end
我想查询出的结果是：StuId，StuName，已获总学分，应获总学分，获取比例
这要怎么做呢?我只会放开写，请哪位帮我一下，先谢谢了
SQL code:
CREATE PROCEDURE SP_ClassGradeQuery(i_TeachingYearId IN CHAR(2),
i_classid IN CHAR(7),
o_ref OUT SYS_REFCURSOR) AS
BEGIN
--返回游标
OPEN o_ref FOR
SELECT stuid,
stuName,
CG AS 已获学分,
totoalCG AS 应获总学分,
相关问答：
我是在toad中输入下段sql
declare
TYPE test_rec IS record(
code varchar(10),
name varchar(30)
);
v_book test_rec;
......
oracle 11g 安装 01092 错误,
日志信息：
[oracle@linux trace]$ vi alert_orcl.log
MMON started with pid=14, OS id=9089
RESETLOGS after incomplete recovery UNTIL CHANGE 522752
Errors in file / ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001'
上面一个简单的SQL,执行时间2.6� ......
本人现在学oracle 算是刚刚入一半门 以后还要学java 各位大侠oracle好入手还是java好入手啊 以后那个方面发展会好些
，我暂时有个想法想好好学习一下数据库以后往这方便发展，毕竟数据库跟新换代没有java那么快，不 ......
看到有一个SUN的元老从Oracle公司辞职，而且是Java创始人——大名鼎鼎的James Gosling，
心中相当受打击！很悲痛！
Orable这是怎么了，难道这就是所谓的融合（肢解，分化，消失）吗？
SUN的一帮老员工� ......
