摘要:
隐式游标 sql游标 insert delete update select(返回单行记录的查询)引用游标类型 type stucursor is ref cursor;程序包和程序包体 create or replace package pname as procedure p1(b in var 阅读全文
摘要:
Select * From Z_course;Select * From Z_student;Select * From Z_stu_cour; --查询表中前五个同学的姓名,专业Select t.name,t.major,t.id,Rownum From z_student t Where Row 阅读全文
摘要:
Declare a Varchar2(20); b Number(10); c Number(10); m Number(5); sname Varchar2(20); nozero Exception; Begin a := '小明'; Dbms_Output.Put_Line(a); b := 3; c := 0; /* 循环 */ ... 阅读全文
摘要:
select * From student;select * From course ;select * From score;select * From teacher ;select * From grade ;-- 查询Student表中的所有记录的Sname、Ssex和Class列。Sele 阅读全文