How to play PL/SQL DEVELOPER with Zero Basics

This is the fourth day of my participation in Gwen Challenge

About the author:

Author: LuciferLiu member of China DBA alliance (ACDU). I am now working as Oracle DBA and used to develop Oracle database, mainly serving manufacturing, auto finance and other industries. Now I have Oracle OCP and OceanBase OBCA certifications, and I am good at Oracle database operation and maintenance development, backup and recovery, installation and migration, and Linux automatic operation and maintenance script writing.

preface

I shared an article earlierSQL zero basic entry, one with you easily learn to add, delete, change and check!, many friends ask me how to connect to Oracle database. Today we will talk about the most common connection tools used by bloggers:PL/SQL DEVELOPER.

Introduce a,

PL/SQL DEVELOPERAn integrated development environment (IDE) for Oracle database storage unit development. PL/SQL developers focus on easy-to-use development tools, clean code, and high development efficiency when developing Oracle applications.

Download and install

Want to usePL/SQL DEVELOPER, you need to download the installation media:

PL/SQL DEVELOPER: plSQLDev1406x64. msi Oracle client: Windows.x64_193000_client.zip

Note: The system bits of the two software must be the same as those of the Windows system, which are 64 bits this time.

1. Install PL/SQL DEVELOPER

Select Input key installation:

Enter key information:

product code: ke4tv8t5jtxz493kl8s2nn3t6xgngcmgf3

serial Number: 264452

password: xs374ca

At this point,PL/SQL DEVELOPERThe installation is complete.

2. Install the Oracle client

Select administrator mode installation:

Using a built-in account:

Set this parameter based on the actual situation. The default value is recommended:

At this point,The Oracle clientThe installation is complete.

3. Configure Windows environment variables

1. Right-click my computer – > Advanced System Settings – > Environment Variables





Add TNS_ADMIN to system variable:



3. Add the NLS_LANG variable to system variables with the value of SIMPLIFIED Chinese_China.zhs16GBk

Configure PL/SQL Developer software

1. Double-click THE PL/SQL Developer software

There are two connection modes:

1. Configure TNSNAMES. 2

1. Configure TNSNAMES

In the TNS file,CDB19CIs a custom TNS name,10.211.55.100Is the IP address of the Oracle database host,1521Is the listening port number,cdb19cIs the service name of the Oracle database instance.

Open the PL/SQL Delveloper software, enter the database username and password, select TNS(CDB19C), and set the role to SYSDBA.

Calculator:SELECT 365 * 24 FROM dual;

2. By IP, listening port, and instance name

Open PL/SQL Delveloper, enter the user name and password of the database, set the role to SYSDBA, and enter the following:10.211.55.100:1521 / cdb19c

Query calendar for the current month:

This section describes how to connect to the Oracle database for query by installing the PL/SQL and Oracle client.

Of course, there is an easier way to configure PL/SQL Developer by packaging the installed software plus Oracle installation-free client software. Directly decompress the file and configure environment variables to use the file. Interested friends can add the blogger private message to get the installation package.

If you think the article is helpful to you, please like it, bookmark it, follow it, comment it, and support it four times in a row. Your support is the biggest motivation for my creation, thank you ~