Nice smile ok
and can we control which columns from explain plan should be displayed in this command window? In a SQL Window, we can press the Settings button and add what information we want.. but in the explain plan above, how can control which information to appear?

One more thing, to the developer: it would great if we would have a parameter, which we set to ON, and after issuing a query, the query plan is automatically displayed (without we issuing "select * from table (......."

And also, why AUTOTRACE cannot be set in PL/SQL Developer, like in the following example (SQL*Plus):

[quote]
SQL> set autotrace on

SQL> select * from dual;



D

-

X


Execution Plan

----------------------------------------------------------

Plan hash value: 272002086



--------------------------------------------------------------------------

| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |

--------------------------------------------------------------------------

| 0 | SELECT STATEMENT | | 1 | 2 | 2 (0)| 00:00:01 |

| 1 | TABLE ACCESS FULL| DUAL | 1 | 2 | 2 (0)| 00:00:01 |

--------------------------------------------------------------------------


Statistics

----------------------------------------------------------

5 recursive calls

0 db block gets

5 consistent gets

3 physical reads

0 redo size

331 bytes sent via SQL*Net to client

337 bytes received via SQL*Net from client

2 SQL*Net roundtrips to/from client

0 sorts (memory)

0 sorts (disk)

1 rows processed



SQL> set autotrace off [/quote]

In PL/SQL Developer we get "Cannot set AUTOTRACE"

Thanks.