??Oracle?????????ArcSDE????
???????????? ???????[ 2012/10/15 10:14:53 ] ????????
???????????е?????????????ArcSDE??????????????????????????????????Oracle????????????????ArcSDE for Oracle????????????????oracle???????ū??????????ArcSDE????????????÷??????????
??????????????У????????????????????????????????????????????????????????????????????????????????????????????á?
??????????????????е????????ī???????????????????????????????????????????????????飬?????????????????????????????????????????????????????????????ò??????????????????ü??????????????????????????Ч??????
???????е?????????????????????????Oracle??????????????????????????????????Oracle??????μ?????洢???????????????????rowid???????????????????????????????????????Oracle????????????????????rowid????????ü????
select * from people where name = 'David';
??????Oracle????ò??????????????????衣??????????6?????????????????????????????????????ü??????????????????????????????????Oracle????????????????????????????????????????????????????????Oracle???????????????
??????????????????people??name?????????????????????????????????????????????????????????????
create index idx_people_name on people(name)
???????????????????????????????????????????????з?鴦??????磬???5???????????????饗????????????齫??????????????????????????
????????????е?Oracle???????????????δ????????????????????????????????????з??????????????????????????????????ArcSDE for Oracle????????????????????????????????????????????????????????????????ArcGIS???????????Χ????÷?Χ?????????????
?????????????????select * from people where name = ‘David’;???Oracle???????????????н??????????????????????????????????M?????????????????David????????????????name?е??????David??Oracle????????????????????????????????????????????е?????е?“David”λ?????????????????????“David”??Oracle??????????????rowid????????rowid?????λ?ü????
????????????SQL??????????????????????????
select * from people where name = 'Michael';
???????????????????name?е???“Michael”????????????????????????????????????????????????????????M????????????????????Michael???????????“Richard”????????????????????????
?????????ArcSDE??????oracle?н??в??????????????裺
????1????????grid??????Χ???????????Χ???????grid??
????2?????????Щgrid???????????
????3??????Щ???????????κ?????Χ?????????????????Χ???????????Χ????????
?????????????????
????????????????????????????????????????????????????????????????????????????????????????dba_objects????????????????ж??????????
createtable test_objects as select * from dba_objects;
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11