oracle ¶à±íɾ³ý ͬʱɾ³ý¶à±íÖйØÁªÊý¾Ý
oracle ¶à±íɾ³ý ͬʱɾ³ý¶à±íÖйØÁªÊý¾Ý
2009-04-27 14:40
1¡¢´ÓÊý¾Ý±ít1ÖаÑÄÇЩidÖµÔÚÊý¾Ý±ít2ÀïÓÐÆ¥ÅäµÄ¼Ç¼ȫɾ³ýµô
DELETE t1 from t1,t2 WHERE t1.id=t2.id »òDELETE from t1 USING t1,t2 WHERE t1.id=t2.id
2¡¢´ÓÊý¾Ý±ít1ÀïÔÚÊý¾Ý±ít2ÀïûÓÐÆ¥ÅäµÄ¼Ç¼²éÕÒ³öÀ´²¢É¾³ýµô
DELETE t1 from t1 LEFT JOIN T2 ON t1.id=t2.id WHERE t2.id IS NULL »ò
DELETE from t1,USING t1 LEFT JOIN T2 ON t1.id=t2.id WHERE t2.id IS NULL
3¡¢´ÓÁ½¸ö±íÖÐÕÒ³öÏàͬ¼Ç¼µÄÊý¾Ý²¢°ÑÁ½¸ö±íÖеÄÊý¾Ý¶¼É¾³ýµô
DELETE t1,t2 from t1 LEFT JOIN t2 ON t1.id=t2.id WHERE t1.id=25
×¢Òâ´Ë´¦µÄdelete t1,t2 from ÖеÄt1,t2²»ÄÜÊDZðÃû
È磺delete t1,t2 from table_name as t1 left join table2_name as t2 on t1.id=t2.id where table_name.id=25 ÔÚÊý¾ÝÀïÃæÖ´ÐÐÊÇ´íÎóµÄ£¨MYSQL °æ±¾²»Ð¡ÓÚ5.0ÔÚ5.0ÖÐÊÇ¿ÉÒԵģ©
ÉÏÊöÓï¾ä¸Äд³É
delete table_name,table2_name from table_name as t1 left join table2_name as t2 on t1.id=t2.id where table_name.id=25 ÔÚÊý¾ÝÀïÃæÖ´ÐÐÊÇ´íÎóµÄ£¨MYSQL °æ±¾Ð¡ÓÚ5.0ÔÚ5.0ÖÐÊÇ¿ÉÒԵģ©
¶à±íÁ¬½Ó²éѯºÜÏàËÆ,²»Ïê¼Ó˵Ã÷ÁË
Ïà¹ØÎĵµ£º
ÓÉÓÚ¹«Ë¾ÒµÎñÔö³¤½Ï¿ì£¬Êý¾Ý¿âoracleѹÁ¦Ô½À´Ô½´ó£¬¹«Ë¾¿¼ÂÇÔÚÓ¦Ó÷þÎñÆ÷ Websphere ºÍ Êý¾Ý¿âoracleÖ®¼äÔö¼Ó timestenÊý¾Ý¿âÀ´ÊµÏÖÊý¾ÝµÄ¶Áд·ÖÀ룬ÁíÍâÓÉÓÚtimestenÊÇÄÚ´æÊý¾Ý¿â£¬ËùÒÔ²éѯËÙ¶ÈÉÏÒªÓÅÓÚ oracle Êý¾Ý¿â£¬Á½¸öÊý¾Ý¿âËäÈ»¶¼ÊÇoracle¹«Ë¾µÄ²úÆ·£¬µ«ÊÇÔںܶàsqlµÄд·¨ÉÏÊDz»ÏàͬµÄ£¬Ï ......
Oracle£ºÒ»¸öÊý¾Ý¿âÓжà¸öÓû§,Ò»¸öÓû§ÓµÓÐÒ»×éÊý¾Ý¿â¶ÔÏó,Õâ¸öÓû§ÎÒÃÇË׳ÆÎª·½°¸,
ͨ³£Ò»¸öÒµÎñϵͳ¶ÔÓ¦Ò»¸öÊý¾Ý¿âÓû§¡£
¡ïOracle°²×°³É¹¦ºó»á×Ô¶¯´´½¨Ê®À´¸öϵͳ½ç±ðµÄÕË»§¡£Ä¬ÈÏÇé¿öÏÂÕâЩÕË»§ÖÐÖ»ÓÐËĸö¿ÉÓã¬ÆäËüµÄÕʺŶ¼±»ÉèÖóÉÁËËø¶¨»òÊÇÉèÖÃΪ¹ý ÆÚ״̬£¬ÕâËĸöÕÊ»§¾Í ......
µÚÒ»Õ£ºÈÕÖ¾¹ÜÀí
1.forcing log switches
sql> alter system switch logfile;
2.forcing checkpoints
sql> alter system checkpoint;
3.adding online redo log groups
sql> alter database add logfile [group 4]
sql> ('/disk3/log4a.rdo','/disk4/lo ......
---sqlµÄº¯ÊýµÄʹÓÃ(Oracle)
---dualµÄʹÓãºÑÆÔª±í£ºÃ»ÓбíÐèÒª²éѯµÄʱºò ¿ÉÒÔÓÃËü
---select 'Hello World' from dual; ---½á¹û£ºH ......
Èç¹û²éѯÕû¿âµÄ»°µÃÒÔDBAȨÏÞ²éѯÊý¾Ý×Öµädba_tab_columns
·ÇDBAÓû§Ö»Äܲ鿴×Ô¼ºÓжÁȡȨÏ޵ıí
¿ÉÒÔÕâÑùд²éѯ
select owner, table_name
from dba_tab_columns
where lower(column_name)='firstname';
²éѯ³öÄÄЩ±í°üº¬firstname×Ö¶ÎÒÔ¼°ÕâЩ±íÊôÓÚÄĸöÓû§
×¢£ºdba_tab_columnsÊÇÒ»¸öÊôÓÚSYSÓû§µÄÒ»¸öView ......