sql developer sql server

Download PL/SQL Developer in http://download.csdn.net/download/wuqinfei_cs/7740373.1. Unzip, create a new network folder under the Instantclient_11_2 directory, and then create a new admin folder under it . Copy the Tnsnames.ora in the Oracle\product\11.2.0\dbhome_1\network\admin directory to the previously created Admin folder.2. Right-click Computer Properties, advanced system settings, environment variab

IamlaosongAlas, the real soil, used toad, has been using dbms_output.put_line debugging stored procedures, only feel inconvenient, with PL/SQL developer, or use this method, online search, just know can be single-step debugging. Learn to use PL/SQL developer debugging features for writing complex stored procedures, pac

Tags: style blog http ar using SP java on 20141. Premise: The use of Sqldeveloper is based on the premise that Oracle is installed on your machine.2. Just open SQL DeveloperLocate the directory of the JDK you installed, the path I installed is: C:\Java\jdk1.6.0\bin\java.exe or C:\Java\jre6\bin\java.exe. Note that the JDK needs to be available under version 1.6, and the above versions are also available, but errors may occur.3. The following interface

Get ready: PL/SQL Developer: I'm using plsqldev1005 (32-bit) Win32_11gr2_client: Remember that it must be 32-bit, because PL/SQL developer only recognize 32-bit After the installation is successful, you need to configure the environment variables:Tns_admin environment variable, similar to: C:\app\Lzj\

Multi-organizational views are often used in PL/SQL developer. We use the following methods to initialize our environment: 1. Begin Fnd_global.apps_initialize (user_id => 1112, Resp_id => 21872, Resp_appl_id = gt; 201 ); End; 2. Begin Dbms_application_info.set_client_info (: org_id ); End; 3. Begin Fnd_client_info.set_org_context (x_org_id ); End; 4. Begin Fnd_client_info.

Tags: keyword. com change cat protocol names location descriptionOriginal address: http://lightguide.blog.51cto.com/3121539/1140588 Because of their own installation and configuration to go a lot of detours, search online documents Most of them do not contain ORALCE client installation and the corresponding configuration, so write it alone once. This example applies to the Oralce client without the need to install the Instantclient basic package instead. -Required Packages: -pl/

Tags: blog http ar using Java on log HTML EFReasonThe Oracle SQL Developer installed in Oracle 11g is 32-bit, and the java.exe we are assigning to him now is 64 bits, so this error can occur.Workaround1) Download Oracle SQL Developer x64 from the web and replace the original directory: D:\app\oracle\product\11.1.0\db_1

When pl/SQL developer is enabled, the NLS_LANG and Character set (Character set) problems occur. plnls_langStart pl/SQL developer and the NLS_LANG and Character set (Character set) problems occur. The company recently trained pl/SQL. After installation, I started it and enco

Tips for SQL Developer 1. Set the logon password of plsql developer by default. Choose 'tools '--> 'preferences'. In the 'oracle 'column of the window, select the 'store with password' option in 'logon History,Log out of PLSQL and select the database connection name after 'username' when logging on. 2. Set window list of plsql

Steps: Check whether the IP address of the ping server can be pinged. This is to see whether the physical connection to the remote SQL Server 2000 Server exists. If not, check the network and check the configuration. Make sure that the IP address of the Remote SQL

Operating System: Windows 7 64-bit flagship Required. Install PL/SQL developer for development. 1. Download the simplified green version of Oracle Http://www.oracle.com/technetwork/topics/winsoft-085727.html Note that you need to download a 32-bit version, because PL/SQL developer currently only has a 32-bit

machine is: d:/instantclient_11_2/network/admin4, set the language of Oracle, add the environment variable Nls_lang, the value is simplified Chinese_china. Zhs16gbkAssuming that the Oracle language of the remote database is unclear, SSH or telnet to the remote machine, enter in the command interface, and connect to the database with the command line.SELECT * from Nls_instance_parameters;View the value of Nls_languageNls_languageNls_territory5. Download and install the PL.SQL.Developer configura

variable Nls_lang, and the value is simplified Chinese_china. Zhs16gbkIf you do not know the Oracle language of the remote database, you can ssh or telnet to the remote machine, enter it at the command interface, and connect to the database using the command line.SELECT * from Nls_instance_parameters;View the value of Nls_languageNls_languageNls_territory5. Download and install the PL.SQL.Developer configuration appConfigure Tools->preferences->connectionOracle HomeD:/instantclient_11_2OCI Libr

If the OS is a Windows 7 64-bit system, the Oracle version for Oracle 11g 64 installs PL SQL Developer please refer tohttp://myskynet.blog.51cto.com/1471053/623957 HTTP://SUPPORT.MICROSOFT.COM/KB/2585547/ZH-TW1, PL/SQL developer remember login passwordWhen using PL/SQL

When you use the PL/SQL Developer tool to log on to a new user for query, the following error is reported (PL/SQL Developer version: 7.1.51403 ):Dynamic Performance Tables notAccessible,Automatic Statistics disabledFor this sessionYou can disable statistics inThe preference menu, or obtain selectPriviliges onV $ sessio

the table, and if you do, you will be prompted not to export, which is the first and third way to export. The third type is exported to. Pde format, the. PDE is PL/SQL developer own file format, can only be imported and exported by PL/SQL developer; can't use the editor to view, efficiency don't know how PS: Only the

Label:Note: All software is not finally installed under Program Files (x86) PL/SQL Developer show not logged on Open PL/SQL Developer as an administrator2. TNS cannot parse the specified connection identifier　　　　Check the installation directory of the Oracle client software: \oracle\product\10.2.0\client_1\netw

Compare | object | original Pl/sql DEVELOPER 6 Object Comparison function description (original) The Pl/sql DEVELOPER 6 object comparison function is very powerful and practical, and is a necessary tool for developers, mainly for the following purposes: Check for different information for all objects under a

Problem Description: After you open PL/SQL developer, you can read the Oracle database, all aspects are normal, but the correct database user and the wrong password still can connect normally, but the SQL statement execution cannot produce additions and deletions to the database.Cause: PL/SQL

I. PL/SQL Developer data ImportTools->import TablesThe corresponding path is the path of the Sqlplus.exe, in general, in the \app\admin\product\11.2.0\client_1\bin\sqlplus.exe.The imported path is the path of the SQL file that you need to import, click Import to implement the import operation.Ii. PL/SQL