mu419683690的专栏

空间数据首先应该在数据库中注册表中注册一个TableID（注册表为sde.table_registry，sde表空间下的表sde.table_registry），得到REGISTRATION_ID,然后在注册表的表空间下有A表和D表，添加的记录就在A表中，而删除的记录就在D表中，而在数据重新读取时，会先读取注册表，然后从A表和D表中分别读取相关的，添加删除记录-----------在s

Sdeservice -o create -d ORACLE,kfdlwy -p sde -i esri_sde -nSdeservice -o delete -d ORACLE,kfdlwy -p sde -i esri_sde -n

--查看表空间被占用情况SELECT se.USERNAME,sid,serial#,sql_address,machine,program,tablespace,segtype,contents FROM v$session se,v$sort_usage suWHERE se.saddr=su.session_addr --查看表空间

--插入记录insert into LQGG_ATTRIBUTE select * from LQGG_ATTRIBUTE_ALL t where t.xian=433122 and t.xiang=207 and t.isnew=9999/*--批量删表Begin  for t in (select table_name from dba_tables where owner

create tablespace  hbly    logging datafile 'D:\oradata\kfdlwy\hbly.ora'   size 200m autoextend on next 200m maxsize 20480m extent management local;create user hbly  identified by hbly  default

更改部分字符UPDATE fl_sys_bbzjbcc t SET  t.c_zjbmc = replace(t.c_zjbmc,'HNLYDATA','HNLY_LXT');UPDATE fl_sys_bbzjbcc t SET  t.c_sjybmc = replace(t.c_sjybmc,'HNLYDATA','HNLY_LXT');分组后内部排序select *

access：select t.OBJECTID ,t.OBJECTID + s.DIFF as 排序,t.ORIG_FID from DLTB_37_F_To_P t,(select ORIG_FID ,count(*) - max(OBJECTID) as DIFF  from DLTB_37_F_To_P  group byORIG_FID ) as s where t.ORIG

Access：Cstr()：数字转文本Cint()：文本转数字Oracle:to_char()：数字转文本to_number()：文本转数字

VBA函数：Public Function Combstr(tablename As String, fieldname As String, groupfield As String, groupvalue As String) As StringDim resultstr As StringDim rs As RecordsetDim sql As Stringsql =