I'm using arc gis 10.2.1. I create a point feature using SQL and ST_Geometry as shown below. I need to know the objectid for this new feature. Is it best to find the max(objectid) on the view after the row is inserted?
-- create a new point feature
insert into test_pt_evw (name,shape) values ('one', sde.ST_PointFromText('point (0.0125662 0.0046711)', 2))
--get the objectid for the new feature
select max(objectid) from test_pt_evw