Oracle

Today wrote a few hours of SQL statements, at the beginning I did not train of thought, the idea began to write.First I query the storage table in the 3-level units under the various outlets of the storage information, find this information, I went

1) Create a sequence:Create sequence Seq_test--field name MinValue 1--Minimum value MaxValue XXXXX--set maximum start with 1--count from 1 increment by 1          --Add 1 nocycle at a time--always accumulating, not circulating nocache; --Do not

From Wolfaone, Oracle has no integer type, what is the maximum value of this type?Integer is a subtype of number type:Number TypeThe number datatype to store fixed or floating point numbersof virtually any size. You can specify precision, which are

#!/bin/bashEcho-e "\n\n*********~~~~~~~~~~~~~~~~~~~~~~~~~~~~date:" ' DATE ' +%y/%m/%d%T ' "~~~~~~~~~~~~~~~~~~~~~~~*********" >>/home/oracle/tablespace.logExport Path=/opt/oracle/1102/db01/bin: $PATHExport

OracleFirst, the dataThe DB data fields are as follows:task_id             task_name          t.parent_task_id       ******                       ***                           ***                                 ***000001             t1              

1. Modify the table field type  /* modify the name of the name name_tmp*/ALTER TABLE ca_cadocument rename column cd_taskids to cd_taskids_t; */ Add a field with the same name as the original field name name*/ALTER TABLE ca_cadocument add Cd_taskids

View database lock Select object_name, machine, S.sid, s.serial# from Gv$locked_object L, dba_objects o, gv$session s WHERE l.object  _id = o.object_id and l.session_id = S.sid;  Close a sessionalter system kill session ' 305, 48290 '; Take a look

1. Overview of the ViewA view is actually a query SQL statement that displays related data in one or more tables or other views. The view uses the results of a query as a table, so the view can be thought of as a stored query or a virtual table.

Here are Some of the concepts that I learned from my own understanding of Oracle, which may be the wrong cognitionA database can be built using the graphical interface at 1.windowsSee Baidu: Http://jingyan.baidu.com/article/90bc8fc80c01f2f653640c1f.

First need to have local Sqlplus command, if not need to download the official website can also click I download (decompression readme.txt has installation configuration instructions):in the Oracle official website Download instant Client for OS X.

MySQL stored procedures(1). FormatFormat created by the MySQL stored procedure: CREATE PROCEDURE procedure name ([process parameters [,...]])[Features ...] Process BodyCase Analysis:ParametersThe parameters of the MySQL stored procedure are used in

The role of the parameter file:They are loaded at the start of the database instance, which determines the physical structure of the database, memory, database constraints and the system of a large number of default values, the various physical

Select COUNT (*) from (SELECT COUNT (*) from table name GROUP by multiple data volume) table name;Give me a chestnut:For example, I have a field of data type, there are many kinds of data types.  And each data type has data for nearly some years. Is

1 CreateType Tabletype is Table of varchar2( the);2 CREATE OR REPLACE FUNCTIONSplit (P_list CLOB, p_sepVARCHAR2:= ',')3 RETURNTabletype4 pipelined5 /**************************************6 * Name:split7 * Author:sean Zhang.8 * date:2012-09-03.9 *

--To create a test table:CREATE TABLEMM (ID Number, NAMEVARCHAR2( -)); CREATE TABLEMN (ID Number, NAMEVARCHAR2( -)); --Inserting DataINSERT intoMmVALUES(1,'A'); INSERT intoMNVALUES(1,'B');--Test MergeMERGE intoMN A USING MM B on(a.id=b.id)

1) Create a sequence: 1234567 createsequenceSEQ_TEST --字段名minvalue 1        --最小值maxvalue XXXXX      --设置最大值start with 1      --从1开始计数increment by1    --每次加1个nocycle           --一直累加，不循环nocache;          --不建缓冲区 2) sequence

--substr (string, intercept start position, intercept length) = return the intercepted wordSelectSubstr'miaoying',0,1) fromDual--The returned result is: MSelectSubstr'miaoying',1,1) fromDual--The returned result is: m--description 0 and 1 both

Modify Host Name[Email protected] ~]# sed-i "s/hostname=localhost.localdomain/hostname=oracledb/"/etc/sysconfig/network[Email protected] ~]# hostname oracledbAdd host name and IP correspondence record[Email protected] ~]# vi/etc/hosts192.168.1.160

1. Software Preparation:centos6.7 (64-bit);ORACLE11GR2 ((Linux x86-64))2, execute the following command to install the relevant package:Yum-y install \Binutils \COMPAT-LIBCAP1 \COMPAT-LIBSTDC++-33 \compat-libstdc++-33*.i686 \Elfutils-libelf-devel

Common basic types of 1.oracle databasesCHAR (Ten)--store a fixed-length stringVARCHAR2 (Ten)--storing variable-length stringsDateinteger-to-store integersNumber (p,s)-->p the maximum number of digits that can be saved to the database, including the