PL/SQL Developer usage tips, shortcut keys

1, 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;

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.

Global Nav Open Menu Global Nav Close Menu; Apple; Shopping Bag +.
Oracle SQL Developer 3.1 is available for Windows XP, Vista (including 64-bit), Windows 7 (including 64-bit), and Windows Server 2008, Linux or Mac OS X. Similar choice › Pl sql developer 11.

SQLPro for MySQL, as its name clearly suggests, is a simple yet powerful OS X database client that enables you to access MySQL Server databases.Besides this, the utility also provides you with a collection of efficient tools for managing and editing MySQL databases.

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

I previously explained how to install SQL Server on a Mac via a Docker container. When I wrote that, SQL Server 2017 was the latest version of SQL Server, and it had just been made available for Linux and Docker (which means that you can also install it on MacOS systems).

In late 2018, Microsoft announced SQL Server 2019 Preview, and subsequently announced general release in late 2019. The installation process for SQL Server 2019 is exactly the same as for SQL Server 2017. The only difference is that you need to use the container image for SQL Server 2019 instead of the 2017 image. Here I show you how to do that.

Also, if you already have SQL Server 2017 installed, and you want to install SQL Server 2019 without removing the 2017 version, you’ll need to allocate a different port number on your host. I show you how to do that too.

Docker

The first step is to install Docker. If you already have Docker installed you can skip this step (and jump straight to SQL Server).

Docker is a platform that enables software to run in its own isolated environment. Therefore, SQL Server 2019 can be run on Docker in its own isolated container.

Install Docker
To download, visit the Docker CE for Mac download page and click Get Docker.
To install, double-click on the .dmg file and then drag the Docker.app icon to your Application folder.
Launch Docker
Launch Docker the same way you’d launch any other application (eg, via the Applications folder, the Launchpad, etc).
When you open Docker, you might be prompted for your password so that Docker can install its networking components and links to the Docker apps. Diablo 2 expansion disc iso download. Go ahead and provide your password, as Docker needs this to run.
Increase the Memory (optional)
By default, Docker will have 2GB of memory allocated to it. I’d suggest increasing it to 4GB if you can.
To do this, select Preferences from the little Docker icon in the top menu:
Then finish off by clicking Apply & Restart

SQL Server

Now that Docker has been installed and configured, we can download and install SQL Server 2019.

Download SQL Server 2019
Open a Terminal window and run the following command.
This downloads the latest SQL Server for Linux Docker image to your computer.
You can also check for the various container image options on the Docker website if you wish.
Launch the Docker Image
Run the following command to launch an instance of the Docker image you just downloaded:
Just change Bart to a name of your choosing, and reallyStrongPwd#123 to a password of your choosing.
If you get a “port already allocated” error, see below.
Here’s an explanation of the parameters:
-e 'ACCEPT_EULA=Y'
The Y shows that you agree with the EULA (End User Licence Agreement). This is required.
-e 'SA_PASSWORD=reallyStrongPwd#123'
Required parameter that sets the sa database password.
-p 1433:1433
This maps the local port 1433 to port 1433 on the container. The first value is the TCP port on the ho

Docker

Install Docker

Launch Docker

Increase the Memory (optional)

SQL Server

Download SQL Server 2019

Launch the Docker Image

Pl Sql Developer Mac Os X Download