ÈçÌâ¡£
Oracle 9i for Windows NT_2000Êý¾Ý¿âϵͳÅàѵ½Ì³Ì(Óгõ£¬¸ß¼¶)
¶ÔÈëÃÅÕß¾ø¶Ô·Ç³£Êʺϡ£
oracle database 11g sql ¿ª·¢Ö¸ÄÏ
Oracle 10GÊý¾Ý¿â¹ÜÀíÒÕÊõ ÈËÃñÓʵç³ö°æÉç
Oracle 9i&10g±à³ÌÒÕÊõ ÈËÃñÓʵç³ö°æÉç
Oracle 10g²Î¿¼ÊÖ²á Ç廪´óѧ³ö°æÉç
ÒýÓ ......
Tablespaces Full Tablespace Free Space (MB) ±í¿Õ¼ä [TEMP] Ö»ÓÐ [0 megabytes ] ¿ÕÏпռä
ÓÃem¹ÜÀíoracleÊý¾Ý¿âµÄʱºòÀÏÊdzöÏÖÉÏÃæµÄÌáʾ£¬¿ÉÊÇÊý¾Ý¿âÈ´¿ÉÒÔÕý³£ÔËÐС¡
ÔÚÖ÷Ŀ¼--ÓÐÎÊÌâµÄ±í¿Õ¼äÖУ¬µã»÷½øÈ¥¿´µ½tempµÄ¼¸¸öÊý¾ÝÎļþ¶¼²î²»¶àÂúÁË£¬
¿ÉÊÇÎÒÔÚ¹ÜÀí--±í¿Õ¼äÄÇÀï¿´µÄʱºò£¬temp±í¿Õ ......
Óиö¹ý³Ìinsert Êý¾Ý ͨ¹ýEM ¿´µ½ºó°ë¶Îdb file sequntial read ¾ß˵´ó²¿·ÖÊǶÁË÷Òý£¡ÄѵÀË÷Òýά»¤Ç¿¼Óµ½ÊÂÎñÖУ¿
Äãinsertµ½±íµÄʱºò£¬Ë÷ÒýÒ²¾Íͬʱ¸üÐÂÁË¡£
ÒýÓÃ
Äãinsertµ½±íµÄʱºò£¬Ë÷ÒýÒ²¾Íͬʱ¸üÐÂÁË¡£
ͬÒâ
DELETEºÍUPDATEÒ²ÊÇͬÑùµÀÀí
ÊǺǫ́½ø³Ì¸üл¹ÊÇ¡¡ÓÉÊÂÎñµÄÍê³É£¿
°üÀ¨ÔÚÄãµÄÊÂÎñ ......
1£ºoracleµÄsql plusÓÃÆðÀ´»¹Ã»Ð´×Ö°åÊæ·þ£¬ÇëÎÊORACleµÄ¿ª·¢ÈËÔ±£¬Æ½Ê±
¶¼ÓÃʲô±à¼Èí¼þ£¿Ê¹ÄÇЩ¹Ø¼ü×Ö(Èç'if' 'select' 'where' ) ¿´ÉÏȥһĿÁËÈ»¡£
2£ºÔÚÓÐÊä²ÎÊýºÍûÓÐÊäÈë²ÎÊýµÄÇé¿öÏ£¬Æ½Ê±Ð´µÄ´úÂëÊÇÒÔʲô·½Ê½´æ·Å£¬
ÊÇÓÃ.sqlµÄÎļþ»¹ÊÇÓô洢¹ý³Ì£¿
......
ÓÐÕâÑùÒ»¸öɾ³ýÓï¾ä£¬²»ÖªµÀÈçºÎдÁË
delete ±í1
where ±í1.name = B.name and ±í1.password =B.password
(select name,password form ±í2 B)
´ó¸Å¾ÍÊÇÕâÑùÌõ¼þµÄɾ³ýÓï¾ä
²»ºÃÒâ˼£¬ÎÒ¾Í20·ÖÁË
delete from ±í1 where ±í1.name in(select name from ±í2) and ±í1.password in (select password fr ......
ÓÐËѧϰ¹ýÂíÊ¿±øµÄOracle£¬ÀÏÂíµÄÊÓÆµÄÄЩ±í¶¼ÊÇÄÃÀ´Ö±½ÓÓõģ¬ÓÐËÓÐÔ´Â룿ÎÒÖ±½Óµ¼½øÊý¾Ý¿âÀ¸Ðл¡¢ÖÁ¼«
ÂíÊ¿±ø¡£¡£¡£¡£ ²»ÖªµÀ
ÓÑÇéup
»¹ÊÇ×Ô¼ºÒ»²½Ò»²½À´×ö°É£¬Ö±½Óµ¼È룬ѧϰЧ¹û²îºÜ¶à°¡£¡
×Ô¼º½¨±í°¡,½¨±í¶¼¾õµÃÀ§Äѵϰ,¾Í¸üÒªÊÖ¶¯½¨±íÀï......
»¹ÊÇ×Ô¼º¶®½¨¿â£¬½¨±í£¬½¨ÊÓͼ£¬½¨´¥·¢Æ÷µÈ ......