Oracle

1. First create the package with PL/SQL1 Create or ReplacePackage Excutebatchoperate2 as3Type Sqlstr_array is Table of varchar2( +)Index byBinary_integer;4 procedureExcutebulkdata (sqlstrinchSqlstr_array);5 EndExcutebatchoperate;2. Create a

A complete Oracle database is typically made up of two parts: an Oracle database and a database instance.1) The database is a collection of a series of physical files (data files, control files, online logs, parameter files, etc.);2) The Oracle DB

Preface: Just contact Oracle database, there is a need, write console program, realize the owner login. The database is Oracle. The following is a detailed description of the MyEclipse connection to the Oracle database.

This article was transferred from: http://blog.sina.com.cn/s/blog_439f80c4010094n1.htmlTo create a primary key:ALTER TABLE T add primary key (V)T is the name of the table, and V is the column nameTo create an index:Create INDEX

Foreword: For the project reason, recently began to learn Oracle database. Oracle is one of the most popular databases, powerful, excellent performance, relative to the difficulty of learning is still not small. I am going to record my learning

Dbms_random is a PL/SQL package provided by Oracle for generating random data and characters. It has the following functions.Of these, the Initialize,random,terminate function is deprecated in oracle11g and is mainly used for backwards compatibility.

Database version:SOURCE Library: 11.2.0.4Destination Library: 11.2.0.1The operation is as follows:When importing the source library EXPDP data into the destination library, there is a partitioned report with the following errorOra-14460:only one

First, the demandWhen will Oracle cursors be used, and for, loops, if?First look at such a requirement:There is a student lecture form t_teaching, each student has several courses: Primary Key ID (self-increment) Course Number

First, IntroductionApplication to synchronize Oracle updates and delete data, consider using Oracle's flashback query mechanism.This mechanism first requires Oracle to enable the automatic management of the undo table space Rollback information, and

It is well known that several result set collection operations commands, tested today in detail, found some problems and recorded the preparation.Suppose we have a table student that includes the following fields and data:drop table student;CREATE

In Oracle 12c, you can use sequences of and NEXTVALCURRVAL的值作为默认值，来实现列自增！One, the use of the sequence ofNEXTVALandCURRVAL的值作为默认值Create a sequenceCREATE SEQUENCE T1_seq;Build tableCREATE TABLE numberDEFAULT VARCHAR2 (());Inserting dataINSERT intoT1

During the installation of Oracle 11g R2, this error occurred while creating a new DB instance, and if you select Ignore, a ora-28000 error occurs. Through the network query verification, this is the first configuration of the administrator password,

Http://blog.sina.com.cn/s/blog_6a01140c0100wimi.html1. Randomly take records from the tableSELECT * FROM (SELECT * from staff ORDER by Dbms_random.random)Where RowNum To randomly fetch 3 records from the staff table2. Generate Random NumbersSELECT

So easy! Oracle installation Configuration series six on LinuxIn the previous few, we installed the Oracle database software, created a database configuration monitoring, this is the last article of this system, Oracle Enterprise Manager

One, handling errors1. When the error occurs in Oracle Form PL/SQL, the method is handled as follows:begin if Then fnd_message.set_name (Appl_short_name, message_name); Fnd_message.error; Raise Form_trigger_failure; End if ; End;2.

Oracle Shared Services connection static registration serviceThe default Oracle Shared service is registered with the dynamic registration service.[email protected] > select * from v$version where rownum=1;BANNER--------------------------------------

Linux/windows System Oracle Database simple Cold standby synchronizationWe have a financial system that values the security of financial data, while we have two systems, one production environment (Linux), and one Emergency backup environment

Address: http://www.cnblogs.com/juddhu/archive/2012/03/07/2383101.htmlMeaning explanation:Decode (condition, value 1, return value 1, value 2, return value 2,... Value N, return value N, default value)The function has the following meanings:IF

MyEclipse connects to the Oracle database (required for beginners), myeclipseoracleAs soon as I got started with Oracle databases, I had a need to write console programs to achieve master login. The database is Oracle. The following describes how to

Summary of basic Oracle database knowledge (1): Basic oracle knowledge Database Name, Instance name, database domain name, global database name, and service name are several confusing concepts for many beginners. I believe that many beginners are