oracle自定义的记录类型,oracle 自定义类型数据插入

insert

into SDE_dlxd

(OBJECTID,

IDREF,

DOMAIN,

NAME,

CODE,

SHAPE.ENTITY,

SHAPE.NUMPTS,

SHAPE.MINX,

SHAPE.MINY,

SHAPE.MAXX,

SHAPE.MAXY,

SHAPE.MINZ,

SHAPE.MAXZ,

SHAPE.MINM,

SHAPE.MAXM,

SHAPE.AREA,

SHAPE.LEN,

SHAPE.SRID,

SHAPE.POINTS)

select

k.OBJECTID,

k.IDREF,

k.DOMAIN,

k.NAME,

k.CODE,

k.SHAPE.ENTITY,

k.SHAPE.NUMPTS,

k.SHAPE.MINX,

k.SHAPE.MINY,

k.SHAPE.MAXX,

k.SHAPE.MAXY,

k.SHAPE.MINZ,

k.SHAPE.MAXZ,

k.SHAPE.MINM,

k.SHAPE.MAXM,

k.SHAPE.AREA,

k.SHAPE.LEN,

k.SHAPE.SRID,

k.SHAPE.POINTS

from linyi_电缆接头bk

k

ORA-00904: "SHAPE"."POINTS":

标识符无效

create table SDE_dlxd

(

OBJECTID INTEGER

not null,

IDREF NUMBER(18) not

null,

DOMAIN NVARCHAR2(255),

NAME

NVARCHAR2(255),

CODE NVARCHAR2(255),

SHAPE SDE.ST_GEOMETRY

);

CREATE OR REPLACE TYPE

SDE.ST_GEOMETRY AUTHID CURRENT_USER AS

OBJECT

--C_Type_Release

1007

(

ENTITY INTEGER,

NUMPTS INTEGER,

MINX FLOAT(64),

MINY FLOAT(64),

MAXX FLOAT(64),

MAXY FLOAT(64),

MINZ FLOAT(64),

MAXZ FLOAT(64),

MINM FLOAT(64),

MAXM FLOAT(64),

AREA FLOAT(64),

LEN FLOAT(64),

SRID INTEGER,

POINTS BLOB,

CONSTRUCTOR FUNCTION ST_GEOMETRY

(

GEOM_STR CLOB,

SRID NUMBER

) RETURN

SELF AS RESULT

DETERMINISTIC,

MEMBER FUNCTION

ST_AREA RETURN

NUMBER,

MEMBER FUNCTION

ST_LEN RETURN

NUMBER,

MEMBER FUNCTION

ST_LENGTH RETURN

NUMBER,

MEMBER FUNCTION

ST_ENTITY RETURN

NUMBER,

MEMBER FUNCTION

ST_NUMPTS RETURN

NUMBER,

MEMBER FUNCTION

ST_MINX RETURN

NUMBER,

MEMBER FUNCTION

ST_MAXX RETURN

NUMBER,

MEMBER FUNCTION

ST_MINY RETURN

NUMBER,

MEMBER FUNCTION

ST_MAXY RETURN

NUMBER,

MEMBER FUNCTION

ST_MINM RETURN

NUMBER,

MEMBER FUNCTION

ST_MAXM RETURN

NUMBER,

MEMBER FUNCTION

ST_MINZ RETURN

NUMBER,

MEMBER FUNCTION

ST_MAXZ RETURN

NUMBER,

MEMBER FUNCTION

ST_SRID RETURN

NUMBER,

STATIC FUNCTION GET_RELEASE RETURN NUMBER

)

NOT

FINAL;

INSERT INTO SDE_dlxd

SELECT

K.OBJECTID,

K.IDREF,

K.DOMAIN,

K.NAME,

K.CODE,

SDE.ST_GEOMETRY(K.SHAPE.ENTITY,

K.SHAPE.NUMPTS,

K.SHAPE.MINX,

K.SHAPE.MINY,

K.SHAPE.MAXX,

K.SHAPE.MAXY,

K.SHAPE.MINZ,

K.SHAPE.MAXZ,

K.SHAPE.MINM,

K.SHAPE.MAXM,

K.SHAPE.AREA,

K.SHAPE.LEN,

K.SHAPE.SRID,

K.SHAPE.POINTS)

FROM

LINYI_dlxdBK K

insert into SDE_dlxd

(OBJECTID,

IDREF,

DOMAIN,

NAME,

CODE,

SHAPE.ENTITY,

SHAPE.NUMPTS,

SHAPE.MINX,

SHAPE.MINY,

SHAPE.MAXX,

SHAPE.MAXY,

SHAPE.MINZ,

SHAPE.MAXZ,

SHAPE.MINM,

SHAPE.MAXM,

SHAPE.AREA,

SHAPE.LEN,

SHAPE.SRID,

SHAPE.POINTS)

select k.OBJECTID,

k.IDREF,

k.DOMAIN,

k.NAME,

k.CODE,

k.SHAPE.ENTITY,

k.SHAPE.NUMPTS,

k.SHAPE.MINX,

k.SHAPE.MINY,

k.SHAPE.MAXX,

k.SHAPE.MAXY,

k.SHAPE.MINZ,

k.SHAPE.MAXZ,

k.SHAPE.MINM,

k.SHAPE.MAXM,

k.SHAPE.AREA,

k.SHAPE.LEN,

k.SHAPE.SRID,

k.SHAPE.POINTS

from linyi_电缆接头bk k

ORA-00904: "SHAPE"."POINTS": 标识符无效

create table SDE_dlxd

(

OBJECTID INTEGER not null,

IDREF NUMBER(18) not null,

DOMAIN NVARCHAR2(255),

NAME NVARCHAR2(255),

CODE NVARCHAR2(255),

SHAPE SDE.ST_GEOMETRY

);

CREATE OR REPLACE TYPE SDE.ST_GEOMETRY AUTHID CURRENT_USER AS OBJECT

--C_Type_Release 1007

(

ENTITY INTEGER,

NUMPTS INTEGER,

MINX FLOAT(64),

MINY FLOAT(64),

MAXX FLOAT(64),

MAXY FLOAT(64),

MINZ FLOAT(64),

MAXZ FLOAT(64),

MINM FLOAT(64),

MAXM FLOAT(64),

AREA FLOAT(64),

LEN FLOAT(64),

SRID INTEGER,

POINTS BLOB,

CONSTRUCTOR FUNCTION ST_GEOMETRY

(

GEOM_STR CLOB,

SRID NUMBER

) RETURN SELF AS RESULT DETERMINISTIC,

MEMBER FUNCTION ST_AREA RETURN NUMBER,

MEMBER FUNCTION ST_LEN RETURN NUMBER,

MEMBER FUNCTION ST_LENGTH RETURN NUMBER,

MEMBER FUNCTION ST_ENTITY RETURN NUMBER,

MEMBER FUNCTION ST_NUMPTS RETURN NUMBER,

MEMBER FUNCTION ST_MINX RETURN NUMBER,

MEMBER FUNCTION ST_MAXX RETURN NUMBER,

MEMBER FUNCTION ST_MINY RETURN NUMBER,

MEMBER FUNCTION ST_MAXY RETURN NUMBER,

MEMBER FUNCTION ST_MINM RETURN NUMBER,

MEMBER FUNCTION ST_MAXM RETURN NUMBER,

MEMBER FUNCTION ST_MINZ RETURN NUMBER,

MEMBER FUNCTION ST_MAXZ RETURN NUMBER,

MEMBER FUNCTION ST_SRID RETURN NUMBER,

STATIC FUNCTION GET_RELEASE RETURN NUMBER

)

NOT FINAL;

INSERT INTO SDE_dlxd

SELECT K.OBJECTID,

K.IDREF,

K.DOMAIN,

K.NAME,

K.CODE,

SDE.ST_GEOMETRY(K.SHAPE.ENTITY,

K.SHAPE.NUMPTS,

K.SHAPE.MINX,

K.SHAPE.MINY,

K.SHAPE.MAXX,

K.SHAPE.MAXY,

K.SHAPE.MINZ,

K.SHAPE.MAXZ,

K.SHAPE.MINM,

K.SHAPE.MAXM,

K.SHAPE.AREA,

K.SHAPE.LEN,

K.SHAPE.SRID,

K.SHAPE.POINTS)

FROM LINYI_dlxdBK K