OraFAQ Forum: Client Tools » display windows on OracleSQL Developer

Home » Other » Client Tools » display windows on OracleSQL Developer (Oracle SQL Developer)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

display windows on OracleSQL Developer [message #595350]

Tue, 10 September 2013 09:16

pourquoipastoi
Messages: 2
Registered: September 2013

Junior Member

Hello

Can you help me to find in the menu of Oracle SQL Developer how to display the result of explain plan for .. I have just "Succès de l'élément plan FOR". And i want the whole explanation.

Thanks

Attachment: oracle.jpg
(Size: 193.86KB, Downloaded 866 times)

Report message to a moderator

Re: display windows on OracleSQL Developer [message #595351 is a reply to message #595350]

Tue, 10 September 2013 09:20

cookiemonster
Messages: 13904
Registered: September 2008
Location: Rainy Manchester

Senior Member

I assume it's the same as sqlplus in this regard. After running the explain plan for command you need to run:

SELECT * FROM table(dbms_cplan.display);

There's probably another way of doing it that involves a button or menu item (don't have it installed to check) but that approach will not involve running the explain plan for command. It'll just involve highlighting an actual select and running the sql developer command.

Report message to a moderator

Re: display windows on OracleSQL Developer [message #595360 is a reply to message #595350]

Tue, 10 September 2013 10:37

thatjeffsmith
Messages: 81
Registered: July 2009
Location: Raleigh, NC

Member

If you're running scripts you'd do it just as you would in SQL*Plus.

If you want a plan for a query, just highlight said query, and hit the Explain button in the worksheet toolbar.

We've made a few enhancements to the explains in version 4, you can read about those here.

Report message to a moderator

Re: display windows on OracleSQL Developer [message #595443 is a reply to message #595360]

Wed, 11 September 2013 05:19

pourquoipastoi
Messages: 2
Registered: September 2013

Junior Member

thanks

Report message to a moderator

Previous Topic:	how to convert SQL server stored procedures to Oracle 11g
Next Topic:	How to Open PL/SQL DEVELOPER with SQL WINDOW from command line

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 26 14:43:10 CDT 2023