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

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

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

1, viewing the number of system configuration cursorsSelectValue fromV$parameterwhereName= 'open_cursors';2, viewing cursor usageSelectO.sid, Osuser, Machine,Count(*) num_curs fromv$open_cursor O, v$session swhere user_name = 'xftest'

--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. 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 database design paradigm is a very important concept, but this important degree is only suitable for reference. Using the database design paradigm, you can make the data table better to save the data, because the reasonable design, if the data

A view is a very important database object in the form of a normal table, and we can query the data from the view.In fact, it is a virtual table built on a table that does not store real data in the view, but simply saves a SELECT statement, and

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 stored procedure for sending messagesCREATE OR REPLACE PROCEDURE send_mail (p_recipient VARCHAR2,--Mail recipientP_subject VARCHAR2,--Mail headerp_message VARCHAR2--Message body) is--The following four variables should be assigned

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