Oracle

Note: http://tianzt.blog.51cto.com/459544/171759 this article from the following aspects to collate the concept and operation of the partition table: 1. Table spaces and the concept of partitioned Tables 2. The specific role of table partitioning 3

A detailed explanation of grouping functions and group by correct usage in Oracle database 1. A group by is required to query both the grouped function columns and the non grouped function columns at the same time, but only query grouped function

Always think of their understanding of Oracle can also, especially after the test OCM certification. A few days ago a friend asked me, can you give a brief introduction to Oracle architecture? My mind immediately thought of the previous Oracle 11g

First of all, my data particularity, the table has a large number of CLOB fields, between this, a lot of Niang methods are unable to handle. My approach: 1, create a new table space, the name of course and the original table space is different. 2,

Crs-4124:oracle High Availability Services startup failed. Crs-4000:command Start failed, or completed with errors. OHASD failed to start:inappropriate IOCTL for device OHASD failed to start at/u01/app/11.2.0/grid/crs/install/rootcrs.pl line 443.

 Exp local Export and imp local import Exp command:1 exp username/psw@test file=d:test.dmp full=y2 exp username/psw@test file=d:test.dmp owner= (ly)3 exp username/psw@test file= d:test.dmp tables= (GRID1,GRID2)1 One is the overall export of

The following SQL statements can be used in Pl/sql to query which tables in the current database are locked and which users lock them: SELECTA.owner,--object owned userA.object_name,--object name (table name)B.XIDUSN,B.xidslot,B.XIDSQN,B.SESSION_ID,-

--Current main library PROD3, standby library aux--View Primary Reserve log transmission sys@prod3> select Max (sequence#) from V$archived_log; MAX (sequence#)--------------sys@aux> Select sequence#,applied from V$archived_log ORDER by 1 desc;

There are five main loops: Exit when, loop, while, for (normal loop), for (cursor loop), and below for example one by one (all stored procedures). 1, Exit when cycle:Create or replace procedure Proc_test_exit_when isI number;Begini:=0;LOOPExit when (

We know that Oracle Client language support can be done through the setting of the Nls_lang parameter, and the settings for Nls_lang parameters vary from system platforms. In this article, we first introduce the composition of the Nls_lang

1  table: CREATE TABLE test_tree (test_id int not NULL, pid int, Test_val VARCHAR (), PRIMARY KEY (test_id)); INSERT into Test_tree VALUES (1, 0, '. NET '); INSERT into Test_tree VALUES (2, 1, ' C # '); INSERT into Test_tree VALUES (3, 1, ' J # ');

In general, after the Oracle database installation, there are many default accounts and passwords, more commonly used are: Account: Scott Password: Tiger account: System Password: Manager account: sys password: any character. When we want to create

Select Sysdate current time, sysdate-5 five days ago, sysdate-(5/24) Five hours ago, sysdate-(5/(24 * 60)) Five minutes ago, sysdate-( 5/(24 * 60 * 60)) Five seconds ago, add_months (Sysdate,-5) Five months ago, add_months

2007.1.23 12:31 Author: showxz | Rating: 0 | Reading: 465 Dataload is isn't an Oracle tool. So, that's sells, which means if you can come up with a better tool, your may sell it and the would be waiting; dOracle provides some tools to help data

The Oracle adapter is not connected to the solution Author: Vashon Oracle's developer connection is not reported incorrectly: listener does not currently know of SID given in Connect descriptor solution: In

There are two simple examples to illustrate the efficiency of "exists" and "in" 1 SELECT * from T1 where exists (select 1 from T2 where t1.a=t2.a); When the amount of T1 data is small and the T2 data is very large, the query efficiency of the T1 2)

Since the database was previously installed, there are many problems with reloading the database today. Follow the online tutorials, the removal of the deleted files are removed in a step-by-step, or there is a problem. There are two problems, one

Example: Cursor loop loop cursor SET serveriutput on DECLARE r_emp emp%rowtype; 　　CURSOR C_emp is a SELECT * from EMP; 　　BEGIN OPEN c_emp; 　　LOOP FETCH c_emp into r_emp; 　　EXIT when C_emp%notfound; Dbms_out. Put. Put_Line (' Salary of Employee ' | |

is also a table of 3 million data: --Only the cursor defines a column DeclareCursor Cur_3 is select A.cert_type from Ea_cust.cust_info A;Type t_table is table of VARCHAR2 (100);C_table t_table;to_cust_id varchar2 (100);BeginOpen cur_3;LoopFetch cur_3

A large amount of data was inserted into the database at the time of the test, and the test user and all its data were deleted after the test was completed, but the data file did not shrink. After looking at the data to find that this is the Oracle "