Oracle

1. Create a temporary table spaceCreate Temporary tablespace appstemptsp ' /oracle/app/oracle/oradata/orcl/appstemp01.dbf ' onnext 32m maxsize 2048mextent management local;2. Create a table

1. Differences between temporal and tablespace spacesTablespace: This space is used for data storage (tables, function, stored procedures, etc.), so is the actual physical storage area.Temporal tablespace: The primary purpose is to sort operations

Did not expect May full one months not to write essays, I always so, three minutes of heat, it is difficult to stick down. May almost no weekend, are working overtime, evening also often overtime, but fortunately, do not feel tired, but the Dragon

The database was queried and modified by Hibernate + MySQL, because MySQL database is simpler than Oracle database, recently read Oracle's book, this afternoon tried the next Hibernate framework to operate the Oracle database:1. Create a new WEB

DECLARE CURSOR city_cur isSelect t.new_customer_id,t.old_customer_id fromCITSONLINE.CRM_CUSTOMER_TMP6 Twhere t.new_customer_id!=t.old_customer_idOrder BY new_customer_id;BeginFor my_cur in City_cur loopUpdate Platform.crm_service_customer_bak SSet s.

Friendly tip: Please be in business idle is operation. Why is it?--oracle 11g  interval partition (INTERVAL) Rename, batch generate rename partition script set linesize 180set serverout  ONDECLAREV_TABLE_OWNERVARCHAR2 (100)  :=  ' op% ';

1. Delete the lexical parserexec ctx_ddl.drop_preference (' my_lexer ');2. Create Chinese lexical parserexec ctx_ddl.create_preference (' my_lexer ', ' chinese_vgram_lexer ');3. Create full-text index, multi-fieldEXEC ctx_ddl.create_preference ('

This is the first of my Oracle Learning Notes series, which summarizes the architecture of Oracle, and to learn Oracle, it is important to understand how Oracle operates and how it works. The content of today's study is compiled with a diagram, memo,

In the development process, encountered a problem: in the Oracle database, using the PL/SQL database development tools to develop, a field length can not meet the requirements, the following syntax to modify the lineALTER TABLE name modify field

6 ways to get the execution plan (detailed steps have been explained in the comments section at the beginning of each example):1. Explain plan for acquisition;2. Set autotrace on;3. Statistics_level=all;4. Direct access via Dbms_xplan.display_cursor

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'

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): =

SELECT * FROM V$sqlarea t ORDER by t.last_active_time DESCNote: Some related statements, such as executing this statement, must have DBA authority although this statement is common but useful when needed to detect a person executing a SQL statement

In Oracle, the control file is the file used when the database is mounted, the control file is lost or corrupted, and the instance crashes, where the parameter file records the location of the control file;After the instance starts to Nomount, if

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

The connections between Oracle tables are divided into three types:1. Inner connection (natural connection)2. External connection2.1. Left outer connection (the table on the left is unrestricted and the results of all conditions are queried)2.2.

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;Create a user table spaceCREATE tablespace

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_

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

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