![](https://img-blog.csdnimg.cn/20201014180756757.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
plsql
Justplay0101
这个作者很懒,什么都没留下…
展开
-
plsql学习:dynamic SQL
[code="sql"]###############################################About native dynamic SQL## To improve the performance of dynamic SQL statements# you can also use BULK EXECUTE IMMEDIATE,# BULK F...原创 2011-12-13 00:09:50 · 149 阅读 · 0 评论 -
plsql学习:批量 SQL
[code="sql"]-- THE INDICES OF OPTION-- As stated previously, the INDICES OF option enables you to loop through a sparse collection.-- Recall that such a collection may be a nested table or an ...原创 2011-12-15 23:57:54 · 117 阅读 · 0 评论 -
常用SQL语句
查找数据库中所有字段 以对应的表select C.column_name,C.TABLE_NAME from dba_tab_columns C where owner=''查每个科目class 分数scro前三名select id, name, class, scro from (select row_number() over(partition by class o...原创 2011-12-23 13:50:09 · 137 阅读 · 0 评论 -
plsql学习:loop使用
[code="sql"]------example 1: loops with IF statement-----------set serveroutput ondeclare v_counter binary_integer := 0; begin loop --increment loop counter by one ...原创 2011-12-11 18:30:12 · 217 阅读 · 0 评论 -
plsql学习:cursor游标使用例子(1)
[code="sql"]--PL/SQL supports three kinds of records: table-based, cursor-based,and programmer-defined./** A table-based record is one whose structure is drawn from the list of columns in the...原创 2011-12-11 18:31:44 · 175 阅读 · 0 评论