Home » SQL & PL/SQL » Client Tools » display windows on OracleSQL Developer (Oracle SQL Developer)
display windows on OracleSQL Developer [message #595350] Tue, 10 September 2013 09:16 Go to next message
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 49 times)
Re: display windows on OracleSQL Developer [message #595351 is a reply to message #595350] Tue, 10 September 2013 09:20 Go to previous messageGo to next message
cookiemonster
Messages: 10846
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.
Re: display windows on OracleSQL Developer [message #595360 is a reply to message #595350] Tue, 10 September 2013 10:37 Go to previous messageGo to next message
thatjeffsmith
Messages: 35
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.
Re: display windows on OracleSQL Developer [message #595443 is a reply to message #595360] Wed, 11 September 2013 05:19 Go to previous message
pourquoipastoi
Messages: 2
Registered: September 2013
Junior Member
thanks
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:
  


Current Time: Sun Jul 27 23:24:35 CDT 2014

Total time taken to generate the page: 0.22205 seconds