Oracle SpatialÖÐSDO_GeometryÏêϸ˵Ã÷
ÔÚArcGISÖÐͨ¹ýSDE´æ´¢¿Õ¼äÊý¾Ýµ½OracleÖÐÓжàÖÖ´æ´¢·½Ê½£¬·Ö±ðÓУº¶þ½øÖÆLong Raw ¡¢ESRIµÄST_GeometryÒÔ¼°»ùÓÚOracle SpatialµÄSDO_GeometryµÈµÈ¡£
¹ØÓÚÕ⼸ÖÖ·½Ê½µÄ¸÷×ÔµÄÓÅȱµã²»ÊÇÖ÷ÒªµÄ̽Ìֵķ½Ïò£¬ÕâЩÎÒÃÇ¿ÉÒÔͨ¹ýArcGISÖеÄArcGIS Server HelpµÃµ½Ïà¹ØµÄ°ïÖú¡£ÕâÀïÖ÷ÒªÊÇѧϰ¹ØÓÚ»ùÓÚOracle SpatialµÄ´æ´¢·½Ê½£¬Í¨¹ýÕâÖÖ´æ´¢·½Ê½¼¸ºÎÁÐShapeµÄ×Ö¶ÎÀàÐÍΪmdsys.sde_geometryÀàÐÍ¡£
Oracle Spatial¶¨ÒåµÄSDO_GEOMETRYÀàÐÍΪ£º
CREATE TYPE sdo_geometry AS OBJECT (
SDO_GTYPE NUMBER, //Ç°Ãæ×Ö·û´®Îª×Ö¶ÎÃû£»ºóÃæ×Ö·û´®Îª×Ö¶ÎÀàÐÍ
SDO_SRID NUMBER,
SDO_POINT SDO_POINT_TYPE,
SDO_ELEM_INFO SDO_ELEM_INFO_ARRAY,
SDO_ORDINATES SDO_ORDINATE_ARRAY);
ÆäÖÐsdo_geometry AS OBJECT £¬±êʶ¸ÃÀàÐÍΪ¶ÔÏóÀàÐÍ¡£¿ªÊ¼ÎÒÃÇ¿ÉÒÔÏëÏëËüΪArcObjectsÖеÄGeometry¶ÔÏ󣨱¾À´ÒªËصÄshape×Ö¶ÎÖеĶÔÏó¾ÍÊÇGeometry£©£¬¶ø²»ÒªÀí½âËûÊÇÔõôÑù×éÖ¯µÄ¡£ÖÁÓÚ¸ÃÀàÐÍÖеÄSDO_POINT_TYPE¡¢SDO_ELEM_INFO_ARRAY¡¢SDO_ORDINATE_ARRAYÒ²ÊÇOracle Spatial×Ô¶¨ÒåµÄÀàÐÍºÍ sdo_geometry ÊÇÒ»ÑùµÄ¡£
ÏÖÔÚ¶Ôsdo_geometry ÀàÐÍÖеĸ÷¸ö²ÎÊý¼òµ¥µÄ½éÉÜ£º
1¡¢SDO_GTYPE £º±íʾҪ´æ´¢µÄ¼¸ºÎÀàÐÍ£¬ÈçµãÏßÃæ¡£ËüÊÇͨ¹ý NUMBERÀàÐÍÀ´±í´ïµÄ£»
&nb
Ïà¹ØÎĵµ£º
spool d:\deletetb.sql;
select 'delete ' || table_name || ' where to_char(col,'||'''yyyy'''||')='||'''2007'''||';'
from user_tables
where table_name in (select 'HS_' || lpad(rownum, '2', '0')
from dual
  ......
oracleÊÇÒ»ÖÖ´óÐ͵ġ¢¿ÉÒÆÖ²µÄ¶ÔÏó¹ØϵÐÍÊý¾Ý¿â¡£ËüÔÚÏà¹ØµÄÿһ¸öƽ̨É϶¼¿ÉÒÔÔËÐУ¬Òò´ËoracleµÄÌåϵ½á¹¹ÔÚ²»Í¬µÄ²Ù×÷ϵͳÉÏÊÇÓÐËù²»Í¬µÄ¡£±ÈÈçÔÚUNIXϵͳÉÏ£¬ÒòΪUNIXϵͳÊǹ¤×÷ÔÚ¶à½ø³ÌµÄ»ù´¡ÉÏ£¬ËùÒÔoracleÔËÐÐʱÌåÏÖΪ¶à¸ö½ø³ÌÔÚÔËÐС£È»¶øÔÚwindowsϵͳÉÏ£¬windowsÏµÍ³Ê ......
Êý¾ÝÎļþºÍÈÕÖ¾ÎļþÊÇÊý¾Ý¿âÖÐ×îÖØÒªµÄÎļþ¡£ËüÃÇÊÇÊý¾Ý´æ´¢µÄµØ·½¡£Ã¿¸öÊý¾Ý¿âÖÁÉÙÓÐÒ»¸öÓëÖ®Ïà¹ØµÄÊý¾ÝÎļþ£¬Í¨³£Çé¿öϲ»Ö»Ò»¸ö£¬ÓкܶࡣÊý¾ÝÔÚÊý¾ÝÎļþÖÐÊÇÈçºÎ×éÖ¯µÄ£¿ÒªÁ˽âÕâЩÄÚÈÝÎÒÃÇÊ×ÏȱØÐëÀí½âʲôÊDZí¿Õ¼ä£¨tablespace£©¡¢¶Î£¨segment£©¡¢Çø£¨extent£©¡¢¿é£¨block£©£¬ÕâЩ¶¼ÊÇoracl ......
ÔÚÒ»¸ö»ùÓÚTCP/IPÐÒéµÄÍøÂç»·¾³ÖУ¬oracleÊý¾Ý·þÎñÆ÷ÔÚһ̨¼ÆËã»úÉÏ£¬¿Í»§¶ËÔÚÁíÍâһ̨¼ÆËã»úÉÏ£¬¿Í»§¶ËÒªÁ¬½Óµ½oracle·þÎñÆ÷ÎÒÃǾ³£»áÊäÈ룺"C£º\sqlplus scott/tiger@shanghai"£¬ÕâÊÇoracle¿Í»§¶ËÁ¬½Ó·þÎñÆ÷ʱʹÓõÄÁ¬½ÓÃüÁÆäÖÐsqlplusÊÇoracle¿Í»§¶Ë³ÌÐò£¬scott/tigerÊǵǽ·þ ......
Ò»¡¢ Êý¾Ý¿â ORACLE
ËäÈ»ÕâЩÌâÄ¿¶¼¿ÉÒÔGµ½£¬µ«»¹ÊÇÒª¿¼²ìÒ»ÏÂÄúÏÖÔڵij£Ì¬Ë®Æ½£¬£º£©
T±í£º£¨×ֶΣºID£¬NAME£¬ADDRESS£¬PHONE£¬LOGDATE£©
E±í£º£¨×ֶΣºNAME£¬ADDRESS£¬PHONE£©
1£® ½«±íTÖеÄ×Ö¶ÎLOGDATEÖÐΪ2001-02-11µÄÊý¾Ý¸üÐÂΪ2003-01-01£¬Çëд³öÏàÓ¦µÄSQLÓï¾ä¡££¨¸Ã×Ö¶ÎÀàÐÍΪÈÕÆÚÀàÐÍ£©
2£® Çëд³ö½«±íTÖÐNAME ......