Oracle

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

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

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

The project used a 64-bit Oracle, but the local use of 32-bit plsql, so the Chinese is always displayed in the Plsql is garbled, began to think it is a database problem, after verifying the database has no problem, the Internet search for an

stored Procedure : is a set of SQL statements that are used to complete a specific database function, which is compiled and stored in the database system. At the time of use, the user invokes and executes a stored procedure name that has already

First, generate a random dateFor example, generate an arbitrary date within 2015 years:/** Analysis: Any date within 2015 years, that is, the date range is (2015-01-01, 2015-12-31)* Can be converted to 2015-01-01 + (0, 365),* of which, 2015-01-01 is

PowerDesignerConfigurationOracleDatabase Reverse EngineeringDeng JiahaiPaste: Software Channel bar1. Preface:PowerDesigner is Sybase's enterprise modeling and design solution that combines business and it with a model-driven approach that helps to

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