17,377
社区成员
发帖
与我相关
我的任务
分享
-- 直接写就可以了
SQL>
SQL> create table test(id int, location sdo_geometry);
Table created
SQL> declare
2 lon integer := 5;
3 lat integer := 1;
4 begin
5 insert into test(id, location)
6 values(6,
7 sdo_geometry(2001,
8 8307,
9 sdo_point_type(lon, lat, null),
10 null,
11 null));
12 end;
13 /
PL/SQL procedure successfully completed
SQL> col id format a10;
SQL> select * from test;
ID LOCATION
---------- --------
6 <Object>
SQL> drop table test;
Table dropped
SQL>