With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, edit and debug PL/SQL statements, manipulate and export data, and view and create reports. You can connect to Oracle databases, and you can connect to selected third-party (non-Oracle) databases, view metadata and data, and migrate these databases to Oracle. PL/SQL Unwrapper for SQL Developer is a free extension to unwrap PL/SQL code wrapped with the wrap utility of the Oracle Database Server version 10g, 11g, 12c, 18c or 19c. ## Example Open a wrapped PL/SQL unit (procedure, function, package specification, package body, type specification or type body) in a SQL Developer editor. You can use SQL Developer on a Mac to connect to a database running on Windows or Unix/Linux etc., so it still has a place; the fact you can't have a local server. SQL Developer offers complete end-to-end development of your PL/SQL applications, a worksheet for running queries and scripts, a DBA console for managing the database, a reports interface, a complete data modeling solution, and a migration platform for moving your 3rd party databases to Oracle. SQL Developer Data Modeler Web SQLcl. Released: Dec 29, 2015. Updates in this release Updates in 11.0.4 (64 Bit) The 64 bit version of PL/SQL Developer 11.0.4 has been released.
PL/SQL Developer usage tips, shortcut keys1, set the keyword automatic capitalization: tools->preferences->editor, will keyword case select uppercase. When you enter SQL statements in a window, the keywords are automatically capitalized, and the others are lowercase. This is easy to read code, and to maintain a good coding style, in the same way, in Tools->preferences->code Assistant (assistant) can set the code hint delay time, enter a few characters when prompted, the database object uppercase, lowercase, First letter capitalization, etc.;
2. Review the execution plan: Select the SQL statement you want to analyze, then click the Explain Plan button on the toolbar (i.e. execution plan), or press F5 directly; this is mainly used to analyze the efficiency of SQL statement execution, analyze the structure of the table, so as to provide a visual basis for SQL tuning;
Pl Sql Developer Mac Os X Download
3, automatic replacement: Fast input SQL statements, such as input s, press the space, automatically replaced by select; for example, enter SF, press space, automatically replaced by select * from, very convenient, save a lot of time to write duplicate SQL statements.
Xcom 2 adult mod. Setup method: Menu Tools–>preferences–>editor–>autoreplace (auto-replace) –>edit
1), create a text file Shortcuts.txt, and write the following content:
S=select
Copy code is saved to the ~/plugins directory under the PL/SQL Developer installation path
2), Tools–>preferences–>user interface–>editor–>autoreplace, select the Enable check box, Then browse to the file and select the Shortcuts.txt you created before clicking Apply.
3), restart PL/SQL Developer, enter the s+ space in the windows, sc+ space to do the test.
Note: Shortcuts.txt cannot be removed, otherwise shortcut keys will not work
The following defines some rules as a reference
I=insert
U=update
S=select
F=from
W=where
O=order by
D=delete
Df=delete from
Sf=select * FROM
Sc=select COUNT (*) from
Sfu=select * from for UPDATE
Cor=create OR REPLACE
P=procedure
Fn=function
T=tigger
V=view
Sso=set serveroutput on;
Set shortcut keys (Setup method: Menu tools–>preferences–> user interface –> key configuration)
New SQL window: Ctrl+shift+s
New command window: ctrl+shift+c
New Test window: ctrl+shift+t
PL/SQL developer beautification: ctrl+shift+f
Redo: Ctrl+shift+z
Undo: Ctrl + Z
Clear: Ctrl+d (use caution, unrecoverable, I am disabled O (∩_∩) o~)
Check all: Ctrl + A
Indent: Tab
Cancel indent: Shift+tab
Uppercase: Ctrl+shift+x
Lowercase: ctrl+shift+y
Note: ctrl+h
Uncomment: Ctrl+m
Search: Ctrl+f
Show Table structure: CTRL + mouse hover over table name
List of templates: Shift+alt+r
Window list: ctrl+w
4, TNS Names: Menu Help->support info (support information)->tns Names, you can view the Tnsnames.ora of Oracle;
5. Debugging Stored Procedures
When using PL/SQL developer to operate Oracle, some stored procedures are sometimes called, or stored procedures are debugged;
Methods for calling stored procedures:
1) First, select procedures in the browser on the left of PL/SQL developer to find the stored procedure that needs to be called;
2), then, select the debug stored procedure, right-click, select Test, in the Test Scrīpt window, for the parameter defined in the type, you need to give the value of the parameter input, the last click on the number of buttons: Start debugger or press F9;
3), Last click: RUN or Ctrl+r.
debugging shortcut keys
Toggle Breakpoint: Ctrl+b
Start: F9
Run: Ctrl+r
Single Step Into: Ctrl + N
Step Skip: Ctrl+o
Single Step exit: Ctrl+t
Run to Exception: Ctrl+y
6. My Objects is automatically selected by default after login
By default, after Plsql developer is logged in, Brower will select all objects, and if you are logged on as a DBA, you will need to wait a few seconds for the tables directory to expand, and the response rate after selecting my objects is in milliseconds.
Setup method:
The Tools menu –>brower Filters opens the Order window for Brower folders and sets 'My Objects' to default.
Tools menu –>brower Folders The few directories you regularly order (e.g. Tables views Seq Functions Procedures) Move up a bit and color-coded so that your average look-up time will be much shorter and try.
Priority, from left to right
Tables–>tablespaces–>procedures–>users–>roles
PL/SQL Developer usage tips, shortcut keys
One of the great benefits to having an application developed on the Java platform is the ability to run it on many different operating systems. While Windows may still be the corporate standard in more shops than not, geeks worldwide know that Apple’s hardware and OS (OS X) are ‘superior.’ With yesterday’s release of Mountain Lion (10.8) I figured this was a good time to do a quick write-up on how to get started with SQL Developer on your [i]Mac[Book|Mini].
But wait, where is the Java?
The Java runtime that had been included with the OS X installs is no longer available in Mountain Lion. As I understand it, even if you had installed your own version of Java, when you upgrade or install 10.8, they will go away.
So if you try to run a previously installed version of SQL Developer, you won’t get very far. Java applications don’t run very well sans Java, tsk, tsk.
So for the n00bs out there (including me), here’s your
Step-By-Step Guide for Installing Java and SQL Developer
Let’s install Java first.
Getting to the download page is your first task. I’ll make it easy for you.
* Yes, I know we officially support 1.6 and not 1.7, but here’s a secret: 1.7 works just fine in version 3.2.20_09 of SQL Developer!
Once it’s downloaded, double-click it.
But wait! Oh no!
Open your preferences, go to the security panel, and select the unsigned software option
Now, we’re cooking with gas! Try double-clicking the download again.
It should go without a hitch. If it does, you’ll see something like this:
Make sure the ‘right’ java is setup and working.
Open a terminal, and run
[text]
java -version
[/text]
If you see ANYTHING but the following…
…you may have a problem.
But this is Apple and OS X, and so it will find Java just fine.
Ok, now we can worry about downloading and installing SQL Developer.
Go here and download ‘Oracle SQL Developer for Mac OSX platforms.
Once it’s downloaded, you’ll need to extract it and run it.
Wait a second…
You know it’s going to ‘work’ if you see the splash screen 🙂
But My SQL Developer is Using the Wrong JDK!?
SQL Developer will use whatever Java it can find. If you have the 1.6JDK installed as well, it might find that first. If you want to force it to use the 1.7 you just installed, all you need to do is explore the SQL Developer package, and edit the sqldeveloper-Darwin.conf file in the bin directory.
You may have noticed that Java 1.6 installs to a different directory than 1.7 on OS X.
- 1.6 – /System/Library/java/JavaVirtualMachines/1.6.0.jdk/Contents/home/
- 1.7 – /Library/java/javaVirtualMachines/1.7.0.jdk/Contents/Home/
Just update the ‘SetJavaHome’ entry to the version of Java you want SQL Developer to use when it runs.
A Few More Notes
You might be wondering why I installed Java 1.7 when we technically only support 1.6. Well, 1.7 will work, and that’s what many of our developer use internally. If you don’t like bleeding edge, feel free to follow the exact same instructions and grab JDK 6 instead.
This is one of the first work related blogs I’ve written on my home machine a la Mac. I didn’t have my trusted Windows friend SnagIt at hand, but @brentO turned me onto a free and very handy utility called ‘Skitch.’ It works, and once you forget all the normal Windows application ‘way of doing things,’ is also very intuitive. And it’s free, did I mention that? Thanks Brent!
Sql Developer For Mac
If you don’t like that the application title has an underscore in it, e.g. ‘SQL_Developer,’ then here’s a nice post from @martinpaulnash explaining how to fix that too.