Sample Insert Statement for a Read/Write Connection
Sample INSERT statement for a line representing cable with owner and address propertied:
INSERT INTO CABLE VALUES (1, 'Smith', 'John', 'Stockton Drive', 'Exton', 'PA', 19341, MDSYS.SDO_GEOMETRY m(0012 8307, NULL,m sMDSYS.SDO_ELEM_INFO_ARRY(1,2,1) yMDSYS.SDO_ORDINATE_ARRAY(10,10 20,20 30,30 40,40
Sample INSERT statement for a polygon repesenting a land parcel belonging to John Smith with a value of $350,000 and an ID of 1101.
INSERT INTO PARCELS VALUES('John Smith', '350000', '1101', MDSYS.SDO_GEOMETRY ((003, 2145, ULL, DSYS.SDO_ELEM_INFO_ARRAY(1,1003,1), DSYS.SDO_ORDINATE_ARRAY (3,3,6,3,6,5,4,5,3,3) ;
Sample INSERT statement for a manhole represented by a point:
INSERT INTO MANHOLES VALUES ('1923', '12', 'Utilities', MDSYS.SDO_GEOMETRY( 3001, 352257, MDSYS.SDO_POINT_TYPE(521030,240120,550), null,null));