dss
来源:互联网 发布:淘宝评论不能上传图片 编辑:程序博客网 时间:2024/05/22 14:20
DECLARE
l_tablen BINARY_INTEGER;
l_tab DBMS_UTILITY.uncl_array;
CURSOR cur
IS
SELECT 'word1, word2, word3, word4, word5, word6' val FROM dual;
rec cur%rowtype;
BEGIN
OPEN cur;
LOOP
FETCH cur INTO rec;
EXIT
WHEN cur%notfound;
DBMS_UTILITY.comma_to_table (
list => rec.val, tablen => l_tablen, tab => l_tab);
FOR i IN 1 .. l_tablen
LOOP
DBMS_OUTPUT.put_line(i || ' : ' || trim(l_tab(i)));
END LOOP;
END LOOP;
CLOSE cur;
END;
l_tablen BINARY_INTEGER;
l_tab DBMS_UTILITY.uncl_array;
CURSOR cur
IS
SELECT 'word1, word2, word3, word4, word5, word6' val FROM dual;
rec cur%rowtype;
BEGIN
OPEN cur;
LOOP
FETCH cur INTO rec;
EXIT
WHEN cur%notfound;
DBMS_UTILITY.comma_to_table (
list => rec.val, tablen => l_tablen, tab => l_tab);
FOR i IN 1 .. l_tablen
LOOP
DBMS_OUTPUT.put_line(i || ' : ' || trim(l_tab(i)));
END LOOP;
END LOOP;
CLOSE cur;
END;
0 0
- dss
- DSS
- DSS
- DSS
- DSS
- DSS
- DSS
- DSS
- dss
- 关于DSS
- 什么是DSS
- DSS OLTP
- DSS Architecture
- DSS Modules
- DSS RUDP
- DSS 解释
- 决策支持系统(DSS)
- DSS-1 Message Flow
- 微信小程序--菜谱列表+手机吉凶查询
- MYSQL索引无效和索引有效的详细介绍
- React(5)--事件处理
- oracle 存储过程
- FragmentTabhost和viewPager一起使用会出现的小bug及解决方案
- dss
- aaa
- android中Theme主题的理解
- aaad
- Python新路程(5)Python 运算符
- Python新路程(6)Python 条件语句
- OpenGL.Project2.Bezier Curve
- swing包下常用组件
- Logistic 逻辑回归(PySpark)