条条道路通罗马:不行你就用dbsm_sql包吧.
解决方案 »
- 命令提示符下的小问题
- 存储过程返回结果集
- 高难度问题,字段中含有特性符号%,like条件中怎么用特殊符号%查询,好难呀????
- plsql下如何导出生产库里的所有用户/表空间/dblink的创建脚本(oracle)?
- 不小心批量删了数据而且commit了......想恢复怎么办......
- 关于ORACLE在线讲座的问题,请参加过的人告诉一声。
- 彻底删除数据
- oracle如何处理大量实时(如移动短信)的数据?--请高手进来!---在线讨论!!!!!
- 怎样加载Oracle8i的ManagerServer
- 用in和用exists的区别,看《sql必知必会》时遇到的问题,请教两个查询为何结果不同,第二个查询错在哪儿?
- 隐式游标的问题?(参与有分)
- 请高手指点!!
ORA-06550: line 2, column 41:
PLS-00103: Encountered the symbol ";" when expecting one of the following:
not null index
ORA-06550: line 3, column 43:
PLS-00103: Encountered the symbol ";" when expecting one of the following:
not null index
ORA-06550: line 4, column 29:
PLS-00103: Encountered the symbol ")" when expecting one of the following:
( - + mod not null others <an identifier>
<a double-quoted delimited-identifier> <a bind variable>
<a number> etc.
The symbol "+" was substituted for ")"
ORA-06550: line 5, column 35:
PLS-00103: Encountered the symbol ")" when expecting one of the following:
( - + mod not null others <an identifier>
<a double-quoted delimited-identifier> <a bind variable>
<a number> etc.
The symbol "+" was substituted for ")"
ORA-06550: line 11, column 13:
PLS-00103: Encountered the symbol "IMMEDIATE" when expecting one of the
following:
:= . ( @ % ;
哇,那么多错。
Bulk Fetching
The following example shows that you can bulk-fetch from a cursor into one or more collections: DECLARE
TYPE NameTab IS TABLE OF emp.ename%TYPE;
TYPE SalTab IS TABLE OF emp.sal%TYPE;
names NameTab;
sals SalTab;
CURSOR c1 IS SELECT ename, sal FROM emp WHERE sal > 1000;
BEGIN
OPEN c1;
FETCH c1 BULK COLLECT INTO names, sals;
...
END;