advanced pl sql tutorial

Use NotePad to create a new tnsnames. ora file and save it to this path: C: \ instantclient_11_2_x86 \ Network \ admin \ tnsnames. ora For details, refer to the following Configuration: My_xxxserver =(Description =(Address = (Protocol = TCP) (host = 10.199.200.102) (Port = 1521 ))(CONNECT_DATA =(SID = oravm)(Server = dedicated))) 4. Extract PL/SQL to the target machine, for example, c: \ Program F

Software environment: 64-bit win7, 32-bit Oracle 10g, PL/SQL 9.0.4.1644 In the past, 32-bit systems were used for development and suddenly switched to 64-bit systems. The installation environment was a little troublesome, especially for PL/SQL, which only supported 32-bit systems. I read a lot of materials, but some pr

Software environment: 64-bit win7, 32-bit Oracle 10g, PL/SQL 9.0.4.1644 In the past, 32-bit systems were used for development and suddenly switched to 64-bit systems. The installation environment was a little troublesome, especially for PL/SQL, which only supported 32-bit systems. I read a lot of materials, but some pr

:5) The installation is successful, and the C-drive has an Oracle folder:6) Set the PATH environment variable to the Oracle client:A) first copy the path where the environment variables need to be set:b) Environment variables, advanced system settings, properties--right-click ComputerPath begins with a semicolon-delimited path and path:7) Configure PL/SQL Develop

) For the NLS_LANG environment variables, it is best to set them to be consistent with the database. First, query the character set information from the database: SQL> select userenv ('language') nls_lang from dual; Right-click "my computer"-"properties"-"advanced"-"environment variables"-"system environment variables ": 1>. Select "Path"-click "edit" and add "D: \ app \ min \ product \ 11.2.0; 2>. Clic

Instantclient_12_1 directory: C:\XX\XX\XX\instantclient_12_13.OCI Library changed to path with Instantclient_12_1: C:\XX\XX\XX\instantclient_12_1\oci.dllThen, the app--OK--closes plsql_developer, restarts, and logs on successfully.In addition, if there is a problem with Chinese garbled, you canView registry Values Hkey_local_machine\software\oracle\key_oradb12home1Enter the registry: Win+r, enter regedit, then return, click HKEY_LOCAL_MACHINE--->software---> ORACLE--->home, find Nls_lang (if no

variables) for nls_lang environment variables, it is best to set to the same as the database side, first query the character set information from the database side: Sql> Select Userenv (' language ') Nls_lang from dual; Right-click My Computer-Properties-advanced-environment variables-system environment variables: 1> Select "Path"-click "Edit" toAdd "D:\app\min\product\11.2.0;" 2> Click " new", t

Tags: data import test reg Microsoft software question mark condition technology sharingProblem Description:Login PL/SQL, the output of the Chinese caption is displayed as a question mark after executing the statement???? If the condition contains Chinese, there is no data. ? ?? ?If it is not Chinese, you need to modify the registry value as follows:Enter the registry: Win+r, enter regedit, then return, cli

path and tns_admin environment variables)For Nls_lang environment variables, it is best to set to the same as the database side, first query the character set information from the database side:Sql> Select Userenv (' language ') Nls_lang from dual;Nls_lang----------------------------------------------------Simplified Chinese_china. Zhs16gbkRight-click My Computer-Properties-advanced-environment variables-system environment variables:1> Select "Path"-

select Properties, advanced, environment variables, system variablesAdd the following two variablesTns_admin E:\Program Files\plsql Developer\instantclient_12_1\network\adminNls_lang simplified Chinese_china. Zhs16gbk5. Download and install the PL.SQL.Developer configuration appConfigure Tools->preferences->connectionOracle HomeE:\Program Files\plsqldeveloper\instantclient_12_1OCI LibraryE:\Program Files\plsql Developer\instantclient_12_1\oci.dllThe

----------------------------------------------------Simplified Chinese_china. Zhs16gbkRight-click Computer-Properties-Advanced system settings-environment variables-system environment variables:1> Select "Path"-click "Edit" to add "D:\oracle\product\instantclient_12_1;"2> Click "New", the variable name is set to "Tns_admin", the variable value is set to "D:\oracle\product\instantclient_12_1;", click "OK";3> Click "New" and the variable name is set to

Administrator: SYSTEM (password: manager)(3) Super administrator: SYS (password: change_on_install)After the modification is complete, click OK ". In the "finish" window, click "close. Step 2: Decompress the instantclient-basic-nt-11.2.0.3.0 to the installation directory I put it in the F: \ CMDL \ product directory Step 3: install and configure PLSQL Developer PLSQL Developer can be installed normally. The configuration is as follows: After the installation is complete, run

(password: change_on_install) when the modifications are complete, click OK. In the Finish window, click Close. Step two: Decompression instantclient-basic-nt-11.2.0.3.0 to the installation directory I put it under the F:\Oracl\product directory. Step Three: Install and configure Plsql Developer Plsql Developer Normal next installation can be. The configuration is as follows: After the installation is complete, run PL/

3) Set environment variable (modify path and tns_admin environment variable) . for Nls_lang environment variables, preferably set to and is consistent, first query the character set information from the database side:sql> select Userenv (' language ') Nls_lang from dual; nls_lang----------------------------------------------------simplified Chinese_china. zhs16gbk Right-click on "My Computer"-"Properties"-"advanced"-"Environment variables"-

Tags: writing character db instance DMI cancel Tor auth add client1.DownloadInstantclient_11_2.zipPL/SQL2.Unzip the instantclient_11_2.zip to the appropriate folder,For example: E:\oracleclient\instantclient_11_2,--------------------------------------------------------------------------------Write a Sqlnet.ora file under this folderContent:NAMES. Directory_path= (TNSNames)Sqlnet. Authentication_services= (NTS)--------------------------------------------------------------------------------Then cr

configuration. Here we choose to use the install-free Oracle client. Reason:1. easy to use. 2. not with other dependent Oracle the program conflicts. 1. Download instantclient-basic-nt-11.2.0.3.0.zip Just download the Instantclient-basic-nt-11.2.0.3.0.zip, and the rest is a package that expands according to different needs.: http://www.oracle.com/technetwork/topics/winsoft-085727.html 2.unzip to the local machine because we now both the client and the server are on the local machine, all I un

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, advanc