Oracle

Manually start two instancesSu-oracleLsnrctl start-Suppose one instance is ITSM and the other is testExport ORACLE_SID=ITSMSqlplus/as SYSDBAStartupQuitExport Oracle_sid=testSqlplus/as SYSDBAStartupQuitAuto-start, can be set in/etc/rc.local, add the

Triggers and sequencesCREATE OR REPLACE TRIGGER t_mstb_bds_data before INSERT on mstb_bds_data for each rowdeclare integrity_ ERROR EXCEPTION; ERRNO INTEGER; ErrMsg CHAR (n); DUMMY INTEGER; FOUND

In Oracle, the non-equal sign has the following options:<>,!=,^=Test SQLCREATE TABLE test ( ID int, name VARCHAR2 (Ten), age int) insert INTO test (id,name,age) VALUES (1, ' Zhangsan ', 23 INSERT into Test (id,name,age) VALUES (2, ' Lisi ', ");

CREATE TABLE STUDENT (--Creating student tablesID Number (TEN) PRIMARY key,--primary Key IDNAME VARCHAR2 (20),CLASSNAME VARCHAR2 (20)--Class ID);CREATE synonym STU for STUDENT; --Create aliases for student table student (synonyms)INSERT into STUDENT

A business high concurrency, access to a customer phone to send a special invitation code (code for the word multibyte digital mixed, irregular), code has been stored on the table, business to invite code and user mobile phone number one by one

The Oracle data discusses char, varchar, VARCHAR2 data types:These three types are the most we use, in the database we how to use it?The length of 1.CHAR is fixed, with a maximum of 2000 strings:2.VARCHAR, VARCHAR2 can be sure that the Carchar data

Using an associated query, the fields of two tables define different types. One field is the VARCHAR2 type and the other field is the number type, with the following contents: ' 00187 ' and 187. In use, it is found that the VARCHAR2 type is

A new feature in 11G that does not allocate segment when the table has no data to save spaceWorkaround:　1, insert a row, and then rollback will produce segment.The method is to insert data into the empty table and then delete it, resulting in

First, the concept of ROWIDStores the location of row in the data file: 64-bit encoded data, A-Z, A-Z, 0-9, +, and/,How row is stored in the data blockSELECT ROWID, last_name from hr.employees WHERE department_id = 20;For example:

An empty table cannot export an issue:Data Discovery There's a new feature in Oracle 11g : A new parameter "deferred_segment_creation" means that paragraph delay is created, which is true by default . What does it mean

The. NET Framework accesses Oracle databases in at least two ways, one using Microsoft's ADO, and the other using Oracle-provided odp.net.When installing VS, it comes with ADO, which comes with odp.net when installing the Oracle client.In terms of

I. Use RowNum to do three-layer packing inquiry (common scheme)SELECT * from (Select A.* from (select* from) where)where>=The most internal query, select * FROM table_name, represents the original query statement without paging. ROWNUM = 21

MySQL date and Character conversion methodDate_format (date, '%y-%m-%d ')--------------To_char () in >oracle;Str_to_date (date, '%y-%m-%d ')--------------to_date () in >oracle;%Y: Represents a 4-digit year%y: Represents the year of 2%m: Represents

1. Package A package is a combination of a set of related procedures, functions, variables, constant #sinaeditor_temp_fontname, types, and cursors, such as PL/SQL programming elements. The package has an object-oriented design and is the

The Oracle Wm_concat (column) function allows us to use it frequently, and below teaches you how to use the Oracle Wm_concat (column) function to implement a field merge if you have an Oracle Wm_concat (column) If you are interested in the use of

NUMBER (x, y) Data Types in Oracle databases Test preparation Analysis and Experiment 1 processing of decimal part 2 maximum value that can be saved 3 Minimum value that can be saved Summary The NUMBER data type of Oracle indicates a decimal NUMBER,

Summary of common Oracle operations and summary of oracle1. oracle modifies the table name, column name, field type, adds a table column, and deletes a table column: Alert table scott. test rename to test1 -- modify the table nameAlter table scott.

Oracle Database Introduction Oracle getting started Series 4 Oracle Database Overview Finally, we smoothly transitioned to oracle. We hacked Larry once in the first article. here we need to cleanse Larry. After Mr. Qian Zhongshu wrote "besieged city"

ORA-02049: Timeout: Distributed Transaction Processing waiting for Lock diagnostics In the formal environment, there are two databases A and B. dblink is built on Database A. The business is to update some tables in database A to database B through

Oracle uses imp and exp to import and export dataUse the cmd command to export data. The details are as follows:1: There is a tnsname. ora file in the directory G: \ Oracle \ product \ 10.1.0 \ Client_1 \ NETWORK \ ADMIN. The content is as