sql developer installation steps

Pl/sql Developer is an integrated development environment designed to develop, test, debug, and optimize Oracle Pl/sql storage program units, such as triggers. The Pl/sql developer function is very comprehensive, which shortens the programmer's development cycle greatly. Pow

When logging on to Oracle SQL developer, the problem is solved. When logging on to oracle's built-in SQL developer, the connection method was not selected at the beginning. The default connection type "Basic" was used. I filled in the connection name, user name, password, and connection prompt me error. Listener refuse

installation of weapons is a top priority. There are four modules in the system: Fleet information Management, warship information management, military officer information management, weapon information management. At the same time in the four systems to be inserted, query, change and other changes. Based on these analysis, the data flow chart is drawn out, the dictionary is written out, and the corresponding CDM,LDMandPDM are drawn using Power Desig

After installing ORACLE11GR2 for the first time, it was curious to point out that when you click on SQL Developer under Application development, a window pops up, To choose a java.exe path, I will say the JDK1.7 under the Java.exe fill in, and then shut down the interface, the next time, found the warning, the highest version must not be higher than 1.6, and no prompt changes, directly into the interface, b

First turn on the computer, to the specified directory of PL/SQL installation"D:\app\DZL\product\10.2.0\dbhome_1\NETWORK\ADMIN" or"D:\oracle\product\10.2.0\db_1\network\ADMIN" or is not logged into PL/SQLLocate your installation path via theFind it again. "Tnsnames.ora" under the \network\adminOpen the "Tnsnames.ora" file to increase the string you need to connec

Tags: plsql installing Oracle Client InstallationDownload the 3 required packages (in order to connect the 11g database)1:oracle Client (Oracle clients)Http://www.oracle.com/technetwork/cn/database/enterprise-edition/downloads/112010-win64soft-086667-zhs.htmlDownload Win64_11gr2_client.zip Specific installation method can refer to Baidu2:pl/sql Developer 11.0Http

discuss what was going on. If you say they have progress, it is one of the buddies who chose the "reload system" to it ...As a Win7 has not been installed after the formal release of the system, this solution is indeed a bit ... Not acceptable.2. Settle it yourself.The great leader, Chairman Mao, said, "Do it yourself."The process of finding the reason is slightly ... In fact, using Process Monitor to observe the load operation when creating the diagram, to see which is the failure, to say it i

, click the test button to test whether the setting is connected, and if it succeeds, it will show "success" after the left corner status.Figure 2.18 The new/Select Database Connection windowCommon error: If the connection error shown in 2.19 appears, Oracle's service is not turned on.Figure 2.19 A connection error occurredLearn two more tricks: the steps to turn on Oracle services are as follows.(1) Right-click on the "Computer" icon in the desktop a

Label:PL/SQL Developer can import or export CSV files.Import CSV file steps:1, choose Tools->text Importer ....2. Select the second Data to Oracle tab and select Open Data File ... to select the CSV file to import and determine3, select the corresponding owner and table, the field one by one corresponds, and finally click on the bottom of the import, the data is

1. the downloaded Oracle SQL Developer, rpm file,: http://www.oracle.com/technology/software/products/ SQL /index.html 2. install sun's jdk1.6, if installed, skip (linux mint 12 is installed by default) command: sudo apt-get install sun-java6-jdk www.2cto.com 3. oracl SQL Develoepr is a rpm package by default. To insta

1, error 1: initialization error could not initializeThe computer was originally equipped with Oracle 11g 64-bit, but PL/SQL is not connected, reported " initialization Error "The mistake of collecting data to find the cause of the original PL/SQL is a 32-bit of, and Oracle Client is 64 bits (originally installed from the server side) , they are incompatible and of course cannot be connected. Workaround

In Windows, the ui programs of the Oracle client include toad and pl/SQL developer. in Ubuntu Linux, all of them are lost. Fortunately, oracle officially has SQL developer, which supports multiple system platforms at the same time and supports mysql, mssql, and sybase data migration. Since it is so good, it is still of

complete the configuration. Go back to the main window of Oracle Network Manager (Oracle Net manager) and save the configuration. By default, you can find the local service name configuration file in the Oracle Installation Directory (for example, d in Windows: /Oracle/ora92/Network/admin/tnsnames. ora ). The configured local service name is shown as follows: The service name in the tree directory can be changed to a service name composed of any va

1, to use PL/SQL need to install the Oracle client (this is necessary, otherwise plsql will not use, this client can go to Oracle official Web download, called instance client, as far as possible with the newer version on it, The Windows version of the big is more than 50 m, as well as the lite version of more than 20 m, address: http://www.oracle.com/technology/global/cn/software/tech/oci/instantclient/ index.html, pick a version of the system that s

Tags: style blog C java tar http1. EnvironmentWin7 x64,oracle 11g r2,jdk6 x642. QuestionsThe first time you start Oracle SQL Developer will let us fill in the path of Java.exe, I found in the JDK installation directory of the bin Java.exe, but fill in the following error:3. CausesThe Oracle SQL

))) (connect_data = (service_name = database example) ) )2, System environment variable configuration, need to restart the system to take effectNls_lang====american_america. ZHS16GBK character encodingTns_admin====d:\instantclient_12_1\network\admin (the directory where the Tnsnames.ora file is located)3, PL/SQL Developer configuration, the first time to open the direct selection of cancellation canConfi