In our situation we only need a unique ID for the sake of the FID requirement by Map. To generate such a unique ID we chose the following approach:
- the view is wrapped by a select statement which includes rownum:
create or replace view my_view as select
rownum fid, t.* from
(
... view definition ...
) t;
As we need to show the data of the view only occasionally performance is not a major concern here.
Map 2013, SP2
No comments:
Post a Comment