cursor userRows is
0select * from t_user.
begin
for userRow in userRows loop
dbms_output.put_line
(userRow.Id|| , ||userRow.Name|| , ||userRows%rowcount).
end loop.
end pro_test_cursor.
示例2:
create or replace procedure
pro_test_cursor_oneRow(vid in number) is
userRow t_user%rowtype.
cursor userCur is
0select * from t_user where id=vid.
begin
open userCur.
fetch userCur into userRow.
if userCur%FOUND then
dbms_output.put_line
(userRow.id|| , ||userRow.Name).
end if.
close userCur.
end pro_test_cursor_oneRow.
record示例
create or replace
procedure pro_test_record(vid in varchar2) is
type userRow is record(
id t_user.id%type,
name t_user.name%type
).
realRow userRow.
begin
0select id,name into
realRow from t_user where id=vid.
dbms_output.put_line
(realRow.id|| , ||realRow.name).
end pro_test_record.
rowtype示例
create or replace procedure
pro_test_rowType(vid in varchar2) is
userRow t_user%Rowtype.
begin
0select * into userRow from t_user where id=vid.
dbms_output.put_line
(userRow.id|| , ||userRow.name).
end pro_test_rowType.
相关文章
拿什么来分析网络故障以及诊断网络性能[1]
拿什么来分析网络故障以及诊断网络性能[2]
项目管理案例:我的软件项目应该如何启动?
八个学习点帮助你全面认识Oracle数据库[1]
八个学习点帮助你全面认识Oracle数据库[2]
Oracle9i数据挖掘介绍[3]
Oracle9i数据挖掘介绍[2]
Oracle9i数据挖掘介绍[1]
2007年中级会计经济法考试答案
澳大利亚华人论坛
考好网
日本华人论坛
华人移民留学论坛
英国华人论坛