Here’s a quick run-down of FAQ’s I get when doing presentations or demos.
Can SQL Developer…
Extend a tablespace?
You can edit an existing data file or add a new one. We’ll also show you the SQL that’s going to be used so you can copy it to run in SQL*Plus or wherever. And if you wanna just do it in a SQL Worksheet, we can help you with the syntax there too.
Debug a stored procedure?
Do you mean run one and see what comes back?
Or see your DBMS_OUTPUT?
Or do you mean stepping through code, one line at a time?
Make an ERD?
Yup. Database diagrams too.
This is a Relational Model, tables and foreign keys, diagram.
Export to Excel?
Gosh yes. But be sure to use the XLSX format – we can build those faster and with less memory than a XLS file. Or just write to a CSV using our /*csv*/ trick…
Import from Excel to a table?
It’s the #1 post on this blog for like 4 years running. Yes, we can do that.
Compare 2 schemas?
Yes. Or just some objects. Or two different schemas in 2 different databases. Or even 15 objects from 14 different schemas over here to 14 different schemas over there. And it’s free, and it does ALTER SQL scripting.
Compare my PL/SQL or any code for that matter?
Yup, don’t believe folks that say you can’t.
Format my code?
Yes. We’re doing some work for version 4.2 to make this much nicer. In a SQL Worksheet, right-click, format. You can set your formatter preferences…in the preferences.
Help me make my SQL go faster?
Yes. Explain plans, dbms_xplan, autotrace, reading trace files, SQL tuning advisor, real time sql monitoring – we have all that stuff.
Unlock a user or change their password?
Yes. User management stuff is in the DBA panel, under security.
Make a heat map report to show log switches (or something else?)
Yup, you just need to build a report.
Yes. For one object, for some objects, for all objects. In the GUI, or at the command-line.
Want GRANTS too? For a table, or for a user? Yes and yes.
Connect to MySQL or SQL Server?
Yes. Teradata, DB2, and Sybase too. Run queries, look at stuff, and of course copy and migrate things to Oracle!
Work with BLOBs?
We can upload them, look at them, load them into an external editor, export them by the truckload, or even view them as text.
Support SQL*Plus stuff?
Yes, run your code ‘as a script’ in the worksheet, or use SQLcl.
Run more than one query at a time?
Yes, you’ll need an unshared worksheet if your current connection is busy.
Export a resultset without running the query a second time?
Yes – but mind you it could be expensive.
Not get in my way while I try to type my code?
Yes, configure your code helpers to have a longer delay, or disable the ‘automatic’ helpers and use it on-demand.
Generate data dictionary reports?
Yup. View > Reports or use the Data Modeler.
Search the database and/or PL/SQL code?
Yeah. Hit the binocular button in the toolbar. Don’t forget ALT+G in a code editor to auto-search the text at the cursor 🙂
Block edit code?
Yes. You can block select code, or you can add multiple cursors to type/edit in a region or even NOT in a region.
There’s more, of course.
Use Google, use the search on this page, the answer is out there. If you can’t find it, come back to my ‘Ask me‘ page, I’ll help you find it.