Oracle variable definition and use (another, T-SQL exists plsql alternative notation)

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,

SSH Secure Shell Client Connection Linux command line display Chinese garbled problem and Oracle query data Chinese garbled problem

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

Installing Oracle 11gR2 under CentOS 6.4

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~

Go Dynamic SQL detailed in Oracle

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,

Workaround for the Oracle Database runtime RM mistakenly deleted files (2)--Recovery by script

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

Oracle 11g Client Download Address

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 Automatic memory management SGA, PGA explained

ASMM Automatic shared memory management:Automatically adjusts to workload changesMaximize Memory utilizationHelps eliminate out-of-memory errors[email protected]>show parameter SGANAME TYPE VALUE------------------------------------ ----------- ------

Docker Combat---Using Oracle XE as a development database (vi)

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,

Oracle error ORA-00604 Recursive SQL Level 1 Error ora-00942 table or attempt does not exist ORA-06512 in line 11

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

Oracle 12c new features VARCHAR2 length maximum support up to 32767

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

Linux Installation Oracle

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

Disable Oracle cannot connect after booting, network adapter error handling

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 10g

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

Use SQL Developer to port SQL to Oracle (5)

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

How to Create a DB Link for an Oracle database to operate a remote database

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

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

ORA-06502: PL/SQL: numberic or value error: character string buffer too small

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

Oracle wait event

  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

Oracle study notes 18-stored functions and stored procedures (PL/SQL subprograms)

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

Total Pages: 2147 1 .... 128 129 130 131 132 .... 2147 Go to: GO

Contact Us

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

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.