Reset the sequence of Oracle

The sequence resetting of Oracle found that an exception occurred to the incremental value of a sequence, but it was not incremented as expected. Therefore, the sequence reconstruction method must be used to fix the problem. However, in order to

Oracle pl/SQL programming study notes

Oracle pl/SQL program design study notes this article is mainly to record some confusing or previous knowledge is not clear enough, just select common knowledge points. I. case statement and case expression 1. case statement and case expression both

Oracle returns an even number of data rows

Oracle returns an even number of data rows. When the number of data rows in the query table is an odd number, a blank row is automatically added and an even number of data rows are returned. If the number of data rows in the query table is an even

Oracle Stored Procedure return record set

Oracle Stored Procedure return record set oracle Stored Procedure return record set, the key is to use a cursor. We certainly have a lot of contact with database cursor. We can use OPEN, FETCH, and CLOSE operations to control the cursor for various

DECODE () function usage

DECODE () function usage: Compares the input value with the parameter list in the function, and returns a corresponding value based on the input value. The parameter list of a function is a sequence of several numbers and their corresponding result

Efficient Paging for Oracle database queries

In the C/S program, the data that contains thousands or tens of thousands of rows in the Grid cannot be displayed on the webpage due to the influence of the page rendering speed, therefore, it is usually displayed in the form of pages (or it may be

Create a trigger to report the loss of the IN or OUT parameter: 1 IN the index.

Create a trigger and report that the IN or OUT parameters are lost IN the index: 1. Use the "Oracle Enterprise Manager Console" trigger editor to report "lost IN or OUT parameters IN the index :: 1 "error. The specific SQL statement is: [SQL] CREATE

ORA-38760: This database instance failed to turn on flashback

ORA-38760: This database instance failed to turn on flashback database Error solution process problem phenomenon: Get up early in the morning to open the database, originally wanted to do a test, the result is not expected to pop up the ORA-38760:

DDL operations on Oracle databases

Create and manage Data Definition Language (DDL) statements are used to define the database structure or schema. some examples: · CREATE-to create objects in the database · ALTER-alters the structure of the database · DROP-delete objects from the

Dual in oracle

In oracle dual explanation, oracle introduces dual to conform to the Syntax 1. From the perspective of name, dual is not a acronym, but a complete word. Dual refers to logarithm, Which is dual and dual when used as an adjective. 2. The dual table in

Oracle tool: simple use of logminer

Oracle tool: simple use of logminer my environment: [root @ localhost ~] # Uname-aLinux localhost. localdomain 2.6.18-308. el5xen #1 SMP Fri Jan 27 17:59:00 EST 2012I686 i686 i386 GNU/Linuxsys @ ORCL> select * from v $ version where rownum = 1;

Modify the field type with data in Oracle

Oracle modifies the field type with data to char due to changes in requirements. The general idea is as follows: www.2cto.com will change the type of field name to backup, then add a field with the same name as the field name to change the type (the

Batch insert of oracle and mysql

Batch insert of oracle and mysql into oracle batch insert: insert into tableName (col1, col2, col3) select 'first column value' in the first row, 'second column value ', 'Third column value' from dual union select' first column value', 'second

Replace like in Oracle

In Oracle, the like method is replaced. The database stores a large amount of data, and the like method is used for queries, which slows down significantly. When I was working on a project, I found that I could use the instr function to replace the

In oracle, the values of two tables are inserted to each other and the values of the table itself are inserted.

In oracle, the two tables insert values to each other and the table's own insert values have two tables, student and otherStudent, the table information is as follows: SQL> desc studentName Type Nullable Default Comments ---- ------------ ------- ---

Usage of exists and not exists in oracle

There are two simple examples of exists and not exists usage in oracle to illustrate the efficiency of "exists" and "in". 1) select * from T1 where exists (select 1 from T2 where T1.a = T2.a); T1 has a small amount of data, while T2 has a large

Summary of work over the past week-oracle partition migration

A while ago I wrote something about data table compression. Now I feel it is a good way to compress the data and migrate it directly. Now there is a TABLE: www.2cto.com create table TABLE_1(MONTH_ID VARCHAR2 (10 ),AREA_ID VARCHAR2 (10 ),SERI

Oracle string type

Oracle string types: Oracle has four basic string types: CHAR, VARCHAR2, NCHAR, and NVARCHAR2. In Oracle, all strings are stored in the same format. The most comprehensive range of database blocks is 1 ~ The 3-byte length field is followed by the

Oracle Database full backup recovery and partial Backup Recovery

Oracle Database full backup recovery and partial Backup recovery today encountered Oracle Database sequence problems, simply a full database backup and recovery. The following imp/exp table mode backup: ­ oracle @ sencloudServer: exp

ORACLE date addition and subtraction

You can add or subtract oracle date from DATE or timestamp. The current date can be added to the year, month, day, hour, minute, second, operation of different time types, there are three methods: www.2cto.com 1 using the built-in function

Total Pages: 2147 1 .... 2082 2083 2084 2085 2086 .... 2147 Go to: GO

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.