Oracle
文章平均质量分 55
iteye_2192
这个作者很懒,什么都没留下…
展开
-
从查询计划看Oracle连接查询性能误解
内连接: SQL/86 [code="java"]select * from products p, product_types pt where p.product_type_id = pt.product_type_id;[/code] SQL/92 [code="java"]select * from products p inner join product_types u...2010-04-13 22:58:05 · 94 阅读 · 0 评论 -
package global variable issue
ORA-04061: existing state of has been invalidated .session 1: Session_1>create package pck is 2 a number; 3 procedure print_a; 4 end pck; 5 / Package created. Session_1>c...原创 2011-02-27 16:20:04 · 146 阅读 · 0 评论