I have not tested this thoroughly, but at the very least I am able to bring up SQL Developer 19.1.0.094, connect to a database, and run queries on it. It did not work if I tried to use their instructions to install the 'latest' version: brew cask install adoptopenjdk, as this seems to install OpenJDK 12.x as of May 2019. Download sqldeveloper mac for free. Developer Tools downloads - SQLDeveloper by Oracle and many more programs are available for instant and free download.
Win64-bit Oracle_11gR2 database installation + PL SQL Developer, win64oracle_11gr2
Download required software:
Starting with SQL Server 2017, you can now install SQL Server directly on to a Linux machine. And because macOS is Unix based (and Linux is Unix based), you can run SQL Server for Linux on your Mac. The way to do this is to run SQL Server on Docker. So let’s go ahead and install Docker. Then we’ll download and install SQL Server. Oracle sql developer free download. Spatial Viewer for Oracle SQL Developer The purpose of GeoRaptor project is to extend Oracle SQL Developer with additional functionality for. IPL/SQL Developer is a reference PL/SQL Developer version of the WEB. Mac OS X/iOS, Android, FreeBSD, OS/2, Game Boy Advance, Nintendo NDS and DOS; semantically.
Oracle_11gR2 and instantclient-basic-nt-11.2.0.3.0 and plsqldev9
Download game guitar hero ps2 untuk android. Download link: http://pan.baidu.com/s/1gdH53IN
Step 1: Install Oracle_11gR2
In the displayed 'configuration Security Update' window, cancel 'I want to accept security updates through My Oracle Support' and click 'Next ':
In the 'Installation Options' window, select 'Create and configure Database' and click 'Next ':
In the system class window, select desktop class and click Next ':
In the 'typical installation' window, select the Oracle base Directory, select 'Enterprise Edition' and 'default', enter the unified password Oracle11g, and click 'Next ':
In the prerequisite check window, click Next ':
In the 'summary' window, click 'finish' to install:
The installation process is as follows:
After the Database is created, the following 'Database Configuration Assistant' interface appears:
Select 'password management' to view and modify the following users:
(1) normal user: SCOTT (password: tiger)
(2) General Administrator: SYSTEM (password: manager)
(3) Super administrator: SYS (password: change_on_install)
After the modification is complete, click OK '.
In the 'finish' window, click 'close.
Step 2: Decompress the instantclient-basic-nt-11.2.0.3.0 to the installation directory
I put it in the F: CMDL product directory
Step 3: install and configure PLSQL Developer
PLSQL Developer can be installed normally.
The configuration is as follows:
After the installation is complete, run PL/SQL Developer. In this case, the logon form cannot be logged on. Click the Calcel button and it will enter in the non-Logon status.
Click OK.
Configure the new environment variable:
TNS_ADMIN and NLS_LANG
TNS_ADMIN = F: L product 11.2.0 dbhome_1 NETWORK ADMIN
NLS_LANG = AMERICAN_AMERICA.ZHS16GBK (an error will be reported when pl/SQL is enabled ),
The procedure is as follows:
On the computer --- properties --- advanced system settings ---- System Properties (advanced) --- environment variables --- create TNS_ADMIN and NLS_LANG variable names: TNS_ADMIN and NLS_LANG variable values: TNS_ADMIN = F: CMDL product 11.2.0 dbhome_1 NETWORK ADMIN
NLS_LANG = AMERICAN_AMERICA.ZHS16GBK
In this case, you can open PL SQL dve.
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;
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.
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.
Pl Sql Developer Download
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.
Pl Sql Developer Software
Wwe 2k15 crack dll files download. 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