Oracle

Create or Replace TriggerTri_printtest beforeDelete or Insert or Update onTest_exam--Triggering Events forEach row--This procedure needs to be called for each row that is modifiedbeginDbms_output.put_line (: New. Idnew); --idnew value After

Yesterday, a colleague asked some questions about Oracle Tablespace data file Self-growth, in the process of the way to organize, and other colleagues have the same questions can be directly consulted.Experimental content: Creates a mytest

//sqlplus command before backing up the database create a database DMP deposit directorySqlplus/Nologconn/ asSysdbasql> Create or Replace directory Expdir as 'E:/kxdb'; the directory was created. CMD://Export DatabaseEXPDP emms/emms123

Used to know a Linux package that uses a file system to quickly run Oracle, openMethods of Oracle Listener and Oracleservice.The Window family (windowser) may not be very proficient with file operations. Need to right-click PC,

Install Oracle database today, on the official web download a latest version is 12 of this version, direct registration of users can be under, very simple, but the installation of trouble, install to the second step, that is, skip the update of that

/*Note: If you already have the appropriate user and table space, you will need to delete the appropriate user and tablespace before re-establishing all*/--Delete UserDrop UserXnzqweixinCascade;--Delete Table SpaceDropTablespace

BrieflyCola in (x, Y, z) is equivalent to cola=x or cola=y or cola=zCola not in (x, Y, z) is equivalent to! (Cola=x or Cola=y or cola=z) is equivalent to Cola!=x and Cola!=y and Cola!=zBesides Cola=null and Cola!=null, the results of both

Some commonly used are time formatsSelect To_char (sysdate, ' HH24:MI:SS AM ') from dual---12:56:40 pmSelect To_char (To_date (' 2 January-January -95 '), ' yyyy-mm-dd HH24:MI:SS AM ') from dual---1995-01-21 00:00:00Select To_char (sysdate, ' DD '

The stored procedures are as follows:Create procedure gokul_proc( pId in number, pName in varchar2, OutCur OUT G_PKG_REFCUR.rcDataCursor ) isBEGIN Open OutCur For select * from gokul_table ob where ob.active_staus-‘Y‘ AND

--Function creation Create function func1 (DNO number) return number--must have return value is V_max number;--definition return value begin select Max (SAL) into v_ max--assignment from EMP where deptno= DNO; Return v_max;--returns the

Create a temporary table spaceCREATE Temporary 'C:\oracle\product\10.1.0\oradata\orcl\test_temp01.dbf'on NEXT 32M MAXSIZE 2048MEXTENT MANAGEMENT LOCAL;Create a user table spaceCREATE'C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\TEST_DATA01. DBF'onNEXT 3

Oracle Data Pump Import and export case  oracle database Import and Export tool, you can use Exp/imp, but this is the older tool. This paper mainly introduces the use of data pump EXPDP/IMPDP tools. Establishing a data pump catalog using a data pump

4 states of Things in Oracle:commit--Submitrollback--All rolls backSavePoint name;--defines a point that rolls back to here: for example: SavePoint A;Rollback to [savepoint]name--rollback to a specified point such as rollback to A; roll it back to a

1 SELECTSUBSTR (Sys_connect_by_path (Tb.name,' -'),3) name2 from TableTB3START withNVL (Tb.parentid,0)=04CONNECT byPRIOR ID=Mt.parentid5;in Oracle, the primary function of the Sys_connect_by_path function is to differentiate all child nodes

1, about the primary key: the construction of the table when the specified primary key words can:CREATE TABLE Test ( ID Number (6) primary key,Name VARCHAR2 (30));If you want to increase the primary KEY constraint for a table that has already been

Excel connection column names generate Oracle annotationsNOTES:A2 is a column name, B2 is a comment= "Comment on column colagreementheader." &A2& "is Q ' {" &B2& "} ';"The effect is as follows: Comment on column table1.

1.oracle Viewing table space usage1) Use SYSDBA to enter Sqlplus--Query tablespace usage Select UPPER (f.tablespace_name) "tablespace name", D.TOT_GROOTTE_MB "table space size (M)", D.TOT_GROOTTE_MB -F.total_bytes "used Space (M)", To_char (ROUND

Http://blog.sina.com.cn/s/blog_601d1ce30100cyrb.htmlThere are two simple examples to illustrate the efficiency issues of "exists" and "in"1) SELECT * from T1 where exists (select 1 from T2 where t1.a=t2.a);When the T1 data volume is small and the T2

ORACLE11g poisoning recovery   Unfortunately, the win2003 server is neglected to manage and poisoned. After the virus is cleared, oracle is paralyzed. What should I do if the last backup is still one week ago?The first idea is to find another

Some changes need to be made when OracleClient10g is installed on Windows 7. The new notebook, Windows 7 Pro, needs to install the Oracle Client, the colleague gave a 10G version. Prompt during installation: "Checking operating system requirements.