PL/SQL Developer connect Local Oracle 11g 64-bit database and shortcut key settings

1. Log in to PL/SQL Developer

This omits the installation steps for the Oracle database and PL/SQL Developer, and note that when you install the PL/SQL Developer software, do not install it under the program Files (x86) directory or you cannot start PL/SQL Developer.

Wonder why the database TNS is not chosen here? I installed the database first and then installed PL/SQL Developer. When the PL/SQL developer is installed, Oracle home and OCI Libaray have been identified. What about it? Log in to PL/SQL Developer with non-login first, set up Oracle home and OCI Libaray.

The Oracle home directory is not automatically recognized under Oracle home, and the Oracle home path is manually specified.

Click "OK" to exit PL/SQL Developer and log in again.

Or choose not to database TNS, try to log in without a database to see what errors are reported.

Finally found the key point of the problem, the installation of PL/SQL Deleloper can only recognize the 32 oci.dll. It seems to be a 64-bit PL/SQL Deleloper, so search the web for PL/SQL Deleloper 64-bit version. However the Discovery PL/SQL Deleloper does not differentiate between 64-bit and 32-bit. It seems that we can only start with Oci.dll. According to the above error message, it appears that just install a 32-bit version of Oracle Client.

2. Install Oracle Clinet

First download an Oracle 11g Client to the Oracle website, but you will need to apply for an Oracle account before you can download it.

Current: http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html

This is a green version of Oracle Client, so as long as it needs to be decompressed, it can be. Unzip the downloaded Oracle client file Instantclient-basic-win32-11.2.0.1.0.zip to the C drive (note!). Cannot be under 64-bit). Then create a new network\admin directory under the extracted C:\instantclient_11_2 directory, create a new Tnsnames.ora file in the Admin directory, and add the database TNS.

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = chiclewu-pc) (PORT = 1521))
(Connect_data =
(SERVER = dedicated)
(service_name = ORCL)
)
)

(Note: The Tnsnames.ora file can also be copied from the Network\admin directory of the Oracle database home directory, as well as the Sqlnet.ora.) Then determine whether the host configuration is correct, if host is the hostname, you need to remove the domain name after the hostname)

3. Configuring the Oracle Home and OCI libaray for PL/SQL developer

Enter the PL/SQL Developer in non-logon mode, designate the Oracle home path as the Oracle Client directory (C:\instantclient_11_2), and the OCI Libaray path to Oracle The Oci.dll (C:\instantclient_11_2\oci.dll) of the client directory.

Click "OK" and now the configuration is complete, here is the time to wait for a miracle. Exit PL/SQL Developer.

4. Verifying Oracle Client

Open a new PL/SQL Developer, enter the user name and password, under the database option, you can see the TNS that has just been configured.

Waiting for the miracle moment ....

After a few seconds of waiting, the miracle time has finally arrived, you can login, you can login ...

Check to see if the data can be queried.

Query data no problem, finally finished.

Shortcut key settings:

1, class SQL Plus Windows: File->new->command window, this is similar to Oracle's client tool SQL Plus, but it is much more useful.

2, 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.;

3. 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;

4, 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.

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

5. Execute a single SQL statement: Press the F8 key

6, TNS Names: Menu Help->support info (support information)->tns Names, you can view the Tnsnames.ora of Oracle;

7. 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

8. Template shortcut keys

9. 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 connect Local Oracle 11g 64-bit database and shortcut key settings