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 X coordinate" from dijishi; //报错
//对于不是SQL语句生成的表格,比如shp文件import进来的,上面语句报错。SQL语句建立的表格空间字段为geometry,
而导入进去的表格shape字段也显示为geometry,但是同样的语句报错。
问题已解决,0表示用的spatial参数,spatial表名为st_spatial_references
SELECT id, st_astext (shape) AS geometry from schools;
CREATE TABLE Test(OBJECTID integer, name varchar(128), type varchar(10), zone sde.st_geometry);
CREATE TABLE Test1(OBJECTID integer, name varchar(128), type varchar(10), zone sde.st_geometry);
select * from sys.all_indexes t where t.owner='sde' AND T.INDEX_TYPE='DOMAIN';
select owner,index_name from sys.all_indexes where owner='sde';
select owner,index_name from all_indexes where domidx_status != 'VALID' or domidx_opstatus !='VALID';
drop index from sys.all_indexes where domidx_status != 'VALID' or domidx_opstatus !='VALID';
grant CREATE TYPE to SDE;
grant UNLIMITED TABLESPACE to SDE;
grant CREATE LIBRARY to SDE;
grant CREATE OPERATOR to SDE;
grant CREATE INDEXTYPE to SDE;
grant CREATE PUBLIC SYNONYM to SDE;
grant DROP PUBLIC SYNONYM to SDE;
sdelayer -o register -l Test,zone -e p -C area_id,SDE -u sde -p petrol -t ST_GEOMETRY
-u 为用户 -p为密码
sdelayer -o register -l SIP_LAND,SHAPE -e ac+ -P BASIC -C FID,sde -u eplan -
p 123 -i esri_sde
INSERT INTO sde.Test1(name,area_id,type,zone) VALUES ('第3小学',3, 'school', sde.ST_PolyfromText('polygon ((76.8213 31.4152,76.8213 41.4027,126.8325 41.4017,126.8337 31.4162,76.8213 31.4152))',2));
INSERT INTO sde.Test1(OBJECTID, name,area_id,type,zone) VALUES (9, '第9区域',9, 'school9', sde.ST_PolyfromText('polygon ((16.8213 31.4152,16.8213 4
相关文档:
oracle 数据类型详解---日期型
oracle数据类型看起来非常简单,但用起来会发现有许多知识点,本文是我对ORACLE日期数据类型的一些整理,都是开发入门资料,与大家分享:
注:由于INTERVAL及TIME ZONE实际用得比较少,所以本文内容未涉及这两个方面。
1、常用日期型数据类型
1.1、DATE
......
CREATE OR REPLACE FUNCTION F_HPS_SPLIT
/*
* 功 能: split.
* 输入参数: Liststr string
* 输入参数: Sepe index
* 输入参数: Sepe separator. default is ','.
* return sepeCount
*/
(
......
第一种:
select b.* from
( select a.*, rownum row_num from
(select t.* from A05_ORGANIZATION t order by org_name_en asc) a
) b
where b.row_num between 1 and 5 order by b.row_num asc
第二种(更高效):
select b.* from
( select a.*, rown ......
如下,表a是数据库中已经存在的表,b是准备根据表a进行复制创建的表:
1、只复制表结构的sql
create table b as select * from a where 1<>1
2、即复制表结构又复制表中数据的sql
create table b as select * from a
3、复制表的制定字段的sql
create table b as select row_id ......
第一章:日志管理
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 ......