Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÉîÈëdz³öoracleËø Ô­ÀíÆª & Í£Ö¹ÎÞ·´Ó¦µÄsql»á»°

ÔÚÏÖ´úµÄ¶àÓû§¶àÈÎÎñϵͳÖУ¬±ØÈ»»á³öÏÖ¶à¸öÓû§Í¬Ê±·ÃÎʹ²ÏíµÄij¸ö¶ÔÏó£¬Õâ¸ö¶ÔÏó¿ÉÄÜÊÇ±í£¬ÐУ¬»òÕßÄÚ´æ½á¹¹£¬ÎªÁ˽â¾ö¶à¸öÓû§²¢·¢ÐÔ·ÃÎÊ´øÀ´µÄÊý¾ÝµÄ°²È«ÐÔ£¬ÍêÕûÐÔ¼°Ò»ÖÂÐÔÎÊÌ⣬±ØÐëÒªÓÐÒ»ÖÖ»úÖÆ£¬À´Ê¹¶ÔÕâЩ¹²Ïí×ÊÔ´µÄ²¢·¢ÐÔ·ÃÎÊ´®Ðл¯£¬oracleÖеÄËø¾Í¿ÉÒÔÌṩÕâÑùµÄ¹¦ÄÜ£¬µ±ÊÂÎñÔÚ¶Ôij¸ö¶ÔÏó½øÐвÙ×÷ǰ£¬ÏÈÏòϵͳ·¢³öÇëÇó£¬¶ÔÆä¼ÓÏàÓ¦µÄËø£¬¼ÓËøºó¸ÃÊÂÎñ¾Í¶Ô¸ÃÊý¾Ý¶ÔÏóÓÐÁËÒ»¶¨µÄ¿ØÖÆÈ¨ÏÞ£¬ÔÚ¸ÃÊÂÎñÊÍ·ÅËøÖ®Ç°£¬ÆäËûµÄÊÂÎñ²»ÄܶԴËÊý¾Ý¶ÔÏó½øÐиüвÙ×÷£¨¿ÉÒÔ×öselect¶¯×÷£¬µ«select ÀûÓõÄÊÇundoÖеÄǰ¾µÏñÊý¾ÝÁË£©.
OracleËøµÄ·ÖÀà
OracleËø»ù±¾ÉÏ¿ÉÒÔ·ÖΪ¶þÀà
a£º¹²ÏíËø£¨share locks£©  Ò²³Æ¶ÁËø£¬sËø
b£ºÅÅËüËø (exclusive locks) Ò²³ÆÐ´Ëø£¬xËø
ÔÚÊý¾Ý¿âÖÐÓÐÁ½ÖÖ»ù±¾µÄËøÀàÐÍ£ºÅÅËüËø£¨Exclusive Locks£¬¼´XËø£©ºÍ¹²ÏíËø£¨Share Locks£¬¼´SËø£©¡£µ±Êý¾Ý¶ÔÏó±»¼ÓÉÏÅÅËüËøÊ±£¬ÆäËûµÄÊÂÎñ²»ÄܶÔËü¶ÁÈ¡ºÍÐ޸ġ£¼ÓÁ˹²ÏíËøµÄÊý¾Ý¶ÔÏó¿ÉÒÔ±»ÆäËûÊÂÎñ¶ÁÈ¡£¬µ«²»ÄÜÐ޸ġ£Êý¾Ý¿âÀûÓÃÕâÁ½ÖÖ»ù±¾µÄËøÀàÐÍÀ´¶ÔÊý¾Ý¿âµÄÊÂÎñ½øÐв¢·¢¿ØÖÆ¡£
°´Ëø±£»¤µÄÄÚÈÝ·ÖÀà
oracleÌṩ¶àÁ£¶È·âËø»úÖÆ£¬°´±£»¤¶ÔÏóÀ´·Ö£¬¾Ý´ËÓÖ¿ÉÒÔ·ÖΪ
a£ºdmlËø£¬ data locks Êý¾ÝËø£¬ÓÃÀ´±£»¤Êý¾ÝµÄÍêÕûÐÔºÍÒ»ÖÂÐÔ
b£ºddlËø£¬ dictionary locks ×ÖµäËø£¬ÓÃÀ´±£»¤Êý¾Ý¶ÔÏóµÄ½á¹¹£¬Èçtable£¬indexµÄ¶¨Òå
c£ºÄÚ²¿ËøºÍãÅ internal locks and latchs ÓÃÀ´±£»¤Êý¾Ý¿âÄÚ²¿½á¹¹£¬ÈçsgaÄÚ´æ½á¹¹
dmlËø
DMLËøÖ÷Òª°üÀ¨TMËøºÍTXËø£¬ÆäÖÐTMËø³ÆÎª±í¼¶Ëø£¬TMËøµÄÖÖÀàÓÐS,X,SR,SX,SRXÎåÖÖ£¬TXËø³ÆÎªÊÂÎñËø»òÐм¶Ëø¡£µ±OracleÖ´ÐÐdelete,update,insert,select for update  DMLÓï¾äʱ£¬oracleÊ×ÏÈ×Ô¶¯ÔÚËùÒª²Ù×÷µÄ±íÉÏÉêÇëTMÀàÐ͵ÄËø¡£µ±TMËø»ñµÃºó£¬ÔÙ×Ô¶¯ÉêÇëTXÀàÐ͵ÄËø£¬²¢½«Êµ¼ÊËø¶¨µÄÊý¾ÝÐеÄËø±ê־λ(lb ¼´lock bytes)½øÐÐÖÃλ¡£ÔڼǼ±»Ä³Ò»»á»°Ëø¶¨ºó£¬ÆäËûÐèÒª·ÃÎʱ»Ëø¶¨¶ÔÏóµÄ»á»°»á°´ÏȽøÏȳöµÄ·½Ê½µÈ´ýËøµÄÊÍ·Å£¬¶ÔÓÚselect²Ù×÷¶øÑÔ£¬²¢²»ÐèÒªÈκÎËø£¬ËùÒÔ¼´Ê¹¼Ç¼±»Ëø¶¨£¬selectÓï¾äÒÀÈ»¿ÉÒÔÖ´ÐУ¬Êµ¼ÊÉÏ£¬ÔÚ´ËÇé¿öÏ£¬oracleÊÇÓõ½undoµÄÄÚÈݽøÐÐÒ»ÖÂÐÔ¶ÁÀ´ÊµÏֵġ£
ÔÚ OracleÊý¾Ý¿âÖУ¬µ±Ò»¸öÊÂÎñÊ״η¢ÆðÒ»¸öDMLÓï¾äʱ¾Í»ñµÃÒ»¸öTXËø£¬¸ÃËø±£³Öµ½ÊÂÎñ±»Ìá½»»ò»Ø¹ö¡£ÔÚÊý¾ÝÐÐÉÏÖ»ÓÐXËø£¨ÅÅËûËø£©£¬¾ÍÊÇ˵TXËøÖ»ÄÜÊÇÅÅËûËø£¬ÔڼǼÐÐÉÏÉèÖù²ÏíËøÃ»ÓÐÒâÒå¡£µ±Á½¸ö»ò¶à¸ö»á»°ÔÚ±íµÄͬһÌõ¼Ç¼ÉÏÖ´ÐÐDMLÓï¾äʱ£¬µÚÒ»¸ö»á»°ÔÚ¸ÃÌõ¼Ç¼ÉϼÓËø£¬ÆäËûµÄ»á»°´¦ÓÚµÈ


Ïà¹ØÎĵµ£º

sql 2005 ´æ´¢¹ý³Ì·ÖÒ³ java ´úÂë

 create PROCEDURE pagelist
@tablename nvarchar(50),
@fieldname nvarchar(50)='*',         
@pagesize int output,--ÿҳÏÔʾ¼Ç¼ÌõÊý
@currentpage int output,--µÚ¼¸Ò³
@orderid nvarchar(50),--Ö÷¼üÅÅÐò
@sort int,--ÅÅÐò·½Ê½£¬1±íʾÉýÐò£¬0±íʾ½µÐòÅÅÁÐ ......

C# Á¬½ÓsqlÊý¾Ý¿â¶Ô access£¬excelµ¼Èëµ¼³ö²Ù×÷


 
Ò»¡¢SQL SERVER ºÍACCESSµÄÊý¾Ýµ¼Èëµ¼³ö
³£¹æµÄÊý¾Ýµ¼Èëµ¼³ö£º
ʹÓÃDTSÏòµ¼Ç¨ÒÆÄãµÄAccessÊý¾Ýµ½SQL Server£¬Äã¿ÉÒÔʹÓÃÕâЩ²½Öè:
¡¡¡¡¡ð1ÔÚSQL SERVERÆóÒµ¹ÜÀíÆ÷ÖеÄTools£¨¹¤¾ß£©²Ëµ¥ÉÏ£¬Ñ¡ÔñData Transformation
¡¡¡¡¡ð2Services£¨Êý¾Ýת»»·þÎñ£©£¬È»ºóÑ¡Ôñ  czdImport Data£¨µ¼ÈëÊý¾Ý£©¡£
¡¡¡¡¡ ......

JAVAÖзÀÖ¹SQL×¢Èë¹¥»÷ÀàµÄÔ´´úÂë

package cn.com.hbivt.util;
/**
* <p>Title: </p>
*
* <p>Description: </p>
*
* <p>Copyright: Copyright (c) 2005</p>
*
* <p>Company: </p>
*
* @author not attributable
* @version 1.0
*/
public class StringUtils {
//¹ýÂËͨ¹ýÒ³Ãæ±íµ¥Ìá½» ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ