New answers tagged oracle-sql-developer
We don't charge for SQL Developer. If you want official support, you need a database licensed and covered by My Oracle Support. It's more complicated than this, but it's effectively free.
SQL Developer the client application is free of charge. Of course, the Oracle database would need to be licensed in a way that allowed you to connect with any tool. PL/SQL Developer is a completely different tool produced by a different company that you would need to license. Define "secure". Assuming a default database install, using any tool to connect ...
http://www.oracle.com/technetwork/developer-tools/sql-developer/pricing-faq-085267.html Is Oracle SQL Developer free? Yes. PL/SQL Developer is another product, that is not free. Other tools, even applications or application servers connect the database remotely. So yes, it is.
Autotrace in SQL Developer gets the plan from v$sql_plan, and also gets the stats from your session, does a delta of session stats before and after running the query. Explain Plan asks the database what it THINKS the plan will be for your query. Your co-worker is right, they can differ wildly, and you're better served to use AutoTrace or our new feature in ...
There are a number of things that can cause the actual plan to differ from the estimated plan (and if you want to get really deep in the weeds, there are lots of things that can cause different methods of producing the actual plan to produce different results but I'll ignore that). The simplest (and most common) revolve around bind variables. If I do an ...
SQL Developer 3.x had a "theme" option, but that's been removed in 4.0, so no luck there. You could try changing the "Look and Feel" option to Windows (I don't know what you get on other OSes). Settings here: Result should match your OS color scheme. I get this for example, which is a bit more readable than the default white on blue:
I did a google search for the phrase "sql developer code formatting", and the first hit was this: http://www.thatjeffsmith.com/archive/2014/03/how-to-make-your-code-look-like-steven-feuersteins-in-oracle-sql-developer/ Have a read through that blog post from Jeff Smith, product manager for SQL Developer. That should explain what you need to do. Edited to ...
Create an SQL file with the content that sets the desired linesize, e.g: login.sql set linesize 200 Then in SQL Developer, go to Tools/Preferences/Database, and set this file at Filename for connection startup script.
Top 50 recent answers are included