Oracle

Declare a cursor that contains a table that does not have fields, where data. * is a table, and then add the fields in other tables to the sal_data cursor www.2cto.com SQL code cursor sal_data (cp_center_temp_id varchar2) is select data. *, post. id

The nature of Oracle row-level locks (I) three major components of the single-instance Oracle locking mechanism www.2cto.com locking mechanism: ① resource structure Oracle for each resource requiring "concurrent access, both use a Data structure in

Common commands for Oracle to view table structures to obtain tables: www.2cto.com select table_name from user_tables; // select table_name from all_tables for the current user's table; // select table_name from dba_tables for all users; //

Dynamic listening: When an ORACLE instance is started, or the command alter system register is used, or every minute, the PMON process dynamically registers with the listener. the instance_name and service_names parameters in ora dynamically

Select statement field connection (oracle), such as employee name, employee position, birth date, and so on in the employee basic information table. If the three fields in the current view are displayed in the same field, there is a delimiter in the

ORACLE Database Data File Location migration 1. there are two ways to move a data file www.2cto.com to move a data file: 1. Move SQL> select name from v $ datafile; ------ 2. shut down Database SQL> shutdown immediate Database closed. database

Uninstalling an Oracle database is not as simple as deleting other software. Especially for new employees, when the database is deleted and re-installed, it is often re-installed, some inexplicable errors will be reported, or the installation will

Oracle uses merge to update or insert data (Summary) under Java code summary. Using merge is much faster than traditional first judgment and then selecting insert or update. 1) The main function is to UPDATE and insert data to the database table

PL/SQL stores objects such as accidentally deleted storage or tables to files in the development environment. because many people share a library and the permission management is unreasonable, it is very likely that you have deleted my storage, I

Savepoint in Oracle transactions 1. Basic Concepts savepoint is a point in transactions and can be returned to a certain storage point through rollback. A transaction can have multiple storage points. Once the transaction is committed, the storage

Exp + parfile export the qualified record exp parfile = d:/test. par file = d:/back. dmp filesize = 2000 M log = d :/**. the purpose of logfilesize is to prevent some operating systems from supporting files larger than 2 GB, and the I/O performance

Oracle SQL writes a method to determine whether a string is a function in the target string based on requirements. Used to identify the following situations: Determine whether string A exists in string B separated by commas (,), for example:

Use spool tool to export oracle Text data 1. win next batch processing scheduling file data_spool.bat [SQL] F: \ oracle \ product \ 10.2.0 \ db_1 \ BIN \ sqlplus tax/tax @ orcl @ D: \ PDM_ SQL \ spool \ spool_ctl.spl> D: \ PDM_ SQL \ spool \

The process of establishing a complete database by the oracle database file recently helped the teacher write some functions of the website management system. Because it is not in the same place, the teacher sent me a library file (subsequently

To add partitions to an oracle range Partition Table, perform the experiment in two cases. 1. There is no maxvalue partition. 2. maxvalue partitions are available. The following example shows how to add partitions in the range partition table

1. Oracle Natural join www.2cto.com Java code create table test_table_A (id number primary key, nameVarchar (32); create table test_table_ B (id number primary key, name varchar (32), des varchar (32); select * from test_table_A; select * from test_

Oracle block cleanout in short, there is a mark of active transactions on the oracle block. If a transaction commit, because some blocks have been written back to datafile before commit, or if the number of Blocks Affected by the transaction is too

Preparations before Case demonstration: -- alter system flush shared_pool;-- Set timing on;-- Starting from an empty sharing pool, if you operate these test statements multiple times, you need to clear the sharing pool each time,Otherwise, the

Data Guard configures Standby Redo Log Data Guard in maximum protection and maximum availability mode, for real-time use of the maximum performance mode, the Standby database must be configured with the Standby Redo Log www.2cto.com slave database

Understanding of Oracle Database System Global Area (SGA) 1 Overview of Monitoring and Management of www.2cto.com Oracle SGA is an important part of routine database maintenance. This article describes the basic concepts of SGA, the SGA running