advanced pl sql books

In the software development process, programmers often encounter string splicing and splitting work.Take Java development as an example:The foreground passes in a string concatenation of a JSON data, such as: "1001,1002,1003", which may represent a set of ordinal numbers.Programmers need to turn the serial number to the name and output it in the same format, such as: "Zhang San, John Doe, Harry".The common practice of Java programmers is to split the "1001,1002,1003" received at the service laye

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> Click "New" and the variable name is set to "Nls_lang" and the variable value is set to "simplified Chinese_china. ZHS16GBK ", click" OK ";2> New environment variab

In a 64-bit Win8 system, the Pl/SQL connection Oracle setup tutorial, win8oracle On Windows 8 64-bit system, 64-bit Oracle is installed, but there is no 64-bit PL/SQL, And the Oracle database cannot be connected. What should I do? There are some methods: we can install a 32-bit Oracle client to achieve the connection.

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

) 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

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

PROCEDURE fenye (TABLENAME in VARCHAR2,PAGESIZE in number,--Display records per pagePagenow in number,--Number of pagesMyrows out number,--Total recordsMypagecount out number,--Total pagesP_cursor out Testpackage. Test_cursor) is--the recordset returned --Definition section--Define the SQL statement stringV_sql VARCHAR2 (1000);--Definition of two integersV_begin Number: = (PAGENOW-1) * PAGESIZE + 1;V_end Number: = Page