Oracle

Http://www.oracle.com/technetwork/database/windows/downloads/index-093848.html http://blog.csdn.net/robin_he/article/details/7345842 Oracle 11g R2 11.2.0.3 Patch set for Winnt 32bit Do not explain the need to hurry down AH 115 closed

Oracle Database 11.2.0.2 has been available for Linux for a while.  It is also today available for Windows (32-bit and 64-bit).  You are need access to me Oracle Support to get this upgrade/patch. 11.2.0.2 allows for new installations (a departure

Set oracle_home environment variable: Export oracle_home=/oracle/product/11202Set PATH environment variable: Export path= $ORACLE _home/bin: $PATHSwitch to Lsnrctl directory: Cd/oracle/product/11202/bin 1. Launch Oracle under Linux Su-oracleLsnrctl

--Delete partition test --Created on 2014-10-08 by LENOVO Declare --Local variables L_begin_date DATE; L_end_date DATE; L_begin_time DATE; L_sql VARCHAR2 (2000); Begin --Test statements here L_begin_time: = l_begin_date; For L_partname in (SELECT

Preface Update the data for one table, on hundreds of, and then especially slowly, all the time, and then force it to return, again or again, taking into account the possibility of locking the table. Solve ① first finds which sessions are

Http://doc.linuxpk.com/49161.html As follows:SELECT logid,userid,logtime,url,description, (case operatetype when operatetype = 0 Then ' Add ' when operatetype=1 then ' modify ' Else ' delete ' end case ' from LOG　　1. CaseSELECT Logid,userid,logtime,

Oracle string interception from backward forward method The format of the Instr:instr method is INSTR (source string, target string, start position, match ordinal) The default lookup order is left to right. When the starting position is a

1, take the record from the table randomly SELECT * FROM (SELECT * to Staff ORDER by Dbms_random.random) indicates that 3 records are randomly taken from the staff table Where RowNum 2. Produce random number SELECT Dbms_random. RANDOM from

Field type: Blob,clob,nclob Description: Three large objects (lobs) to hold large graphics files or formatted text files, such as Miceosoft Word documents, as well as audio, video, and other non-text files, the maximum length is 4GB. There are

Create or replace procedure P_insert_test (Idemo LONG)IsBeginINSERT into T_test (ID, DEMO) VALUES (1, Idemo);COMMIT;End P_insert_test; You can pass parameters with strings, but the length is limitedI haven't found a way to pass the long

At the time of writing hibernate code, a "table or view does not exist" error occurs when you want to save to the Oracle database, but when you enter the database, the table is present and can be edited and analyzed to find that it was created with

If you want to be aware of empty conditions when you use like, try to use the following statement: --comma field query SELECT t.*, T.rowid from T_test T WHERE regexp_like (', ' | | t.test| | ', ', ', 1, '); SELECT t.*, T.rowid from T_test T WHERE

Oracle databases are common enterprise-class database types and have good database management tools under the Windows operating system, but in an Ubuntu (Linux, AIX, UNIX) environment, the best way to manage this is scripted management, and the

Oracle Multiple Table Association UPDATE statement 1 The simplest form of SQL code --confirmed that all customer_id less than 1000 of the Customers table are ' Beijing ' Within the--1000 are the company to the country before the old customers in

In the DBA's maintenance Management, index invalidation is a common problem, such as move, CTAs, swap partitions and so on will cause the index invalidation, the following experiment is to verify the drop partition, truncate partition partition on

When you debug a stored procedure a few days ago, Oracle inexplicable error, when the stored procedure to a section of SQL, how to do not pass the past, and finally the sqlcopy out of the separate execution OK, when a specific record of the change,

Database analysisStatement execute dbms_utility. Analyze_database (' COMPUTE ', Null,null, ');Discovery Table Link LineStatement Select table_name,chain_cnt from User_tables ORDER BY chain_cnt DescSelect table_name,chain_cnt from All_tables where

Oracle typically resets the sequence to initial 1 o'clock, which is deleted and rebuilt, which has many drawbacks, and the functions and stored procedures that depend on it will fail and need to be recompiled. But there is a clever way, do not

A table is referenced by B table, delete a table when prompted Ora-02292,a table of the primary key is referenced, although the B table has been deleted all the data, but still can not delete a table data. Solution:Disables the primary KEY

Younger brother Win7 system, my colleagues in the evening to visit my PC database is not successful, according to the method provided online, set up a firewall, put access to 1521-port inbound and outbound, the result is not even. Painful old long