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

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 Data blocks £¬Extents£¬Segment

£¨Ò»£©Data blocks £¬Extents£¬Segment
    Õâ¾ÍÊÇËûÃÇÖ®¼äµÄÂß¼­½á¹¹¡£
    ÏÈ¿´Data blocks£¨Ò²½ÐÂß¼­¿é£¬oracle¿é£¬Ò³£©°É£¬oracle´æ´¢Êý¾Ý¶¼ÊÇÔÚÕâЩÊý¾Ý¿éÖУ¬Ò»¸öÊý¾Ý¿éÊÇ´ÅÅÌÉÏÊý¾Ý¿âÎïÀí¿Õ¼äһϵÁÐÎïÀí×Ö½ÚµÄ×é³É¡£
    ±ÈData blocks¸ü¸ßÒ»²ãµÄÂß¼­Êý¾Ý¿é¿Õ¼äÊÇe ......

ARCSDE for Oracle Êý¾Ý´æ´¢ÐÎʽΪst_geometry

SELECT sde.st_area(zone) from sde.test1 ORDER BY name;//
SELECT shape from schools ORDER BY name;
SELECT objectid, sde.st_astext(SDE.ST_POINTfromSHAPE(shape,0)) AS points from schools;
SELECT name, sde.st_x (zone) "The X coordinate" from test ; //ÕýÈ·Ö´ÐÐ
SELECT name, sde.st_x (shape)  "The ......

oracle dbtimezoneÐÞ¸Ä

select dbtimezone from dual ;  --²é¿´Êý¾Ý¿âÊ±Çø
select sessiontimezone from dual ;  --²é¿´»á»°Ê±Çø
1.select u.name || '.' || o.name || '.' || c.name TSLTZcolumn
       from sys.obj$ o, sys.col$ c, sys.user$ u
      &nbs ......

oracleºÍsqlserver²éѯʱ×èÈûÇé¿ö

1.oracle»·¾³
create table test
(
id number(4),
name varchar2(20)
)
ÔÚÒ»¸ösessionÖÐ
insert into test values(1,'aa');
ÔÚÁíÒ»¸ösessionÖÐ
select * from test1;
²éѯû±»×èÈû
2.sqlserver»·¾³
ÔÚÒ»¸ösessionÖÐ
insert into test values(1,'aa');
ÔÚÁíÒ»¸ösessionÖÐ
select * from test1;
²éѯ±»×èÈû(Ê ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ