Oracle

The management of data objects and data in Oracle is undoubtedly managed using PL/SQL developer, which also provides us with a lot of convenient and fast operations, so that we no longer complain about Oracle's own ugly, hard-to-use UI. Since we are

The first step is to ensure the integrity of the database instance, including control files, log files, table spaces (System tablespace, user tablespace, and so on).Create a new database instance with the same name (table space, user, etc. not

When you parse a partitioned index with the parse command, the range information for the data values for each partition is placed in the Oracle data dictionary.Oracle can use this information to extract data partitions that are only related to SQL

1. An update and delete can kill a large chunk of people because everyone thinks this sentence is very well written, not just:Update table set a=x,b=y;Delete from table where name=xxOf course, now I talk about this problem, we certainly disagree, so

Transaction: A separate logical unit of work. It has a specific series of SQL statements that must be successful or failed as a whole. is an all-or-nothing, very personality of the East.Four properties of a transaction--acid properties: Atomicity

Oracle creates self-growth write sequences and write triggers, not as convenient as MSSQLSERVER. But it is also a hassle, recorded as follows:In Oracle, you can create a separate sequence for the primary key of each table, and then get an

Slow query speed due to a large number of delete operations causing the space to not be released and the horizontal bit high--high level position due to a large number of delete operations causing the space to not be releasedALTER TABLE

Several types of characters common to Oracle: The length of the char is fixed and the maximum length is 2K bytes. For example, you define char (20), and even if you insert ABC, less than 20 bytes, the database will automatically add 17 spaces

Col_2 Col_321 3123 31As above table dataFront desk display shows the need to convert col_2 21 and 23 into Chinese ' machine ' starting with the following writingSELECT T.col_3,Case T.col_2WhenMachineWhenMachineENDFrom A_test_1 tGROUP by

Oracle de-weight: Combined with other people's records, roughly the following two kinds of looks pleasing to the eye. 1.delete from Twhere rowid No in (select min (rowid) from T Group by Go to the heavy field); For a chestnut:--To

Replace functionReplace (longest string, replaced string, replacement string)Mathematical functionsRound (N,[m]) retains the number of M-bits in total n-bit length, using rounding.Trunc (N,[m]) intercepts numbers and does not write directly to the

Fourth Multi-table query1. Descartes SetThe Cartesian assembly is produced under the following conditions:Omit join conditionInvalid connection conditionAll rows in all tables are connected to each otherTo avoid a Cartesian set, a valid join

If you are familiar with Oracle database, I think you will not be unfamiliar with Thomas Kyte's name. Tomas hosted the asktom.oracle.com website for decades in the Oracle world. Recently in the library borrowed the Oracle top master of the "expert

ORA-01665 solution in Oracle11g dataguard CreationOracle 11g fails to restore the standby control file when creating data guard. When I mount standby database, tell me that the control file is not a standby control file and the information is ORA-016

Conversion Function (learning notes), conversion function learning notes -- ****************************** Conversion Function-- Format the current date and time Select sysdate, to_char (SYSDATE, 'yyyy-MM-DD hh24: mi: ss') format date, to_char

Oralce time conversion usage TO_CHAR (DATE, FORMAT) 1. This week, this month, and this year -- This week select trunc (sysdate, 'D') + 1 from dual; -- Monday select trunc (sysdate, 'D') + 7 from dual; -- Sunday -- select trunc (sysdate, 'mm') from

What is Scalability ?, Whatisscalability Scalability is a system's ability to process more workload, with a proportional increase in system resource usage. in other words, in a scalable system, if you double the workload, then the system uses twice

SQL collection (notes) and SQL collection notes -- SQL is about the set Oracle is a relational data, where data tables are a set of regular data. Therefore, when using SQL statements, it will save a lot of efficiency if you can follow the set idea,

Oracle Storage in Action: Delete physical data files, oraclestorage Alter tablespace XH_DM drop datafile 'f: \ DEV \ ORACLE-DATA \ ORCL \ XH_DM_1.DBF '; SQL> ALTER TABLESPACE XH_DM2 drop datafile 'f: \ DEV \ ORACLE-DATA \ ORCL \ xh_dm_1.dbf

Oracle's use of bitmap index, oraclebitmap If you are familiar with Oracle databases, I think you will not be familiar with Thomas Kyte. The asktom.oracle.com website hosted by Tomas has been well-known in the Oracle field for decades and is far