Oracle

  Http://lwl0606.cmszs.com/archives/Oracle-Split-string-Function. Html Create or replace type varchar2varray is varray (100) of varchar2 (40 );/ Create or replace function sf_split_string (string varchar2, substring varchar2) return

Sqlplus/nolog Conn/As sysdba Shutdown immediate; Startup Mount; Alter session set SQL _trace = true;Alter system enable restricted session;Alter system set job_queue_processes = 0;Alter system set aq_tm_processes = 0;Alter database open; Set

/*************************************** * ****************************** Query the select * from object deleted by the Drop operation recyclebin; restore a flashback table (the type of the deleted object) for a single object (table, index, or other

The bulk is introduced for the first time in Oracle8i.Collect feature. This feature allows you to use batch queries in PL/SQL. Batch queries can significantly improve query efficiency in some cases. Now, we have some simple tests and scores on this

Step 1: Use the following SQL statement to view the process list and identify the locked table Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->SELECT dob. OBJECT_NAME Table_Name, lo. SESSION_ID | ','

Http://lwl0606.cmszs.com/archives/oracle-string-add-function.html Add the DSPNAME values of the same Account as the following table.Account DSPNAMEL1 aaL1 bbL2 ccResult L1 aa, bb L2 cc Method 1: Use cursor in the function   Code highlighting

Http://lwl0606.cmszs.com/archives/excel-vba-string-function.html Create a table and write the stored procedure with output parameters. Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->Create or

From:Http://cache.baidu.com/c? M = Response & p = Response & newp = Response & user = baidu & fm = SC & query = java % 2 Esql % 2 ESQLException % 3A + ORA % 2D01788% 3A + % B4 % CB % B2 % E9 % D1 % AF % BF % E9 % D6 % D0 % D2 % AA % C7 % F3 +

This article will explain Oracle Data Compression in two aspects: Using index keys to compress tables that are read-only or primarily read tables. Oracle supports the compression of index structures and database tables. The compression algorithms of

1. PrefaceCurrently, all applications that use Oracle for data processing are supported by Alibaba Cloud. Most of the systems with larger data volumes than other systems are supported, that is, the data volume of a table is generally larger than a

When I was doing a project, a colleague accidentally duplicate all the data in a table while importing data. That is to say, all the records in this table have a record. This table has tens of millions of data records and is a production system.

1. Basic concepts: Database connection strings are mainly used to establish access methods for remote databases. They can directly read or modify data in remote Oracle databases. The database connection string can be PUBLIC connection or PRIVATE

Chapter 1: Log Management     1.forcing log switches     sql> alter system switch logfile;     2.forcing checkpoints     sql> alter system checkpoint;     3.adding online redo log groups     sql> alter

46.Connect multiple scans If you compare a column with a limited set of values, the Optimizer may perform multiple scans and merge the results. Example: SELECT * FROM LODGING Where manager in ('bill Gates', 'Ken muller ');   The Optimizer may

13.Calculate the number of records In contrast, count (*) is slightly faster than count (1). Of course, if you can search by index, the index column COUNT is still the fastest. For example, count (EMPNO)   (Press:In CSDNForum,I have had a very

Oracle 10 Gb database is an object-oriented RDBMS consisting of Oracle Database and Oracle routine. To install the database server, copy the following parts or files from the installation disk to the folder structure of the computer's hard disk, and

Recently, we found these strange table names in oracle. After searching online, we found that it was the oracle10g recycle bin function. Instead of deleting the table completely, we put the table into the recycle bin, at last, a bunch of strange

When a user process connects to the database and creates a corresponding session, the Oracle service process sets a PGA zone for the user to store the relevant content of the user session. When the user session ends, the Database System

Various Processes in the Oracle system can be divided into two categories: 1. the user process that executes the application or Oracle tool code ). 2. The Oracle process that executes the Oracle database server code ). This includes server process

One type: Sub test ()''Test macro' Dim cn As ADODB. ConnectionDim rs As ADODB. RecordsetSet cn = New ADODB. ConnectionCn. Open "Provider = OraOLEDB. Oracle.1; PassWord = XXXX; Persist Security Info = True; User ID = XXXX; Data Source = XXXX;