1. Install Oracle 11g Express

Oracle 11g Download Express Edition
Download Sql Developer For Oracle 11g Free For Mac Versions
Download Sql Developer For Oracle 11g Free For Mac Osx

1.1 Download and install Oracle 11g Express

Baidu searchoracleClick on the official website:

However I cannot get SQL Developer to open. I just got this Mac and I am trying to set it up so I also just downloaded SQL Developer. My product.config file is all commented out. I have also tried to look at the sqldeveloper.conf file and set the “SetJavaHome” there. Is there anything else you had to do to get SQL Developer running? Sql developer free download - SQL Anywhere Developer Edition, Insight Developer for Oracle, Iridient Developer, and many more programs. SQL Developer is also shipped with the Oracle Database. Initially, Oracle Database 11g Release 1. SQL Developer is installed by default when you install the database. Once the installation is complete, locate the sqldeveloper directory (for example, product 11.1.0 db1 sqldeveloper sqldeveloper.exe) to start SQL Developer. The purpose of GeoRaptor project is to extend Oracle SQL Developer with additional functionality for database administrators or developers working with Oracle Spatial data. Dear Users, A port to version 4.x of SQL Developer is being attempted. It is not simple due to the lack of development resources.

Click “Database Download”: Free software to download youtube videos for mac.

clickDatabase 11g Express Edition：

clickAccept License AgreementThen DownloadOracle Database Express Edition 11g Release 2 for Windows x64：

Double-click after decompressionsetup.exeInstallation:

Installation process is simple, you can specify the installation directory. In addition, you need to specify the default systemsysorsystemUser’s password, the password I set isroot。

1.2 Test the success of installing Oracle 11g Express

Check if there are icons in the start menu:

Desktop will also have an additional nameOracle Database 11g Express Edition IntroductionIcon:

Lugaru full version free download mac. Click on the Start MenuRun the SQL command lineIn fact, it’s the command line tool that comes with it.SqlPlus。 Enter login commandsconnectAnd then the account numbersystemPasswordroot。 The following picture:

2. Connecting Oracle database with PL/SQL Developer

PL/SQLIt is also a programming language, called Procedural Language / SQL. PL/SQL is an extension of Oracle database to SQL statements. PL/SQL is a programming language that organizes data operations and query statements into the procedural units of PL/SQL code and realizes complex functions or computations through logical judgement and loops.
Oracle 11g ExpressIt’s just the server side of Oracle database, not the client side.
PL/SQL DeveloperIt’s an Oracle integrated development environment. It’s a fee-based one, so order me or spend my time on my own.
PL/SQL DeveloperYou need to install Oracle Client, the client of Oracle database, which can be downloaded from the official website.Instant Client

2.1 Download Instant Client

Baidu searchoracleClick on the official website:

Click “Database Download”:

clickInstant Client：

ChoiceBasicJust download:

2.2 Instant Client Installation

hypothesisOracle 11g ExpressThe installation directory is:
F:oracle_database

Oracle 11g Download Express Edition

holdInstant ClientCompressed package decompressed toapporacleproductUnder the catalogue (you can also press it elsewhere)
The directory path after decompression is:
F:oracle_databaseapporacleproductinstantclient_12_2

Document:
F:oracle_databaseapporacleproduct11.2.0servernetworkADMINtnsnames.ora
Copy to:
F:oracle_databaseapporacleproductinstantclient_12_2

2.3 Installation of PL/SQL Developer

Installation process is very simple, are clicked on the “next step”, after installation, click on the Chinese Baohua can be.

After installation, double-click openPLSQL DeveloperIt will display the login window and click Cancel. The unlisted interface is then displayed.

Download Sql Developer For Oracle 11g Free For Mac Versions

click'Configuration'–'Preferences'：

inputInstant ClientDirectory andoci.dllPath

Oracle home directory name:
F:oracle_databaseapporacleproductinstantclient_12_2
OCI Library:
F:oracle_databaseapporacleproductinstantclient_12_2oci.dll

Exit after completionPL/SQL Developer。

2.4 Add system environment variables:
Variable name: NLS_LAN variable value:SIMPLIFIED CHINESE_CHINA.ZHS16GBK
Variable name: TNS_ADMIN variable value:F:oracle_databaseapporacleproductinstantclient_12_2(that is)Path of Instant Client）
takeF:oracle_databaseapporacleproductinstantclient_12_2(that is)Path of Instant ClientAdd toPathVariable

2.5 Connecting Oracle Server with PL/SQL

Download Sql Developer For Oracle 11g Free For Mac Osx

Open PL/SQL, enter the password of the account (system/root), and select XE for the database. Wish you a successful connection!