1. Simple VariablesDECLARE v_cnt number (10,0): = 0; BEGIN SELECT COUNT (1) into v_cnt from concept. decoction WHERE Decoctionid =-1; IF v_cnt = 0 Then insert INTO concept. Decoction (Decoctionid, Code, Name, Mnemoniccode, Spellcode, Wbcode,
One, SSH Secure Shell Client Connection Linux command line display Chinese garbled problemLinux Setup System languageModify the/etc/sysconfig/i18n file, asLang= "en_US. UTF-8 ", Xwindow will display the English interface,Lang= "ZH_CN. GB18030 ",
Pre-Installation Instructions:
The minimum memory (RAM) requirement is 1GB, which is recommended for 2GB and above.
Virtual Memory Swap recommendations: The recommended swap size is 1.5 times times the memory size when the memory is 1GB~
This article was reproduced from: http://www.cnblogs.com/gaolonglong/archive/2011/05/31/2064790.html1. static sqlsql and dynamic SQLThe Oracle compiled PL/SQL program block is divided into two types: one for the pre-assembly (early binding), that is,
According to the previous article, the entire recovery process can be done using scripting, saving time and increasing the success rate of recovery.This method is valid for data files that are mistakenly deleted, including online Redo,undo,control
Excerpt from: http://blog.csdn.net/davidhsing/article/details/8271845Oracle Database Instant Client 11g 11.2.0.3.0The Instant client is a lightweight database client released by ORACLE (R) that allows you to run OCI, OCCI, Pro*c, ODBC, and JDBC
Oracle is the big guy for OLTP, and it's used by many industry applications. So in the process of development of the inevitable use of Oracle database, Oracle database version has a lot of, where the Express version is a free development version,
The error is as follows:Search a lot of methods, but there is no way to solve, but eventually found a good solution,Thanks to the man's blog, "http://blog.itpub.net/519536/viewspace-689469."The content is purely reproduced, suggest to the original
Prior to the Oracle 12c version, the VARCHAR2 and NVARCHAR2 data types had a maximum length of 4000, with the extended maximum of 12c versions supported to 32767, or 32KB, and parameter Max_string_ The size is the maximum length of the extended data
DirectoryFirst, hardware requirementsSecond, the softwareThird, System installation noteIv. System Readiness prior to Oracle installationV. Install Oracle and set up the settingsSix, upgrade Oracle to Patchset 10.2.0.4Vii. using Rlwrap to invoke the
No Oracle cannot connect after booting,Turn around: http://blog.sina.com.cn/s/blog_4aeef1220100fmsr.htmlTNS-12560:TNS: Protocol Adapter errorMicrosoft Windows [version 5.2.3790](C) Copyright 1985-2003 Microsoft Corp.C:\Documents and
Oracle 10g and Oracle 11g hand-built case--oracle 10gSystem environment:Operating system: RedHat EL6Oracle:oracle 10g and Oracle 11gThe Manual construction of the library is relatively easy to implement, this case is from 10g and 11g, by hand to
Oracle Core Technology notes (this book is not carefully read, so you need to read it later ~~)Oracle Core Technology jump to: navigation, search
DirectoryStart 12redo and undo3. Transactions and consistency4. locks and latches5 cache and
This section describes how to useSQL DeveloperPort SQLOraclePart 5: transfer data.
In the previous section, the Migration wizard automatically generated the table structure we needed in the Oracle database, but it did not help me to import the data
OracleOperationRemote databaseYou can useCreate a DB LinkThis document describes the creation process in detail. Now let's get started. Assume that the local IP address is 192.168.1.11, database instance orcl, User name: tysp, password: test Remote
FAL [client]: Failed to request gap sequence GAP, falgapI. Problem Description
After the host where the master and slave databases are located is restarted, rac (master database) is automatically started upon startup, but the slave database (Single
Today encountered an error prompt: ORA-06502: PL/SQL: numberic or value error: character string buffer too small, the general corresponding Chinese information is: ORA-06502: PL/SQL: incorrect number or value: the string buffer is too small. During
Wait for the event source to start
The concept of wait events is introduced from ORACLE 7.0.12, with roughly 100 wait events. In ORACLE 8.0, this number has increased to approximately 150, with approximately 220 events in ORACLE 8I and about 400
PL/SQL subprograms include functions and procedures. The function here refers to the user-defined function, which is different from the system function. A subroutine is a PL/SQL block that completes a specific function. It is universal and can be
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.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service