,--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: = Pagenow * PAGESIZE;BEGIN--Executive SectionV_sql: = ' select *
,--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: = Pagenow * PAGESIZE;BEGIN--Executive SectionV_sql: = ' select *
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
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"-
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
if not yet.4, sometimes may appear the client to the Chinese support bad question, may refer to the following third article environment variable setting:On the desktop, right-click My Computer, select Properties, select Environment variables in the Advanced page, and in the system variables, increase:1) variable name: oracle_homeVariable Value: E:\instantclient_11_22) variable name: tns_adminVariable Value: E:\instantclient_11_23) variable name: Nls_
));}} catch (exceptione) {e.printstacktrace ();} finally{try{cs.close(); Conn.close (); Rs.close ();} catch (sqlexceptione) {e.printstacktrace ();}}} */
Exception handling for PL/sql: Oracle divides exceptions into: pre-defined exceptions, non-predefined exceptions, and custom exceptions three. The first two are used to deal with Oracle errors, and the resulting Oracle errors implicitly trigger the
PL/SQL personal learning notes (2) and plsql personal learning notes
IF condition
DeclareCursor s is
Select version from city_server t;
S _ city_server.version % type;
Begin
Open s;
Fetch s into s _;
If s _> 2
Then
DBMS_OUTPUT.put_line (s _);
End if;
Close s;
End;
LOOP
Declare
Cursor s is
Select version from city_server t;
S _ city_server.version % type;
Begin
Open s;
Loop
Fetch s into s _;
Exit wh
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
/downloads/soapui.html) from SOAPUI official website and install it, then open the program File-new SOAP ProjectFill in wsdl:http://xxxxxx:port/adminservice/adminservice?wsdl Note: Port is the same as the ports in the Analytics appClick OK, the following screen appears, followed by the steps shownAfter clicking Execute, an unauthenticated prompt appears.This is because we have a security policy configured for Web services, so we must provide the user name and password as shown in:Click OK, at th
1.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 create a network/admin-level folder underneath the directory,For exa
1. Check the server code:Execute SQL Syntax: SELECT * FROM V$nls_parameters;2. Set the local client code:Enter My computer, properties, advanced, environment variables, add 2 items: LANG=ZH_CN. GBK nls_lang=simplified Chinese_china. Zhs16gbk3. PL/SQL Developer set up and reconnect:In the
After Oracle 10 Gb is installed, a table is created to write Chinese data. It is found that the PL/SQL developer tool cannot display Chinese normally.
To display Chinese characters properly, the server must be consistent with the client encoding. Therefore, check.
1. Check the server code:
Execute SQL Syntax:
Select * from V $ nls_parameters;
You can als
, native set to: oracle home:d:\oracle\app\ym\product\ INSTANTCLIENT_11_2NBSP;OCI library:d:\oracle\app\ym\product\instantclient_11_2\oci.dll4) Set environment variables ( Modify path and tns_admin environment variable) for Nls_lang environment variables, it is best to set to the same database side, first query the character set information from the database side:sql> Select USErenv (' language ') Nls_lang from dual;nls_lang---------------------------------------------------- simplified Chinese
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. Zhs16gbk Right-click My Computer-Properties-advanced-environment variables-system environment variables:1> Select "Path"
empno = no;-- Calculate income taxV_tax_sal: = v_sal * v_tax_rate;-- OutputDbms_output.put_line ('name: '| v_ename | 'payroll' | v_sal | 'tax payable: '| v_tax_sal );End;-- Composite---- Pl/SQL records are similar to structures in advanced languages-- Define a plsql record type emp_record_typeDeclareType emp_record_type is record (aname emp. ename % type, salar
Tags: control = = Timestamp amp time Oracle Relationship acquisition conditionIn the recent work to use stored procedures and functions, simply take PL/SQL as a whole to look at. I've seen the basic books and the blog posts in the garden, and I'll summarize what we've learned here.First, the basic statement1. Case2, separators--;3. Reference string-"'4, Brackets-
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.