單引號的轉義

sql='SELECT * FROM lothistory WHERE lotname=''A41H-060-00BD5'''

結果：
SELECT * FROM lothistory WHERE lotname='A41H-060-00BD5'

PL/SQL里，'' 是單個 '
-----------------------------------------
select '''' from dual
結果：
'
select '''sss''' from dual
結果：
'sss'

BULK COLLECT INTO子句会批量检索结果，即一次性将结果集绑定到一个集合变量中

如;
--定義多行單列 集合變量類型
TYPE productnamelist IS TABLE OF product.productname%TYPE;
TYPE lotnamelist IS TABLE OF lot.lotname%TYPE;
TYPE rowidlist IS TABLE OF ROWID;  

--集合變量
delproducts        productnamelist;                                                                                   delproductrowids   rowidlist;
dellots            lotnamelist;                                                                                      dellotrowids       rowidlist;

--BULK COLLECT INTO語句
SELECT productname, originrowid  
BULK COLLECT INTO delproducts, delproductrowids
FROM temp_product;                                                                                                          
   COMMIT;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29564184/viewspace-1148076/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29564184/viewspace-1148076/