Oracle

Oracle Data Type parsing char: a maximum of 2000 characters, less than space filling. It is highly efficient to use the char type for fields with fixed length and frequently queried, because the exact match of the fixed length is not a waste of

select * from (select t. *, rownum rn from (select www.2cto.com col1, to_char (. testTime, 'yyyy-MM-DD HH24: MI: ss') as TestTime, from TestTable A where 1 = 1 lower (col1) like lower ('% col1 % ') TESTTIME between to_date (# testtime1 #,

Summary of common oracle errors 1. Oracle is case sensitive. 2. trim ('aa bb cc. ') removes spaces at the beginning and end of the string without removing spaces at the center. 3. Columns cannot be enclosed by single quotation marks ('') when

During routine maintenance, users of a Database need to be migrated to another database.You must create the same user and related permissions in the target database,Relevant user and permission information can be easily obtained, but in case the

Oracle Real-Time Interpolation Speed suddenly slows down problem solution a warehouse receiving program is written in the work, which is responsible for real-time unpacking, parsing, and inserting SQL statements into the Oracle database.The average

How to Use PL/SQL Developer to query data tables starting with/BI0/* And/BIC/* in BW backend Oracle? 1. Data Tables in BW: the data Table automatically generated by the backend for objects in BW starts with/BI0/* And/BIC/*. For details, see the

How to customize your SQL * plus environment SQL * plus is simple, powerful, and ubiquitous. What does SQL * plus mainly do? 1) autotrace 2) programming SQL * plus will automatically run glogin. SQL, which contains the global default settings. You

The isolation level analysis of the isolation level (isoation eve) defines the degree of isolation between transactions. Isolation level and concurrency are mutually contradictory: the higher the degree of isolation, the worse the database

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

Dblink: When you want to access data in another database table across local databases, dblink of the remote database must be created in the local database, dblink allows you to access data in a remote database table just like a local database. The

Oracle (5) control statements all programming languages are inseparable from control statements, oracle also provides basic control statements for PL/SQL programming, conditional statements, cyclic statements, sequential control statements ----------

Understand oracle Autonomous transactions 1. What is Oracle Autonomous transactions? In the official documents, the definition of "Autonomous transactions are independent transactions that can be called from within another transaction. that is to

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:

The general process of using oracle 11g r2 LogMiner! Use the oracle log analysis tool LogMiner. set the date format to alter system set nls_date_format = 'yyyy-mm-dd hh24: mi: ss' scope = spfile; select to_char (sysdate, 'yyyy-mm-dd hh24: mi: ss ')

Common functions of Oralce SQL language (I) character functions this function generally receives characters as parameters and can return characters or numbers. The most common functions are. the CONCAT function is mainly used for string connection.

Familiar with Oracle SQL language is an advanced non-procedural query language, users can use SQL as a tool for communication between the client and the server to access, query, and update databases, the syntax structure of the Insert statement in

The simple application of SQLPlus in Oracle is a command line execution tool provided by Oracle. After installation, SQLPlus is automatically registered in the system. After Oracle is installed, an emp table exists. Use SQLPlus to manipulate Oracle.

In oracle, large data fields are updated. Recently, a table with more than 0.7 million data records is updated. The update statement is used directly at the beginning, as shown below: 1 www.2cto.com update content set pic_bak = pic; it is found that

Oracle logon trigger analysis oracle logon trigger is generally used to audit user logon information or restrict user logon. Although it is not commonly used, it is still a good way.Note: you cannot audit dba user logon. The following is a specific

Oracle note (12) collection and sequence links: Oracle note (1) Oracle introduction and Installation http://www.bkjia.com/database/201209/154049.html ; Oracle notes (2) SQLPlus command http://www.bkjia.com/database/201209/154051.html Oracle note (3)