oracle ÐèҪעÒâµÄµØ·½
INSERT /*+APPEND */ INTO employee (empno,ename,sal,deptno)
SELECT empno,ename,sal,deptno from emp
WHERE deptno=20;
µÚ¶þÌõÓï¾äʹÓÃ/*+APPEND */À´±íʾ²ÉÓÃÖ±½Ó×°ÔØ·½Ê½£¬µ±Òª×°ÔØ´óÅúÁ¿Êý¾Ýʱ£¬²ÉÓõڶþÖÖ·½·¨×°ÔØÊý¾ÝµÄËÙ¶ÈÒªÔ¶Ô¶ÓÅÓÚµÚÒ»ÖÖ·½·¨¡£
ʹÓöà±í²åÈëÊý¾Ý
ʹÓÃALL²Ù×÷·ûÖ´Ðжà±í²åÈëʱ£¬ÔÚÿ¸öÌõ¼þ×Ó¾äÉ϶¼ÒªÖ´ÐÐINTO×Ó¾äºóµÄ×Ó²éѯ//Òâ˼ºÃÏñÊÇ˵ÏÂÃæ²åÈëʱҪִÐÐËÄ´ÎSELECTÁË ¿´À´Ð§ÂÊÉϲ»¸ß°¡ É÷ÓÃ
INSERT ALL
WHEN deptno=10 THEN INTO dept10
WHEN deptno=20 THEN INTO dept20
WHEN deptno=30 THEN INTO dept30
WHEN job='CLERK' THEN INTO clerk
ELSE INTO other
SELECT * from emp;
ʹÓÃFIRST ²Ù×÷·ûÖ´Ðжà±í²åÈë
µ±Ê¹ÓÃFIRST²Ù×÷·ûÖ´Ðжà±í²åÈëʱ£¬Èç¹ûÊý¾ÝÒѾÂú×ãÁËÏÈÇ°Ìõ¼þ£¬²¢ÇÒÒѾ±»²åÈ뵽ij±í£¬ÄÇô¸ÃÐÐÊý¾ÝÔÚºóÐø²åÈëÖн«²»»á±»ÔÙ´ÎʹÓà //Õâ¸öЧÂÊ»áºÜ¿ì
INSERT FIRST
WHEN deptno=10 THEN INTO dept10
WHEN deptno=20 THEN INTO dept20
WHEN deptno=30 THEN INTO dept30
WHEN job='CLERK' THEN INTO clerk
ELSE INTO other
SELECT * from emp
ÔÚ¸üР²åÈëʱdateÊý¾Ý ×îºÃÓÃTO_DATEº¯Êý½øÐд¦ÀíÒ»ÏÂ
update Óï·¨
UPDATE<table|view>
SET<column>=<value>[,<column>=<value>]
[WHERE <condition>];
UPDATE emp SET (job,sal,comm)=(SELECT job,sal,comm from emp='SMITH') WHERE ename='SCOTT'
delete Óï·¨
DELETE from <table|view> [WHERE<condition>]
ÉèÖñ£´æµã
savepoint a;
exec dbms_transaction.savepoint('a');
È¡Ïû²¿ÃÅÊÂÎñ
roolback to a ;
exec dbms_transaction.rollback_savepoint('a')
×¢Òâµ±ÉèÖÃÖ»¶ÁÊÂÎñʱ£¬¸ÃÓï¾ä±ØÐëÊÇÊÂÎñ¿ªÊ¼µÄµÚÒ»ÌõÓï¾ä£¬ÁíÍâÔÚÓ¦ÓóÌÐòÖРʹÓùý³ÌREAD_ONLYÒ²¿ÉÒÔÉèÖÃÖ»¶ÁÊÂÎñ
SET TRANSACTION READ ONLY;
or
exec dbms_transaction.read_only
˳ÐòÊÂÎñ
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
Ïà¹ØÎĵµ£º
¼òµ¥ÃèÊöÒ»ÏÂÔÚwindowsµÄͬһÓû§Ï£¬°²×°OracleµÄ9i¡¢10gºÍ11gµÄ·½·¨¡£
OracleÔÚwindowsƽ̨ϵݲװÊÇËùÓÐƽ̨ÖÐ×î¼òµ¥µÄ£¬»ù±¾Éϲ»ÐèÒª½øÐÐÈκζîÍâµÄ´¦Àí¾Í¿ÉÒԳɹ¦µÄ°²×°£¬¿ÉÒÔ˵ûÓÐʲô¼¼Êõº¬Á¿¡£
²»¹ýÔÚͬһ̨»úÆ÷µÄͬһ¸öÓû§ÉÏͬʱ°²×°Á½¸ö²»Í¬°æ±¾µÄÊý¾Ý¿â¾ÍÐèÒªÒ»¶¨µÄ¼¼ÇÉÁË¡£ÕâÀï¼òµ¥ÃèÊöÒ»ÏÂÔÚͬʱ ......
DBA Ö°Ôð¼°ÈÕ³£¹¤×÷Ö°Ôð:
1.°²×°ºÍÉý¼¶Êý¾Ý¿â·þÎñÆ÷,ÒÔ¼°Ó¦ÓóÌÐò¹¤¾ß¹¹½¨ºÍÅäÖÃÍøÂç»·¾³.
2.ÊìϤÊý¾Ý¿âϵͳµÄ´æ´¢½á¹¹Ô¤²âδÀ´µÄ´æ´¢ÐèÇó,Öƶ©Êý¾Ý¿âµÄ´æ´¢·½°¸.
3.¸ù¾Ý¿ª·¢ÈËÔ±Éè¼ÆµÄÓ¦ÓÃϵͳÐèÇó´´½¨Êý¾Ý¿â´æ´¢½á¹¹.
4.¸ù¾Ý¿ª·¢ÈËÔ±Éè ......
½ñÌì¿´µ½Ò»Æª¹ØÓÚORA_ROWSCNµÄÎÄÕ£¬ËäÈ»¼ò¶Ì£¬Ã»ÓÐʲôʵÀý£¬µ«ÊÇÒѾ°ÑORA_ROWSCN´ó¸ÅÊÇÔõô»ØʽéÉÜÇå³þÁË¡£¼Ç¼һÏ¡£
=================================================================================
ĬÈϵÄÇé¿öÏ£¬Ã¿¸ö¿éÖÐËùÓеļǼµÄORA_ROWSCN¶¼ÊÇÏàͬµÄ£¬µ±¿éÖÐÈÎÒâÒ»Ìõ¼Ç¼·¢Éú¸Ä±äµÄÇé¿öÏ£¬¿éÖÐËùÓм ......
ʹÓõÄÊÇADODB¿â,ÐèÒªÓÐOCI8¿â.
<?php
//require("adodb5/adodb-exceptions.inc.php");
require("adodb5/adodb.inc.php");
$conn = NewADOConnection("oci8");
$conn->Connect($url, $user, $password, $service_name);
$rs;
try {
$rs = $conn->Execu ......
2009-04-22 22:00
À´Ô´£ºÖйú
IT
ʵÑé
ÊÒ ×÷ÕߣºØýÃû
Oracle
¿Í
Ȥ
¶ËÓë·þ
Îñ
Æ÷¶ËµÄ
Á¬
½ÓÊÇͨ
¹ý
¿Í
Ȥ
¶Ë
·¢
³ö
Á¬
½Ó
Çë
Çó£¬ÓÉ·þ
Îñ
Æ÷¶Ë
¼à
ÌýÆ÷
¶Ô
¿Í
Ȥ
¶Ë
Á¬
½Ó
Çë
Çó
½ø
ÐкϷ¨
¼ì²é
£¬Èç¹û
Á¬
½Ó
Çë
ÇóÓÐЧ£¬
Ôò½ø
ÐÐ
Á¬
½Ó£¬·ñ
Ôò
¾Ü
¾ø¸ÃÁ¬
½Ó¡£ ......