Oracle

1.1.Basic ConceptsDatabase: Service process (Database read-write log process, etc.)+ memory (memory occupied)+ database files (database, etc.). table Space: The place where the data table is stored. A table space will have a corresponding . db file

Recently the company's pan-micro OA can not access, Oracle database can not start normally, tried a lot of methods, finally solved, first of all, to talk about the basic situation, I hope to meet the same problem of friends to bring a little

Pseudo- column: a pseudo-column in Oracle is like a table column (a column in a table), but it is not stored in a table, a pseudo-column can be queried from a table, but its values cannot be inserted, updated, or deletedCommon pseudo-Columns are

Oracle and 2 months ago provided support for EF6. Previously only supported to EF5. EF6 has many useful features that are worth upgrading. Here's how to support OracleI. Oracle provides some basic knowledge about. NET Support.1. In the early days,

Select Detail_num,carriage_num,ed_date,created_date from(Select RowNum id,detail_num,carriage_num,ed_date,created_date from(select detail_num,carriage_num,ed_date,created_date from xx order by created_date desc) where rownum) where id>= (? -1)

System Environment variablesVariable name: Nls_langVariable value: Simplified Chinese_china. Zhs16gbkCREATE OR REPLACE PROCEDURE "Tlgl". " TLGB "AsBEGINExecute immediate ' ALTER TRIGGER XG ENABLE ';END; --Close all triggersALTER TABLE Tbname disable

1. To optimize the query, avoid full-table scanning as far as possible, and first consider establishing an index on the columns involved in the Where and order by.2. Avoid null-valued fields in the WHERE clause, which will cause the engine to

1 Create or Replace functionGet_request_codereturn varchar2 as2 3 --function: Automatic generation of order numbers4V_mca_no Mcode_apply_01.mca_no%TYPE;5 6 CURSORGet_max_mca_no is 7 SELECT Max(Substr (Mca_no, One,1))--

1. The default is to use the current timeintdefault sysdate);2. Automatically generate GUIDsOracle8i introduces the concept of Sys_guid, which has many advantages over the traditional sequence (sequence) used by Oracle administrators. A sequence

In the first contact with C # when the company is using Oracle database, then C # How to connect Oracle database is the first to grasp the knowledge point. There was no odp.net at the time, but Visual Studio integrated the call to the Oralce

Partition Characteristics:1.Partition Key;2.Partitioning StrategiesPartitioning Strategies:1. Range2. List3. HashCreate an instance of a table with multiple partitions:CREATE TABLE testpt (tid int)Partition by Range (TID)(partition TESTPT_B10 values

The basis of a multi-table query is the use of a Cartesian set:Final number of rows = number of rows in table 1 * Number of rows in table 2Final number of columns = number of columns in table 1 + Number of columns in table 2The key to filter the

Rman Target/log=/orasoft/backup/${date}backup1.log Run {Allocate channel C1 device type disk;Allocate channel C2 device type disk;Allocate channel C3 device type disk;Backup database format '/orasoft/backup/db_%t%u.bak ';Backup current controlfile

2.1 Network Configuration Tool NET ManagerOracle is a database system in a networked environment, and its own net manager configures and sets up the network environment. Net Manager as a tool for managing the network environment by configuring and

Three types of collection operations are available in Oracle: and (UNION), intersection (INTERSECT), poor (minus) · UNION: Combines the results of multiple queries into a single query result, with no duplicate content · UNION All: Also

The data are as follows:Name IDZhang SanRequired implementations:Name IDZhang 31Zhang 32Zhang 33--Create a temporary tableCreate TableTmp as(Select 'Zhang San'Name' the'Id fromdual);--notation 1SelectName,regexp_substr (ID,'[^,]+',1, Level) asID

Oracl batch add and modify data in one SQL statement, oraclsql I have been using it for a long time, and I have been learning or1c. I have also used batch addition for projects (reading and uploading CSV file information and writing qualified

20171000011301_about rman1_faq .txt, 20171130 rman Please refer to 1130.pdf about rman FAQ. txt-- // The previous test is too messy and some rman as copy tests are re-performed.1. Environment:SCOTT @ book> @ & r/ver1PORT_STRING VERSION BANNER--------

[20171121] rman backup as copy 2.txt, 20171121 rman [2, 20171121] rman backup as copy 2.txt-- // Test backup as copy yesterday. When is the backup file header updated during backup? Is it written to the backup file in sequence after the backup is

When Oracle RMAN is restored, a space error is reported for the set newname file name. rmannewname Preface During data recovery, you may encounter the case that you need to adjust the location of the data file. In this case, you can use the set