Oracleɾ³ýÖظ´¼Ç¼
Oracleɾ³ýÖظ´¼Ç¼µÄ×îºÃµÄ·½·¨£º
DELETE from EMP E WHERE E.ROWID > (SELECT MIN(y.ROWID)
from EMP y
WHERE y.EMPNO = E.EMPNO )
1¡¢×Ó²éѯÕÒ³öijԱ¹¤×îµÍµÄROWID£¨¿Ï¶¨Ö»ÓÐÒ»¸ö£©£¬ÆäËü´óÓÚÕâÌõ¼Ç¼ROWIDµÄ£¬È«²¿É¾³ý¡£
2¡¢OracleÖÐʹÓÃROWIDɾ³ýÖظ´¼Ç¼×î¿ì,ÒòΪRowid¶ÔÓ¦ÕâÌõ¼Ç¼ÔÚ´ÅÅÌÉϵÄλÖÃ
ÃæÊÔ£ºÐÔÄÜÓÅ»¯
¹æÔò£ºSELECT×Ó¾äÖбÜÃâʹÓà ‘ * ‘
¹æÔò£ºÊ¹ÓÃexistsÓï¾ä´úÌæinÓï¾ä£»
ʹÓÃnot exists´úÌænot in
¹æÔò£ºÊ¹ÓÃtruncate´úÌædelete from ±íÓï¾ä
¹æÔò£º¼õÉÙ·ÃÎÊÊý¾Ý¿âµÄ´ÎÊý
¹æÔò£º¼õÉÙ·ÃÎÊÊý¾Ý¿âµÄ´ÎÊý
¹æÔò£ºÊ¹ÓñíµÄ±ðÃû(Alias)
¹æÔò£º¾¡¿ìʹÓÃCOMMIT
¹æÔò£ºÊý¾Ý¿âÈßÓà×ֶεÄÉè¼Æ
ÆäËü£ºOracleÓëÐÔÄÜÓйصļ¸¸öÌØÕ÷(Èý¸ö»º³åÇø)
ÃæÊÔ£ºÆóҵΪʲô¾³£Ê¹ÓÃOracle? OracleΪʲôÕâôţ?
»Ø´ð£º´ÓÈý¸ö»º³åÇøÈëÊÖ
Ò»¡¢ÈÕÖ¾»º³åÇø
·ÔÚÌí¼ÓÒ»Ìõ¼Ç¼ʱ,Êý¾Ý¿âÔÚºǫ́ͬʱҲҪ¼Ç¼һÌõÈÕÖ¾
·OracleÄܹ»ÏȽ«ÈÕ־дÔÚÄÚ´æÖÐ,»º³åÇøÂúºóÔÙÒ»´ÎÐÔдÈë´ÅÅÌ
¶þ¡¢¿é»º³åÇø
·Èç¹ûÒ»¸ö±í(È粿Ãűí)ºÜÉÙ¸üе«¾³£Ê¹ÓÃ,ÄÇô¿ÉÒÔ½«¸Ã±í±£´æÔÚÄÚ´æÖÐ,´Ó¶ø±ÜÃâƵ·±·ÃÎÊ´ÅÅÌ¡£
··ÃÎÊÄÚ´æµÄËٶȴóÓÚ¸ßÓÚ·ÃÎÊ´ÅÅ̵ÄËٶȡ£
Èý¡¢SQL»º³åÇø
·Êý¾Ý¿âÖ´Ðв½Ö裺Óï·¨·ÖÎö¡¢ÓïÒå·ÖÎö¡¢±àÒë¡¢ÓÅ»¯……
·ËùÒÔSQLÔÚÖ´ÐÐÒÔÇ°ËùÏûºÄµÄʱ¼äÊǺܳ¤µÄ
·OracleÊý¾Ý¿â»á½«sql±£´æÔÚSQL»º³åÇø£¬Èç¹ûÖ´ÐеÄÊÇÏàͬSQL,ÔòÎÞÂÛÖ´ÐжàÉٴΣ¬¶¼Ö»»á±àÒë·ÖÎöÒ»´Î¡£´Ó¶ø¼õÉÙ·ÖÎöºÍÓÅ»¯Ê±
¼ä¡£
Ïà¹ØÎĵµ£º
ÒÑÓм¸¸öÏîÄ¿×鿪ʼʹÓÃoracleµÄÈ«ÎÄË÷Òý¡£OracleµÄ´Ê·¨·ÖÎöÆ÷Õë¶ÔZHS16GBK×Ö·û¼¯µÄ´Ê·¨·ÖÎöÉв»¹»ÖÇÄÜ£¬Ö»ÄÜ»úеµØÒÔ×ÖΪµ¥Ôª
½øÐÐÆ¥Åä¡£¶ÔÓÚutf8×Ö·û¼¯µÄÊý¾Ý¿âÓÐÒ»¸öеĺºÓï·ÖÎöÆ÷chinese_lexer£¬Ð§ÂÊÓÐÁ˺ܴó¸ÄÉÆ¡£ÏÖ½«ÑéÖ¤²¢ÕûÀí¹ýµÄÈçºÎ½øÐÐoracleÈ«ÎÄ
Ë÷ÒýÉèÖõÄÎĵµ·¢¸ø´ó¼Ò£¬ÊÊÓÃÓÚ8i¡¢9i¸÷ƽ̨°æ±¾¡£
¡¡¡¡¶ÔÓ ......
Ò».rowid¼ò½é
rowid¾ÍÊÇΨһ±êÖ¾¼Ç¼ÎïÀíλÖõÄÒ»¸öid£¬ÔÚoracle 8°æ±¾ÒÔÇ°£¬rowidÓÉfile#+block#+row#×é³É£¬Õ¼ÓÃ6¸öbytesµÄ¿Õ¼ä£¬10 bit µÄ file# £¬22bit µÄ block# £¬16 bit µÄ row#¡£
´Óoracle 8¿ªÊ¼rowid±ä³ÉÁËextend rowid£¬ÓÉdata_object_id#+rfile#+block#+row#×é³É£¬Õ¼ÓÃ10¸öbytesµÄ¿Õ¼ä£¬ 32bitµÄ data_object_ ......
ËäÈ»ÒÔÇ°ÓÃÁ˼¸ÄêµÄORACLE µÄpl/sql µ«°²×°½ñÌ컹ÊǵÚÒ»´Î£º
1£º »¹ÊÇÏȲο¼Ò»ÏÂÍøÕ¾£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
1. Oracle 10g windows ƽ̨Ï°²×°
¡¡¡¡ÏÂÔصØÖ·£º http://download.csdn.net/source/1850497¡¡¡¡
¡¡¡¡ÔÚÏß¹Û¿´µØÖ·£ºhttp://v.youku.com ......
OracleµÄÎﻯÊÓͼÌṩÁËÇ¿´óµÄ¹¦ÄÜ£¬¿ÉÒÔÓÃÓÚÔ¤ÏȼÆËã²¢±£´æ±íÁ¬½Ó»ò¾Û¼¯µÈºÄʱ½Ï¶àµÄ²Ù×÷µÄ½á¹û£¬ÕâÑù£¬ÔÚÖ´Ðвéѯʱ£¬¾Í¿ÉÒÔ±ÜÃâ½øÐÐÕâЩºÄʱµÄ²Ù×÷£¬¶ø´Ó¿ìËٵĵõ½½á¹û¡£ÎﻯÊÓͼÓкܶ෽ÃæºÍË÷ÒýºÜÏàËÆ£ºÊ¹ÓÃÎﻯÊÓͼµÄÄ¿µÄÊÇΪÁËÌá¸ß²éѯÐÔÄÜ£»ÎﻯÊÓͼ¶ÔÓ¦ÓÃ͸Ã÷£¬Ôö¼ÓºÍɾ³ýÎﻯÊÓͼ²»»áÓ°ÏìÓ¦ÓóÌÐòÖÐSQLÓï¾äµÄÕýÈ ......