Oracle

1. Create a temporary table spaceCREATE temporary tablespace test_temptempfile ' C:\oracle\product\10.1.0\oradata\orcl\test_temp01.dbf ' SIZE 32MAUTOEXTEND ONNEXT 32M MAXSIZE 2048MEXTENT MANAGEMENT LOCAL;2. Create a user table spaceCREATE tablespace

CREATE OR REPLACE ProcedureSoa_getpager (p_pagesizeInt,--number of records per pageP_pagenoInt,--Current page number, starting from 1P_sqlcolsVarchar2,--Select ColumnsP_sqlfromVarchar2,--table name or join queryP_sqlwhereVarchar2,--query

The concept of Locks A lock is a mechanism that a database uses to control concurrent access to shared resources. Locks are used to protect data that is being modified No other user can update the data until the transaction is

Create or Replace function isexist (data in datatypes) --datatypes is the type of the data in the tablereturn numberIsV_flag number (2);V_data [datatypes]; --Types of data in tablesBeginSelect data into V_data from table_name where ...;If v_data

A function in the database contains four parts: declaration, return value, function body, and exception handling. --Functions with no parameters Create or Replace function Get_user return VARCHAR2 is V_user VARCHAR2 (50); Begin Select

Additions and deletions to check the orthogonal connection to create a table:　　　　CREATE TABLE table_name (num int identified (+) not NULL,--identified self-incrementName VARCHAR2 () not NULL,--not null is not emptyAge VARCHAR2 (20),Sex VARCHAR2

Create or replace PROCEDURE CLEAR asTname varchar (200);BEGINtname:= ' immediate trace name Flush_cache ';------->> in this sentence, the function of single quotation marks is equivalent to an escape character, and one of the single quotes is

It's done 2 o'clock in the morning every day.Dbms_job.submit (V_job, ' lv; ', TRUNC (sysdate+1) +2/24, ' TRUNC (sysdate+1) +2/24 ');And the definition job, it's best to define it.Declare job1 number;begindbms_job.submit (job1, ' lv; '), TRUNC

Insert INTO DemoSELECT * from demo as of Timestamp to_date (' 2015-11-16, ' yyyy-mm-dd hh24:mi ')The data is queried to a time in the table, and then inserted.Other SQL statements:Select Current_scn from V$database;SELECT * from Chg_invoice_cancel

Oracle de-weightCreate TableTmp_table3 as (SELECTseqno from(SELECTT.seqno,rowid, row_number () Over(PARTITION byTitle, UInORDER bycreatetime) DUP fromCalendar_info TwhereIsdelflag= 0 andSpecialtype= 1

First, create data1.1. Create tables and insert dataCREATE TABLEDISTRICT (ID Number(Ten) not NULL, parent_id Number(Ten), NAMEVARCHAR2(255BYTE) not NULL);ALTER TABLEDISTRICTADD ( CONSTRAINTDISTRICT_PKPRIMARY KEY(ID));ALTER TABLEDISTRICTADD (

There are two ways to view Oracle instances:1. Tnsnames.ora, Listener.ora files in the installation directory650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M01/76/34/wKiom1ZMhY-Q3UeFAABK_MsTBWo655.png "title=" 00.png "alt="

1.java.sql.sqlexception: Invalid name pattern: stksettleadmin. Ty_marketdataThere is no ty_marketdata under User stksettleadmin.2.. Java.sql.SQLException: Invalid name mode: Settleadmin.ty_marketdataThe user settleadmin name to

Today's repository is locked and checked, saying that it was logged wrong more than 10 times the user will be locked, there is the understanding lock and password operationTo activate the sqlplus in a non-link waySqlplus/nolog;Link the repository as

Oracle learning notes thirteen triggers, oracle learning notesIntroduction A trigger is a stored procedure that is automatically executed when a specific event occurs. A specific event can be an updated DML statement and DDL statement, and the

Oracle learning notes 2 first knowledge Oracle (2), oracle learning notes first KnowledgeEvery instance of Oracle 9i in Windows is started as a service in Windows. The service is an executable process registered in the Windows registry, which is

Oracle index reconstruction, oracle Index I. Preface Oracle recommends that you re-create an index if the index depth exceeds 4 and the number of deleted index entries occupies at least 20% of the total number of existing index entries. Some people

Paging query of mainstream Databases1. background summary as a project needs to display a large amount of data on the page, all the data is first queried during database query and then displayed, at this time, paging query operations are essential.

Oracle SQL BASICS (1)-create and modify tables, oraclesql 1. Table creation statement Create table fdh_client_info ( Id varchar2 (50) primary key, Name varchar2 (30) not null, Sex varchar (1 ), Age number (3 ), Address varchar2 (300) ); 2. Modify

Oracle recursive query and Oracle recursive query1. Create data 1.1 create a table and insert data Create table district (id number (10) not null, PARENT_ID NUMBER (10), NAME VARCHAR2 (255 BYTE) not null ); alter table district add (CONSTRAINT