Oracle

Oracle has a data that is already 25 million data, the software used to this table data is very slow, so ready to one months ago the data cleared.My steps are (the bottom operations are all running in plsql)1. First export this month's data to a

Oracle uses the audit_trail parameter to control whether auditing is enabledThere are several parameters to the Audit_trail:None: Audit not openOS: Description Audit information is put on the system summary, if it is Linux then determined by

Using system;using system.data;using System.Data.OleDb;　　 ///query Oracle stored procedures via OLE/////& lt;/param>// public static DataTable gettodolist (string id) { String connString1 = "PROVIDER=ORAOLEDB.ORACLE.1; User id=test;

The star is wide, the moon Chant River, is with colleagues bragging blow, the boss came, cough a sound. Everyone immediately quiet, each back to you, do each thing.I just sat down and the boss came to me. There is a built library of live, time is

Import jar Package in Oracle to import the required jar package, we put the edited Java class into a jar package, directly in the oarcle to write a simple call on it,1, the operating system needs to have a JDK that supports the Loadjava command. 2,

  Go from http://www.cnblogs.com/252e/archive/2012/09/13/2682817.html query and delete duplicate record SQL statement  1, find redundant duplicate record in table, Duplicate records are based on a single field (ID) to determine  select * from table

Summarize the next few problems with the use of Utl_http packageAbout the Utl_http package function is also very powerful can be through him to capture the content of the site page or call a URL interface to complete a function eg:declare  req

Reprint Address: http://www.cnblogs.com/kerrycode/p/3285936.htmlTemporal table ConceptsA temporary table is a database object that is used to temporarily save temporary data (or intermediate data), which is somewhat similar to a normal table, but is

Many excerpts from the articleHttp://blog.163.com/[email protected]/blog/static/7956964020131069843572/At the same time, based on this article, to supplement some of the learning points, if there are questions, hope to point out the discussion.1

14. Sname, CNO and degree columns for all students are queried.Select T.sname,c.cno,c.degree from student t Inner joins score C on T.sno=c.sno15. Check the SNO, CNAME and degree columns of all students.Select T.sno,s.degree,c.cname from student T,

A table customers and B table tmp_cust_city have 3 identical fields, Customer_id,city_name,customer_type now to update a table according to the B tableUpdate a field condition:Update Customers ASet City_name= (select B.city_name from tmp_cust_city b

If the table structure corresponds to only one field, you can select col1 bulk collect into variable without a cursor loop, simple and efficientCreate or Replace function Get_airway_subpoint (awid in number)Return Airway_subpnts_tab is--create OR

A detailed explanation of the use of Exp,imp in OracleBasic syntax and examples:1. EXP:There are three main ways (full, user, table)1. Complete:EXP System/manager buffer=64000 file=c:\full. DMP full=yIf you want to perform a full export, you must

Oracle cannot set primary key self-increment as MySQL does, and Oracle uses to make one or more columns of a data table self-increasingSequence sequence+ Trigger trigger: Implements the self-increment of the primary key in the data table S_departPL/

Import and export of--oracle user objects exp devimage/[email protected]/testdb owner= ' devimage ' file=d:/devimage.dmp log=d:/ Devimage.logimp wxtest5star03/[email protected]/orcl fromuser= ' devimage ' touser= ' wxtest5star03 ' FILE=D:/

String sql= "SELECT * FROM (select E.*,rownum r from (SELECT * to emp ORDER BY sal Desc) e) where r between? and? ";String sql= "SELECT * FROM (select E.*,rownum r from (SELECT * to emp ORDER BY sal Desc) e) where r between 6 and 10";StringBuilder

0 Modifying port number methodsCommand Window (Cmd.exe): Run sqlplus/nolog, then conn/as sysdba, then exec dbms_xdb.sethttpport (1521)1 Modifying the connection properties of a service ORCLAdministrators run database configuration Assistant,

This is because the Oracle database requires a commit after updating the data, or it will jam, and it will get stuckAfter each call to Executeupdate (), the database will be automatically commit.My base class adds a bit, note the Red font part code:/

Database to run in archive mode:Archive Log ListShutdown immediateStartup MountALTER DATABASE Archivelog;ALTER DATABASE open;Archive Log ListHot Backup Users Table space:(1) Test environment related Information viewCreate a backup

Create user drop users lztest4 cascade;create user Lztest4 identified by lztest123;alter user Lztest4 default Tablespace common_cab Le;grant Connect, resource,dba to Lztest4; drop user lztest3 cascade;create user lztest3 identified by Lztest123;alte