ÅäÖöà¸öSDE·þÎñ(oracle)
ÅäÖöà¸öSDE·þÎñ(oracle) ÏîĿҪ׼±¸Á½·ÝÏàͬ½á¹¹µÄÊý¾Ý¸ø²»Í¬µÄÓû§£¬ÓÉÓÚÊý¾ÝÁ¿ºÜ´ó£¬²»¶ÏµÄ±¸·Ý»¹ÔЧÂÊÊ®·ÖµÍÏ£¬Òò´Ë¿¼ÂÇн¨Ò»¸öÊý¾Ý¿â£¬½¨Á¢Á½¸öSDE·þÎñ¡£
1.н¨Êý¾Ý¿âDXGX_GX(ÔÊý¾Ý¿â£ºDXGX)
2.ÔËÐÐSDE POST д´½¨Ò»¸ö·þÎñ£¨ÔÚ´´½¨Ö®Ç°ÐèÒªÏȹرÕÒÑÔÚÔËÐÐÖеÄSDE·þÎñ£©
3.ÔÚArcCatalogÀィÁ¢ÐµÄSDEÁ¬½ÓDXGXGX£¨ÒÔÇ°µÄ½ÐDXGX£©¡£
ÎÊÌâ³öÏÖÁË£¬Á½¸öSDE·þÎñDXGXGXºÍDXGXµÄÄÚÈÝÍêÈ«Ò»Ñù£¬¶¼ÊÇÁ¬½Ó±íDXGX_GXµÄ±í¿Õ¼äSDE¡£
½â¾ö°ì·¨£º
1.ÕÒµ½SDEHOMEĿ¼(¿ÉÒÔÔڲ˵¥-ÔËÐÐÀïÊäÈ룺%SDEHOME%)
2.¸´ÖÆÎļþ¼ÐϵÄËùÓеÄÎļþµ½ÐµÄĿ¼£¬ÈçC:\ArcGIS\ArcSDE\ora9iexe2.
3.´ò¿ªÔĿ¼ÖеÄ%SDEHOME%\etc\dbinit.sdeÎļþ£¬ÐÞ¸Ä set ORACLE_SID=DXGXGX Ϊ set ORACLE_SID=DXGX ±£´æ
4.´ò¿ª×¢²á±í£ºHKEY_LOCAL_MACHINE\SOFTWARE\ESRI\ArcInfo\ArcSDE\ArcSDE for Oracle ´ò¿ªÐ½¨µÄSDE·þÎñ£¬Èçesri_gxsde,ÐÞ¸Ä×Ó¼üSDEHOMEΪ²½Öè2ÖÐи´ÖƵÄĿ¼¡£
5.ÖØÆôÁ½¸öSDE·þÎñ¼´¿É£¡
ÔÒò£ºdbinit.sdeÎļþ¼Ç¼ÁËÊý¾Ý¿âµÄSID£¬Ð½¨SDE·þÎñʱ£¬°ÑÔÀ´SDE·þÎñËùÖ¸ÏòµÄÊý¾Ý¿âSIDÒ²¸ü¸ÄÁË£¡
±¾ÎÄÀ´×ÔCSDN²©¿Í£¬×ªÔØÇë±êÃ÷³ö´¦£ºhttp://blog.csdn.net/gisfarmer/archive/2009/04/24/4103712.aspx
Ïà¹ØÎĵµ£º
¿ª´°º¯ÊýµÄµÄÀí½â£º
¿ª´°º¯ÊýÖ¸¶¨ÁË·ÖÎöº¯Êý¹¤×÷µÄÊý¾Ý´°¿Ú´óС£¬Õâ¸öÊý¾Ý´°¿Ú´óС¿ÉÄÜ»áËæ×ÅÐеı仯¶ø±ä»¯£¬¾ÙÀýÈçÏ£º
over£¨order by salary£© °´ÕÕsalaryÅÅÐò½øÐÐÀۼƣ¬order byÊǸöĬÈϵĿª´°º¯Êý
over£¨partition by deptno£©°´ÕÕ²¿ÃÅ·ÖÇø
ove ......
¸üжàÐеIJ½Ö裺
²½Öè¶à£¬µ«Ð§ÂʱȽϸߣº
1¡¢create table ÁÙʱ±í value (select a.id,a.name,b.name,... from table1 a,table2 b where a.id=b.id)
2¡¢É¾³ýtable1ÖеļǼ£¬²»Òªdrop
3¡¢insert into table1 select ÄãÐèÒªµÄ×ֶΠfrom ÁÙʱ±í¡£
select * from tb_ai03
create table tb_ai031 as select * from tb ......
1¡¢´´½¨´æ´¢¹ý³Ì
create or replace procedure test(var_name_1 in type,var_name_2 out type) as
--ÉùÃ÷±äÁ¿(±äÁ¿Ãû ±äÁ¿ÀàÐÍ)
begin
--´æ´¢¹ý³ÌµÄÖ´ÐÐÌå
end test;
´òÓ¡³öÊäÈëµÄʱ¼äÐÅÏ¢
E.g:
create or replace procedure test(workDate in Date) is
begin
dbms_output.putline('The input date is: ......
Êý¾ÝÀàÐÍ
²ÎÊý
ÃèÊö
char(n)
n=1 to 2000×Ö½Ú
¶¨³¤×Ö·û´®£¬n×Ö½Ú³¤£¬Èç¹û²»Ö¸¶¨³¤¶È£¬È±Ê¡Îª1¸ö×Ö½Ú³¤£¨Ò»¸öºº×ÖΪ2×Ö½Ú£©
varchar2(n)
n=1 to 4000×Ö½Ú
¿É±ä³¤µÄ×Ö·û´®£¬¾ßÌ嶨ÒåʱָÃ÷×î´ó³¤¶Èn£¬
ÕâÖÖÊý¾ÝÀàÐÍ¿ÉÒÔ·ÅÊý×Ö¡¢×ÖĸÒÔ¼°ASCIIÂë×Ö·û¼¯(»òÕßEBCDICµÈÊý¾Ý¿âϵͳ½ÓÊܵÄ×Ö·û¼¯±ê×¼)ÖеÄËùÓзûºÅ¡£
Èç¹ ......
²éѯijÁÐֵΪnullµÄ¼Ç¼£º
select *
from tablename
where col is null;
²éѯijÁÐÖµ²»ÎªnullµÄ¼Ç¼£º
select *
from tablename
where col is not null;
Õë¶ÔnullµÄ+-*/=!=µÈ²Ù×÷¶¼ÊÇnull£º
null±íʾ²»È·¶¨µÄÖµ£¬Á½¸önull±íʾÁ½¸ö²»È·¶¨µÄÖµ¡¢Î´ÖªµÄÖµ£¬Òò´Ë²»´æÔÚÁ½¸önullµÄÏàµÈ£¬Í ......