1. PL/SQL Developer by IFS Allround Automations is a feature-rich Integrated Development Environment (IDE) that was designed to help users develop units for Oracle databases using PL/SQL programming. Sadly, there is no version of PL/SQL Developer for Mac, but.
  2. 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.

To start SQL Developer, go to the sqldeveloper directory under the directory, and do one of the following, as appropriate for your operating system: On Linux and Mac OS X systems, run sh sqldeveloper.sh. On Windows systems, double-click sqldeveloper.exe. The visualization of Swing components depends heavily on the chosen Look & Feel (e.g. On Windows the progress bar is segmented). The default Look & Feel for SQL Developer is on all platforms “Oracle”. On Windows you may change it to “Windows”, on macOS to “Mac OS X” and on Ubuntu to “Metal”.

Win64-bit Oracle_11gR2 database installation + PL SQL Developer, win64oracle_11gr2

Download required software:

Oracle_11gR2 and instantclient-basic-nt-11.2.0.3.0 and plsqldev9

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 is an Integrated Development Environment that is specifically targeted at the development of stored program units for Oracle Databases. Over time we have seen more and more business logic and application logic move into the Oracle Server, so that PL/SQL programming has become a significant part of the total development process. PL/SQL Developer focuses on ease of use, code quality and productivity, key advantages during Oracle application development.

For a brief description of the new features in version 14.0, visit the New Features page.

Powerful PL/SQL Editor

With its Syntax Highlighting, SQL and PL/SQL help, Object Descriptions, Code Assistant, Compiler Hints, Refactoring, PL/SQL Beautifier, Code Contents, Code Hierarchy, Code Folding, Hyperlink Navigation, Macro Library and many other sophisticated features, the Unicode compliant editor will even appeal to the most demanding user.

Integrated Debugger

The integrated debugger offers all features you could wish for: Step In, Step Over, Step Out, Run Until Exception, Breakpoints, View & Set Variables, View Call Stack, and so on. You can debug any program unit without making any modification to it, including triggers and object types.

PL/SQL Beautifier

The PL/SQL Beautifier allows you to format your SQL and PL/SQL code through a user-defined set of rules. Your code can automatically be beautified when you compile, save, or open a file. This feature will increase your coding productivity and will improve the readability of your PL/SQL code if you are working in large project teams.


Multi-threaded IDE

PL/SQL Developer is a multi-threaded IDE. This means that you can continue to work as SQL queries are executing, PL/SQL programs are executing, debug sessions are running, and so on. It also means that the IDE will not “hang” if you make a programming error: you can break execution or save your work at any time.

Easy installation

No middle-ware required other than Oracle Net. No database object installation. Just a simple one-button installation procedure and you’re ready to use it.

System requirements

PL/SQL Developer will run on Windows XP, 2003, 2008, Vista, Windows 7, Windows 8 and Windows 10. The supported Oracle Server versions are 7.x, 8.x, 8i, 9i, 10g, 11g, 12c, 18c and 19c on any platform. To connect to an Oracle database, the 32 bit PL/SQL Developer version requires a 32 bit Oracle Client and the 64 bit PL/SQL Developer version requires a 64 bit Oracle Client.

Trial version

You can download a fully functional 30-day trial version to try out PL/SQL Developer yourself. If after 30 days you can’t imagine how you’ve ever been able to work without PL/SQL Developer, you can visit our ordering page for ordering details and price information. We have a customer list available if you want to get an impression of what organizations are using PL/SQL Developer.

Pricing & Licensing

PL/SQL Developer licenses are per named user, and not per PC, Server, Database or Location. Therefore you need just one license for one named user, even if you are running multiple instances on multiple machines. For complete license terms you can download our License Agreement.

If you order a Service Contract with your PL/SQL Developer licenses, you are entitled to receive technical support by e-mail and free product upgrades for the period of 1 or 3 years. Without this contract, you will receive only patch releases of the PL/SQL Developer version you purchased.
You can order the service contract directly with PL/SQL Developer. The service contract can be renewed when it expires. When ordering a service contract at a later time, a reinstatement fee will apply.

LicensesAnnual Service Contract
Single userUSD 216Single userUSD 60
5 usersUSD 6485 usersUSD 180
10 usersUSD 108010 usersUSD 300
20 usersUSD 144020 usersUSD 400
50 usersUSD 252050 usersUSD 700
100 usersUSD 3600100 usersUSD 1000
UnlimitedUSD 7200UnlimitedUSD 2000

“I believe this is the first time I have used PL/SQL Developer support and it was awesome just like the product. I’ve never had a need. That is saying something since I’ve been using PL/SQL Developer for over 10 years.”

Paul Lockaby, Vanderbilt UniversityPl Sql Developer Mac Os X Download

“I have reviewed the new version of PL/SQL Developer and I think it is fantastic. It is a well designed and reliable product which will increase productivity of our Archway development team. PL/SQL Developer provides tremendous value for everyone who works with the Oracle PL/SQL language. I will highly recommend upgrading to version 8.”

Pl Sql Developer 13 Download

Pravin A., Archway

“I just wanted to tell you how much I enjoy using your software, and how much I appreciate how easy you make it to upgrade versions and get support. You guys and gals are great.”

Katherine Moss, Life Technologies, Inc

I have been using this product since 2003. It is quite possibly the best interface for Oracle that I’ve ever seen. I can’t imagine writing code without it. You folks are to be commended of a top-notch quality product!”

Brian Yurochko, Duquesne University

I wanted to say that PL/SQL Developer is an excellent product. I have been using it extensively for over 8 years and it has been very helpful in my development / debugging etc. Keep up the good work!”

Mateusz Klos, Derco Aerospace

I’ve been using PL/SQL Developer for 3-4 years now and it is the best tool on the market for working with Oracle from a developers point of view at least. I’ve looked at some of the new things that have come out and they are still very far behind in the number of features that are offered.”

Kevin Lane,

You probably don’t get enough emails like this so I wanted to drop you a note to say that PL/SQL Developer is fantastic! We’ve been using it for around 18 months now and have around 20-30 users using it daily. Almost every month we find a new feature that only reinforces our high regard of it; this months’ was great BLOB displaying and editing.

Thanks for an excellent product.”

Adrian Crossley, HESA

By the way, I love PLS/SQL Developer. It is a well designed and reliable product that has increased my productivity and – here’s a novel concept – it is sold at a reasonable price. Everyone at my company is pleased with your product and we all have tried similar products from your competitors with mixed results. Thanks to your company for doing what a company should do: please the customer.”

Tom Nitroy, Nitroy Computing Services, Inc.

Just wanted to drop some congratulations for the ability of PL/SQL Developer to recover from system crashes. I haven’t been blue-screened for years, but have had two in the last week. In both cases, PL/SQL Developer recovered all the open windows, queries and files I was working on. Fantastic! I doubt the other competing tools do this.”

Bill Coulam, New Global Telecom

PL/SQL Developer is the best tool available on the planet for dealing with Oracle.
I feel as though I should share some of the profits with you, the retail selling price for PL/SQL Developer has already been recovered many times over…”

Jeffrey Martin, Philips

We searched hard for an inexpensive development GUI for oracle. PL/SQL developer fits the bill perfectly. We couldn’t ask for more!”

James Cooke, Intel

PL/SQL Developer provides tremendous value for everyone who works with the Oracle PL/SQL language. Its rich feature set satisfies the needs of all Oracle database developers – from junior to the most senior. Among the many helpful features you’ll find industry-leading support for reference cursor variables.”

Igor Cherny, walmart.com

We have been using PL/SQL Developer for over 2 years now for our PL/SQL development. The features you receive with this tool are wonderful and very productive and the price compared to other like tools is worth every $$ spent.”

R. Angove, Airborne Expess

I find PL/SQL Developer easy to use, very helpful and solid, as is the product support.”

Brenda Graham, Carnegie Mellon University

I can not tell you how much I enjoy your product, I have been using it for over a year now, (started when I was just learning this on my own) and would not think of coding in oracle without it. Great Job!!!!!”

Kelly Burton, Randolph Air Force Base

I’m a long-time PL/SQL Developer customer and user. Just wanted to drop a quick note to let you know how fantastic I think this product is. It is without a doubt the best development tool, EVER. I love it.

I ran across the recovery option yesterday when my PC crashed… I didn’t even know that feature existed, but it turned out to be a LIFE-SAVER.

Keep up the GREAT work!! PL/SQL Developer is tops on my list. Don’t ever change!”

Pl Sql Developer Mac Os X Download Dmg

DownloadJeff Keen, Jackson EMC

Just a note to say that we are extremely pleased with PL/SQL Developer 5.1. It is a cost-effective feature-packed tool that knocks spots off xxxx and other competitors! Keep up the good work!”

MacRalph Little, Tribal Data Solutions

Pl Sql Developer Software

Plug-ins

This section contains Plug-Ins for PL/SQL Developer that make use of the Plug-In interface, which allows you to develop DLL’s that are automatically picked up by PL/SQL Developer and are integrated into its IDE.

Active Query Builder

This a replacement for the standard Query Builder.
X

This a replacement for the standard Query Builder. This one is based on the Active Query Builder component by Active Database Software. It offers additional features like unions, nested joins and sub-queries.

Version 1.4.0:released on March 22, 2012
Updated to work with PL/SQL Developer 9.0
Improved speed
Version 1.4.1:Compatibility with PL/SQL Developer 12.0

Requirements:
PL/SQL Developer 5.1.2

Plsqldoc

The plsqldoc Plug-In allows you to easily generate and view HTML documentation for functions, procedures, packages, types, tables and views.
WindowsX

The plsqldoc Plug-In allows you to easily generate and view HTML documentation for functions, procedures, packages, types, tables and views. The documentation is derived from the definition and the comments of these objects, in a similar way as Javadoc for the Java programming language.

Version 1.1.0:released on July 17, 2003.
Version 1.1.4:released on November 5, 2003.
Version 1.1.6:released on March 6, 2004.
Version 1.2.0:released on April 30, 2005.
Version 1.2.1:released on October 13, 2011
Help button for link to pdf documentation
Default root directory changed to “My Documentsplsqldoc”
Version 1.2.2:released on January 16, 2012
Fixed “List index out of bounds” error during document generation
Version 1.3.0:Compatibility with PL/SQL Developer 12.0

Requirements:
PL/SQL Developer 5.1.2

FTP File Interface

The FTP File Interface Plug-In allows you to load and save files via the ftp protocol from within PL/SQL Developer.
X

The FTP File Interface Plug-In allows you to load and save files via the ftp protocol from within PL/SQL Developer. This gives you the possibility to store your files on a unix or linux server or even on the internet.

Fixes in 1.1.0:Fixed an Access Violation that could occur when connecting to the server.
New in 2.0.0:New version with support for Secure FTP (SFTP).
Fixes in 2.0.8:Improved the SFTP interface.
Fixes in 2.1.0:Improved the (S)FTP interface.
Fixed visual issue with profile list in file dialog
Added Timezone preference to correct time difference on server
Fixes in 2.2.0:File dialog opens with focus on filename field
File save now has a default filename
Improved date sorting in the file dialog
New in 2.3.0:Compatibility with PL/SQL Developer 12.0
New in 2.3.1:Opening a file over an SFTP connection could lead to a “cannot get file size” error
New in 2.3.2:Saved files over an SFTP connection could have CR/LF line breaks on Unix
Configuration form now has explicit OK and Cancel buttons

Pl Sql Developer Mac Os X Download Windows 10

Requirements:
PL/SQL Developer 4.0

Customized Syntax Highlighting

With this Plug-In you can add your own keywords and assign any of the available highlighting schemes to them.
X

With this Plug-In you can add your own keywords and assign any of the available highlighting schemes to them. You can even define your own query to retrieve keywords from the database. This way you can easily add package names, table names, etc as keywords.

Pl Sql Developer Mac

Version 1.2.0:Compatibility with PL/SQL Developer 12.0

Requirements:
PL/SQL Developer 3.0

Sql Developer For Mac