Oracle

First, row to columnYou need to use the following format, for exampleConvert to:This is the most common row-to-column, the main principle is the use of the Decode function, aggregation function (sum). Combined with the group by group

Sequence: is a database object provided by Oacle to produce a series of unique numbers.L automatically provide a unique valueL Shared objectsL mainly used to provide primary key valueL Loading sequence values into memory improves access efficiencyTo

Summary of Oracle's tablespaces, partitioned tables, and indexesKeywords: Oracle, table space, partition table, indexThe first time last week to do database testing encountered a lot of questions to summarize:Table Space:Oracle's UNDOTBS01.DBF file

System environment: Win7 32-bit systemInstallation steps:1,oracle (Oracle) Download the appropriate database installation package,http://www.oracle.com/technetwork/cn/indexes/downloads/index.html#database2, download There are two packages Win32_11gr2

Source to: http://jvortex.blog.163.com/blog/static/16961890020122141010878/We know that indexes are database objects that are used to speed up database queries. The principle is to reduce the IO operation of the query, so as to achieve the purpose

I. Distinctions and definitionsLong : variable long string data, longest 2g,long with VARCHAR2 column, can store long text up to one long column in a table　　Long RAW: variable Long binary data, up to 2G　　CLOB: character large object CLOB used to

first, the basic operation of the database1, create a user SQL> Create UserUser name identified bypassword;2, Super User system gives new user rights SQL> GrantConnect, Resource toMike; Authorized connection permission to delete and modify

　　　Oracle Database OperationsOne: Unlock Scott/tiger users (Locked)Alter user Scott account lock; --LockAlter user Scott account unlock; --UnlockAlter user Scott identified by Tiger; --Change PasswordGrant DBA to Scott; --Assigning permissionsSecond:

From:Information on installed Database components and Schemas (document ID 472937.1)Note: This article is a lot of content, do not do all the translation, only listed the following directory and the Oracle database comes with the user:1. Jserver

Referenced from: http://www.2cto.com/database/201307/224836.html ORACLE create a self-increment field method-oracle A simple introduction to sequence first, let's assume there's a table:Create table S_depart ( departid INT

Goldengate is the industry's mature data disaster recovery and replication products, 1995GoldenGate company was founded in 1995, San Francisco, California, USA. Acquired by Oracle Corporation in 2009.Pros: 0 Downtime Database upgrades and migrations,

a oaf page personalization needs:Supplier Query page, for a duty, the user can only query vendors with the vendor type of "employee" and cannot query other types of vendors. Personalization Steps:first refer to the article "Enable OAF page

Official Document: http://docs.oracle.com/cd/E11882_01/server.112/e40540/schemaob.htm#CNCPT15141. Oracle supports 1024K-1 partitions, and tables with a long or long raw data type are not allowed to create partitions. CLOB and Bclob can.When to

Oracle 11GR2 RAC installation configuration -- GI installation Configuration 1. Install Grid Infrastructure software1.1 deploy the software package, as shown in the following figure: There was a movie called qijianxia Tianshan. Here, the Oracle

Oracle custom exception 1. The error box is displayed: Sample Code: Declare v_count number; begin select count (*) into v_count from dept; if v_count Execution result:   2. console display: Sample Code: Declare v_count number; my_exp

Oracle Study Notes (7) -- Advanced query (1) Before learning advanced queries, let's take a look at how to view all the tables in the Oracle database. This is because we need to use several tables under the SCOTT user in the Oracle database (these

Oracle Database 11g For Windows 7 flagship version installation, 11gwindows7 System Environment: win7 32-bit System   Installation steps: 1, Oracle (Oracle) official website download suitable for their own database installation package,

After OracleLinux6 is restarted, the content of the/etc/hosts file is changed. Applicable: Linux OS-Version Oracle Linux 6.1 and laterLinux x86Linux x86-64 Symptoms:After Oracle Linux6 is restarted, Network Manager edits the/etc/hosts file.For

Basic query of Oracle tables Oracle Paging 1. rownum Paging Select * from emp; Select a1. *, rownum rn from (Select * from emp) a1; 2. Display rownum (allocated by oracle) Select a1. *, rownum rn from (Select * from emp) a1 where rownum

Oracle pl/SQL common functions, oracleplsql Functions On csdn, I also saw a post called Oracle common function 110. after a rough look, there are many data calculations, such as covariance. I don't think I have used much. I can see it today, but it