Shulou(Shulou.com)06/01 Report--

PL / SQL Dev eloper use

PL/SQL Developer is an integrated development environment developed by Allround Automations Co., Ltd., specifically for the development of program units stored in Oracle databases. With syntax enhancement, SQL and PL/SQL help, object description, code assistant, compiler hints, PL/SQL improvement, code content, code classification, browser buttons, hyperlink navigation, macro library and many other intelligent features, can meet the most demanding user needs. When you need some information, it will appear automatically, and you can call it up with a single click at most.

1. PL/SQL develop installation

(there are many versions of PL/SQL, and PL/SQL 8 is used here)

Double-click the installation file to start the installation, PL/SQL develop installation is relatively simple, agree to the installation agreement, select the installation directory NEXT installation can be

After the installation, you need to enter the registration code before you can use:

Plsql 8 Registration Code:

Product code:jtkjljsvlx2mcl6sbbbxapgdhx9zhjhnd7xvpcuzu7m6

Serial number: 2064414062

Password:xs374ca

2. PL/SQL develop connects to the database

Before using PL/SQL develop to connect to the database, you need to configure the environment variables:

Configure environment variable address path: right-click "my computer", select "Properties", click "change Settings", click "Environment variable" in the advanced panel, and click New or Edit (path environment variable only needs to be edited) to configure the environment variable.

TNS_ADMIN environment variable, similar to: C:\ app\ Lzj\ product\ 11.2.0\ client_1\ network\ admin. This variable is actually the basis on which PL/SQL Developer looks for tnsnames.ora. With this environment variable, PL/SQL Developer startup will automatically discover the connection configuration.

NLS_LANG environment variable, the value is: SIMPLIFIED CHINESE_CHINA.ZHS16GBK. This value should be consistent with the configuration of the oracle server, and the oracle server defaults to: SIMPLIFIED CHINESE_CHINA.ZHS16GBK.

The Path environment variable, which sets the home directory of Oracle client. Similar to: C:\ app\ Lzj\ product\ 11.2.0\ client_1, enter the end of the path.

Note: if the database version is 64-bit, you need to download and decompress instantclient_11_2. After decompression, create a new instantclient_11_2\ network\ admin in tnstantclient_11_2, and then copy the tnsnames under C:\ app\ Lzj\ product\ 11.2.0\ client_1\ network\ admin to instantclient_11_2\ network\ admin. The new tns path is as follows:

SID name =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = SID name)

)

SID is the database name, PROTOCOL is the connection protocol, HOST is the database IP address, if local, it can be localhost, and PORT is the connection port

The TNS_ADMIN environment variable is now configured as instantclient_11_2\ network\ admin

After the environment variable is configured, you need to configure the connection path in PL/SQL develop. Double-click to open PL/SQL develop, click cancel in the login window to return, and execute "tool" → "preference" → "connection". Configure the connection path as follows:

Oracle home:

... \ instantclient_11_2

Oci library:

... \ instantclient_11_2\ orc.dll

Restart PL/SQL develop after clicking ok to save.

You can use PL/SQL develop to connect to the database at this point. Double-click to open PL/SQL develop, enter the user name, password, database name, select the connection method (sys must be connected by sysdba), and click OK to connect to the database.

The interface after connection shows that the SYS user has connected to the ORCL database as SYSDBA

3. PL/SQL develop usage

After the connection is successful, click the add button and add a SQL window or command window to manipulate the database using the SQL statement:

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.