Oracle

--increase the primary key IDAlter TableClerk_compareAddId Number( -);--set sequence to make the ID self-incrementCreatesequence seq_id MinValue1MaxValue999999999Start with 1;--set the value of the ID to

Recently Idle, researched the next Oracle, the following is the entire process of installing Oracle under Win7:Then unzipClick setup.exeI'm using the default installation D drive.The database password is Wangxiaofei.NextFirst on your own Windows 7

This article summarizes Oracle's database management, with a focus on its physical storage section.Some SQL commands:Manually switch redo log file groups:Switch logfile;To add an online redo log file group:4 ('/oradata/log4a.log','/oradata/log4b.log'

Three. Character functions (can be used for literal characters or database columns)1, String interceptSelect substr (' abcdef ', 1,3) from dual2, finding the substring locationSelect InStr (' Abcfdgfdhd ', ' FD ') from dual3, String connectionSelect

After the DB server restarts, the following error is attached:The reason is that Listener.ora is reverted to the initial file after reboot and the SID is emptied.Steps to resolve:1. View monitoring service and database service:This is where you find

Http://www.lab128.com/rac_installation_using_vb/article_text_ch.htmlenvironment variable SettingsPath= $PATH: $HOME/binExport PATHtmp=/tmp; Export TMPTmpdir= $TMP; Export TMPDIROracle_base=/u01/app/oracle; Export Oracle_baseOracle_home= $ORACLE

This blog post describes how to silently install oracle11g (11.2.4.0) under a Linux system. Mainly used for graphical display inconvenient scenes, but also for scripted batch deployment needs.System environmentOs:oracle Linux Server Release 6.7The

Create a test tableCREATE TABLE Base_users(UserID VARCHAR2 (16),Username VARCHAR2 (32),passwd VARCHAR2 (16)) Tablespace Cat_data;In an insert-by-line wayCreate or replace procedure Insert_data_one_by_one (n in number)AsCurrentID Number (16): =

--1. Character functions--upper (String|column) can turn characters into uppercaseSelect Upper (' Helloword ') from dual;Select Upper (ename) from EMP;--lower (String|column) converts the specified string to lowercaseSelect lower (' Helloword ')

Requirement: Sort a string that contains numbersAfter search, refer to http://www.cnblogs.com/m-cnblogs/archive/2012/03/30/2425938.htmlScreenshot:(To_number (str,split 1,...) InStr () Replace () substr ())TO_NUMBER(x [, format], [ nls_language

Set before 11g: Sga_target11g version setup: Memory_target (auto-allocate SGA and PGA size)To view memory current memory size:Sql> Show Parameter SGASql>show parameter Memory_targetStatement:alter system set MEMORY_TARGET=4G Scope=spfile; Restart

This question I let me engage in the most of the day, really irritating, words do not say, directly on the codeSELECT * (SELECT COUNT (*) from table_name C where c.bbs_id=t.id) as Plcount,//subquery plcount to sort virtual fieldsFrom table_name t

I. Related content1. Understand the concepts and types of indexes.2. Master the command to create the index.3. Understand the concepts and advantages of the view.4. Understand the features that updatable views should have.5. Master commands for

I. Related content1. Master the use of OEM tools to create, modify, and delete tables.2. Master the use of SQL statements to create, modify, and delete tables.3. Master the use of SQL statements to insert, modify, and delete data.4. Understand the

WebLogic configuration details: "WebLogic Installation and Configuration Diagram"Oracle+plsql configuration details: "PL/SQL access to remote Oracle Server (multiple Ways)"MyEclipse configuration: "Eclipse in the development of Web project

1. Create an index:(1). Single-Column indexCreate index name_index on outpatient expense record (ID)(2). Composite IndexThe same table can have multiple indexes, but the combination of required columns must be different.-For example:Create index emp_

The following summarizes two ways, one is auto-generated using Oracle's Sys_guid function, and the other is using sequence,Method One:Select Sys_guid () from dualInsert into T_store (store_id, Store_name, store_price,create_date,end_date)VALUES

1. Create a table space first Create tablespace tablespace name datafile data file path (data file with DBF suffix) size data file, default storage (initial 128K next 128K maxextents Unlimi Ted Pctincrease 0) minimum extent 128K; The red part

After successfully installing Oracle 11g, a total of 7 servicesThe meanings of these seven services are:1. Oracle ORCL VSS Writer Service:Oracle Volume Mapping copy write service, VSS (Volume Shadow Copy service) enables the creation of

Oracle and Google have returned to court, a dispute that began in 2010, when Oracle first sued that "Google uses 37 Java APIs (application interfaces) in the Android operating system." The original verdict in the case was in favor of Google, but the