Oracle

Cause: The SQL statement is as follows: Select count (*) from test; Result 1390. Select count (*) from test where BB not like '% disable %' Result 393. In the actual browsing process, it is found that the result set is not disabled and there

The fastest and most practical way to create a user in Oracle:   Step 1 Select the SQL plus shortcut (E:/Documents and Settings/all users/Start Menu/Program/Oracle-orahome92/Application Development/SQL plus. Use the system's Default User Name

Data Table Name: tm_language Primary key field name: tm_language_id Data Table sequence: seq_tm_language Detailed SQL code: -- Add a primary key (if there is no primary key field, add a primary key field, assign a value, and then add a primary

The system user cannot perform database backup and recovery operations (the XMP Data File Import and Export function ). After creating a user in the previous article, you must specify the user permission for the Import and Export Operation. The

Source: http://www.cnblogs.com/shengel/archive/2007/06/06/773559.html Reason for posting: It is quite interesting, and there are many differences with SQL, so there is no specific test.   Use the DML insert statement in Oracle to insert data into

Source: http://www.cnblogs.com/shengel/archive/2008/10/20/1315424.html Reason for posting: in practice, the method of assigning values to output parameters in stored procedures is displayed. It is different from the SQL stored procedure assignment

Common addition, deletion, and modification operations for creating data tables and data tables 1. Click "Start/Program/Oracle-orahome92/Application Development/SQL plus "; 2. In "user name [u]:" and "password [p]:" Enter the user name and password

The function dbms_job.submit can complete the scheduled tasks of oracle. The format of dbms_job.submit is as follows: Declare job1 number; Begin Dbms_job.submit (job => output variable, which is the number of the task in the task queue, What =>

A Test Table V is created, which contains two columns: test1 and Test2. It is required that the two columns of data be interchangeable rows. SQL> select * from V; Test1 Test2--------------------20 2010 2020 1030 5050 3060 7070 80 20 20   SQL> select

I just saw this article in the blog of the inthirties boss. It was well written. I just recently learned PL/SQL and turned to learn it.   ========================================================== =====================================================

What is the difference between number and binary_double in Oracle? The main advantage is: it is more efficient than number, faster, and takes less space, but the version compatibility is poor. Numeric numeric type Number: this is a real decimal

1. Set the initialization parameter job_queue_processes.Job_queue_processes = 4Job_queue_interval = 10SQL> alter system set job_queue_processes = N; (n> 0)Job_queue_processes: the maximum value is 1000. View the Job Queue background processSQL>

There will inevitably be situations where random needs are needed at work. There are two main implementation methods: Implemented by hard Coding Implemented through the random functions provided by the database This article mainly explains

Three phenomena: Bloat reading: A transaction reads data written but not submitted by other transactions. Repeatable reading: a transaction has been read again and found that the data has been modified or deleted by another submitted transaction.

Basic knowledge: Create Table test01 (Enno number (3), enname varchar (20), sex varchar (2), age Number (3) 1. index creation Syntax: create Index name on table name (column name 1, column name 2 ,.......) tablespace name; example: Create index

Commit Process Before commit Oracle generates a revocation record in the SGA undo segment buffer. The revocation record contains the old values for updating and deleting table rows. Oracle generates redo log records in the SGA redo log

Normal 0 7.8 磅 0 2 false false false MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable{mso-style-name:普通表格;mso-tstyle-rowband-size:0;mso-tstyle-colband-size:0;mso-style-

Normal 0 7.8 磅 0 2 false false false MicrosoftInternetExplorer4 classid="clsid:38481807-CA0E-42D2-BF39-B33AF135CC4D" id=ieooui> Preface   OracleManagement books blossomed everywhere, and a

Normal 0 7.8 磅 0 2 false false false MicrosoftInternetExplorer4 /* Style Definitions */

1. Start the database and report an error. SQL> startupOracle instance started. Total system global area 1076851960 bytesFixed size 738552 bytesVariable Size 285212672 bytesDatabase buffers 788529152 bytesRedo buffers 2371584 bytesDatabase