Oracle

method, adjust PublicDataTable Sayhi (stringSQL, DateTime begintime, DateTime endtime,string[,] array,stringBtime,stringdtime) { stringConstr =@"Data source= (description= (address= (protocol=tcp) (host=10.93.64.242) (port=1521))

Previously written, and later did not write, since all forgotten. Here re-learning Oracle's stored procedures, want to see people do not laughed at.It is first known that the start statement of the stored procedure is create OR REPLACE PROCEDURE

1. Oracle Index NULL problemWhen a single-column index is established on an empty merit column, if the search condition is null in the interpretation plan you can see that Oracle does not use index queries for this column;However, when a

The database link of a distributed database is one-wayDefining Database LinksCREATE DATABASE LINK [Db_link_name] CONNECT to[USER_NAME] identified by [password] USING ' [tns_name] ';[Db_link_name]: is the service name of the database to which you

---is executing theSelect A.username, A.sid,b.sql_text, B.sql_fulltextFrom V$session A, V$sqlarea bwhere a.sql_address = b.address ---executed.Select B.sql_text,b.first_load_time,b.sql_fulltextFrom V$sqlarea bwhere b.first_load_time between ' 2009-10

Original: http://www.oracle.com/technetwork/issue-archive/2009/09-may/o39asktom-096149.htmlhow a constraint (constraints) in Oracle affects the query planOften people think that constraints are just about data integrity, no problem. But constraints

1. View the values of the current two parametersSqlplus/nologSql>conn/as sysdbasql>select Count (*) from v$session; From here we can see the current session numbersql>select Count (*) from v$process; From here we can see the current number of

Execution of the UPDATE statement was found to be unsuccessful for half a dayUpdate Main_order Set order_source = ' 2 ', order_status = ' 2 'Query which objects are lockedSelect object_name , Machine , s.sid, s.serial#from

Proper use of indexes can improve the speed of data retrieval and can create indexes on fields that frequently require queries.Oracle's index is divided into 5 types: Unique index, combined index, reverse key index, bitmap index, function-based

About the resolution of the Ora 01219 problemBefore learning Oracle to practice to create a table space, built a lot of manually deleted, and then use the user name you created to log into the database will cause the databaseORA-01031:ORACLE

Select Tp.technic_product_code,Tp.technic_product_name,Mp.marketproduct_code,Mp.marketproduct_nameFrom Marketproduct_info MP, Technic_product_info TPwhere Mp.id_technic_product_info = Tp.id_technic_product_info (+)1) + written on that table,

One, through the PLS block to call the stored procedure;DeclareP_dzno VARCHAR2 (50);P_vchtype VARCHAR2 (50);P_productclass VARCHAR2 (50);P_dptcode VARCHAR2 (50);Beginp_vchtype:= ' MP ';p_productclass:= ' 03 ';p_dptcode:= ' 206

Yu Tong More than 30 years, the official to the best, and academic nothing, virtue of a can not be allowed, eldest brother injury, frightened anxiety ashamed shyness. This will be a farewell to you, and the special four to teach your brother.One day

Oracle Data Type The core of the Oracle database is a table. The common data types used by columns in the table are as follows:CHAR (length)Stores fixed-length strings. The length parameter specifies the length. If the length of the stored string

Oracle index creation You can use indexes appropriately to increase the data retrieval speed and create indexes for fields that frequently need to be queried. Oracle indexes are divided into five types: Unique indexes, composite indexes, reverse

Oracle basic database backup and recovery, oracle Database Backup I. Why data backup? Main causes of data loss: 1. Media fault. 2. User error operations. 3. server crash. 4. computer viruses. 5. unpredictable factors.   There are four fault types in

Oracle cold backup Prerequisites for cold backup:The operating system is the same. You can execute scripts from Win32 to Win64 and from Win32 to Win64.Procedure:A. view the control files, data files, and log files of the two instances.B. Disable

Oracle11g + CentOS6 + DG installation recordsBased on a practical operation record, this article describes how to use rman for Hot Standby to create a physical Active standby database of dataguard. In this way, the master database only needs to be

Oracle Database for database Field Data TypeModify the Data Type of Oracle Data Columns Method 1: // Create the same temporary table Create table T_BUSINESS_MODEL_TEMP as select * from T_BUSINESS_MODEL where 1 = 2;// Change the data type of the

Use connect by prior in oracle to implement recursive query !, Oracleprior Note: This article to reference other people's articles, links: http://blog.csdn.net/apicescn/article/details/1510922, I recorded just to facilitate viewing Original article: