谢谢。
这个我知道,我的意思是,在包中定义游标变量的语句就是这样吗?也就是说,在第二条语句中,TYPE/IS/REF,是否有其他写法及各代表什么意思。
这个我知道,我的意思是,在包中定义游标变量的语句就是这样吗?也就是说,在第二条语句中,TYPE/IS/REF,是否有其他写法及各代表什么意思。
解决方案 »
- 用PB如何导入*.TXT文件到ORACLE10g数据库???
- 如何控制portal的访问权限
- dbms_job.submit 中有关what的输入,多个参数的输入
- ★★★请问高手一个很简单的dateTime类型转化为字符串类型的问题!★★★
- 一个关于在存储过程中使用临时表的问题?
- 奇怪得问题,关于trim ,replace
- 请教各路神仙Oracle中有没有类似sign的函数,与sign不同的对于非正数统统返回0?
- oracle的连接
- order by问题!!!
- 关于数据库的连接问题!!!
- 想写一个修改字段数据类型的过程,可是出错,请高手指点,谢谢。
- 为什么asp.net连接oracle会显示乱码,而连接sqlserver就没事
TYPE ref_type_name IS REF CURSOR [RETURN return_type];
where ref_type_name is a type specifier used in subsequent declarations of
cursor variables and return_type must represent a record or a row in a database
table. In the following example, you specify a return type that represents a row in the database table dept:DECLARE
TYPE DeptCurTyp IS REF CURSOR RETURN dept%ROWTYPE;REF CURSOR types can be strong (restrictive) or weak (nonrestrictive). As the next
example shows, a strong REF CURSOR type definition specifies a return type, but a
weak definition does not:DECLARE
TYPE EmpCurTyp IS REF CURSOR RETURN emp%ROWTYPE; -- strong
TYPE GenericCurTyp IS REF CURSOR; -- weakStrong REF CURSOR types are less error prone because the PL/SQL compiler lets
you associate a strongly typed cursor variable only with type-compatible queries.
However, weak REF CURSOR types are more flexible because the compiler lets you
associate a weakly typed cursor variable with any query.
ref 我不太懂~~~ 楼上可否解释一下,是否相当于一个空的游标?
thanks!
Please read it!