Oracle

[Oracle] string parsing generates associated data because the project function sometimes needs to be provided by other departments in Excel... in other documents, some data is inserted into the database tables without interruption, so a simple

Oracle stored procedure and serialized write demo 1. create an Oracle stored procedure, set a parameter n, run the stored procedure, and pass the parameter n. After the execution, the output is five times hello world. Note: The for loop is used in

Greenplum management sequence does not support currval and lastval. It only supports nextval and cannot be used in update and delete statements. If sorting is enabled, the sequence cannot be used in the update or delete statements. Gtlions = #

The parameters related to oracle semi-join (in, exists) Semi-join and anti-connection are actually in and exists. Before that, I was confused about these things, I think there are some online saying that exists is better than in, and so on. in fact,

The PRAGMA AUTONOMOUS_TRANSACTION autonomous transaction application can define one or several autonomous transactions in one of your transactions (outer transactions. An autonomous transaction can be committed independently without affecting the

Oracle archive Mode 1. Check whether archive log list is archived; 2. Enable archive mode shutdown immediate; startup mount; alter database archivelog; alter database open; archive log list; ----- confirm whether archive is enabled 3. The number of

Oracle stored procedure Note-DUAL in oracle, we sometimes need to determine whether a string contains a string. First, oracle provides us with the instr function: instr (string1, string2 [, start_position [, nth_appearance]) parameter analysis:

Rac10201 for RHEL5 (error while loading shared libraries: libpthread. so.0) Solve [root @ raw01 bin] #. /vipca/u01/app/oracle/product/11.2.0/dbhome_1/jdk/jre/bin/java: error while loading shared libraries: libpthread. so.0: cannot open shared object

Database Learning (2) -- SQL language OverviewDatabase Learning (1) -- Introduction to relational database http://www.bkjia.com/database/201304/205333.htmlSQLStructured Query language (Structured) is a Structured Query language, which is a standard

Database Learning (3) -- database creation and deletion (2) -- SQL language Overview http://www.bkjia.com/database/201305/207487.html In the subsequent operations section, we recommend that you install MySQL for your convenience. The installation of

The common dynamic performance view V $ FIXED_TABLE in ORACLE is used to list all available dynamic performance views and dynamic performance tables. V $ INSTANCE is used to obtain detailed information about the current routine. V $ SGA is used to

Oracle rowid and postgresql ctid first introduces oracle rowid, the physical identification SQL> select rowid from book_info where rownum select dbms_rowid.rowid_object (rowid) object _ Id, struct (rowid) file_id, dbms_rowid.rowid_block_number

When dbms_backup_restore is used to modify the DBID database, what else cannot be modified? In some special circumstances, we may need to modify the DBID of the database, and sometimes it may only be modifying the control file. Starting from Oracle10

Oracle virtual index does not consume CPU, IO, and storage space. It is used to determine whether the created index can be used. The following example shows: SQL> create table tb1 as select owner, object_name, object_id from dba_objects; -- create

Check the table space and table size in the oracle database today. It seems that the table space is too large. Find the following information and first query the space occupied BY the TABLE. Use the following statement: SQL code SELECT SEGMENT_NAME,

Oracle export/import and Character Set Information viewing for data import and export, we should pay attention to the character set issue. In the EXP/IMP process, we need to pay attention to the four character set parameters: the client character

Oracle replication table structure and data 1. copy the table structure and data: create table table_name_new as select * from table_name_old 2. copy only the table structure: create table table_name_new as select * from table_name_old where 1 = 2;

[Oracle] The first thing to note about the maddening ORA-01555 problem is that a ORA-01555 error is a "secure" error that won't cause data loss or corruption, only make the query that receives this error Unable to continue, therefore, in the routine

Select year, month, day, and quarter for the ORACLE time field -- get year, month, and quarter select to_char (date, 'yyyymmdd') DATE_ID, to_char (date, 'yyyy ') | 'Year' | to_char (date, 'mm') | 'month' | to_char (date, 'dd') | 'day' DATE_NAME,

Solaris, the Oracle Bug solving platform for solaris, reports the error message oracle10202: Terminate the output from the derivative process. Information: ---------------------------------- information: The operation encountered an exception error: