select rtrim ( lpad ( ' ', 2*level ) ||
rtrim ( operation ) || ' ' ||
rtrim ( options ) || ' ' ||
object_name || ' ' ||
partition_start || ' ' ||
partition_stop || ' ' ||
to_char ( partition_id )
) the_query_plan
from plan_table
connect by prior id = parent_id
start with id = 0;
rtrim ( operation ) || ' ' ||
rtrim ( options ) || ' ' ||
object_name || ' ' ||
partition_start || ' ' ||
partition_stop || ' ' ||
to_char ( partition_id )
) the_query_plan
from plan_table
connect by prior id = parent_id
start with id = 0;
解决方案 »
- 如何寫PROC去刪除文件
- 为什么PL/SQL DEVELOP运行不通过,在SQLPLUS中有可以运行通过呢?
- Oracle 10.0.2导出xml文档问题
- 低价转让 Oracle部分好书
- 怎样屏蔽query{ }后的显示?
- 菜鸟有问题:在一台机器上是否可以安装Client 和 Server
- 救命啊!100分
- xp下805默认装服务器,用sql连报no listener,只是想在本机上做实验
- ADOStoreProc控件调用procedure的错误?c++builder高手请进
- 求助Oracel安装问题
- windows下安装好oracle之后,应该做什么?
- 请教以下:网上有没有什么容易一点的oracle教程看?书店里面的oracle好书太少了:(
CREATE public synonym plan_table for sys.plan_table
grant all on plan_table to public
run sqlplus/admin/plustrce.sql
grant plustrce to public然后,你在PLUS中键入SET AUTOTRACE ON
就可以看到执行计划了