Oracle

Pl/SQL 9.2 cannot connect to the oracle database. When oracle 11 GB is installed on the system and oracle 10 Gb is installed on the client, when pl/SQL is used to connect to the database, the connection fails. The reason is that the oracle home

Understanding cursors (1): An Overview of cursors eygle says that database activities are mainly about the importance of the cursors active cursors. As a result, I have made a series of articles, step-by-Step learning of cursors the first article is

Common SQL functions need to pay attention to the details. This is a question that a cool man asked us to think about. To tell the truth, I was so blind at the time. Although the function was clear, but it was not accurate to this level, the

Insert the query results of one table in Oracle to table 1 and Oracle database. Generate and import the query results of one table to a new table. Www.2cto.com. For example, if only table A is available, query table A and import the result to table

Using rowid logic to extract data in parallel when we migrate or synchronize data, we often encounter oracle needs to read rollback segments for tables with frequent application changes, it may lead to a very slow process. Sometimes it may even

SQL code used to query the names and data of tables with IDs greater than 10000 in Oracle -- query the data with IDs greater than 10000 in all tables and the corresponding table name select 'select id, ''' | table_name | ''' as tablename from '|

Oracle DataGuard physical Standby builds Arch asysncOracle Dataguardprimaryhost: primaryIP: 192.168.198.136Oracle _ sid: Role: dg_pd standbyhost: standyIP: 192.168.198.128Oracle _ sid: Role: dg_st 1. configure www.2cto.com 1. set the master database

The ORACLE String concatenation aggregate function can be used for group by 1. create type strcat_type www.2cto.com -- the essence of defining a type aggregate function is an object create or replace type strcat_type as object (cat_string varchar2 (4

The Oracle database problem caused by IE8 being unable to enter the debug mode. in the B/S system for development, you need to enter the debug mode of IE for debugging. However, the debug window flashed through, you can only turn off the 360 series

ORACLE stores the executed SQL statements in the shared buffer pool, which can be shared by all database users. When you execute an SQL statement (sometimes called a cursor), if it is exactly the same as the previously executed statement,ORACLE can

Oracle fragmentation key points-Multi-table joint query, collect basic database information 1. multi-table join query for oracle: www.2cto.com select. sname, B. stu_xb from student a, studentinf B where. stu_id = B. stu_id syntax 2. SQLStructur

RAC Local_listener, an Oracle appendix first a conversation: www.2cto.com cainiao asked: I set local_listener = 'listener1' In the parameter file, and then start the database to report an error. SQL> startup ORA-00119: invalid specification for

[Oracle] storage length of Chinese Character FieldsIn our system, if the remarks field requires 200 Chinese characters, this field is either set to varchar2 (600) or nvarchar2 (200 ).The following provides a reference for saving the length of

Oracle AWR threshold affects the historical execution plan. Some netizens recently mentioned why the historical execution plan of SQL statements cannot be viewed in dba_hist_ SQL _plan. This problem is caused by default, the threshold value set by

Oracle Data Guard (iv) Failover 1. check for missing logs in the Standby database. Run the following command to check for missing logs: SQL> select thread #, log_sequence #, high_sequence # from v $ archive_gap; copy the missing log file from the

You are often confused about the invisible indexes of Oracle 11 GB. Is the index really helpful for user queries? It may be helpful for one query, but it may affect 10 other queries. The index will certainly have a negative impact on the INSERT

Transaction and database recovery principles the logical unit of data storage is data blocks, and the logical unit of data operations is transactions. A transaction is a user-defined sequence of operations. It consists of one or more SQL statements

The FAL gap problem of Oracle Data Guard logs is found in the OracleData Guard environment. A standby database has a problem and needs to be redone. Because the previously configured environment is good, you only need to back up the full database of

Simulated recover Oracle restoration test for accidental deletion of dataifle 1: 1. hot Backup tablespace users. 2. a) scott login, B) create table tt (seq number); c) declare I number; begin for I in 1 .. 20 loop insert into tt values (I); end loop;

[Solution] win7 x64 vs SQL statement connection ora-12154: tns: unable to resolve the specified connection identifier first vomit slot: win7 x64 special, many places are very special, therefore, installing a lot of software is useless. Background: