Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

oracle spatialÓëjdbcµÄÎÊÌâ

СŮĿǰcreateÁËÒ»¸ötable °üº¬sdo_geometryÀàÐ͵ÄÊôÐÔ¡£
±íºÍÊý¾Ý¶¼ÒѾ­²åºÃÁË~
¿ÉÊÇÈ´²»ÖªµÀÔõô¶Á³öÀ´ 
ÎÒÓÃ ResultSet rs = statement.executeQuery("select * from table");
Ϊʲô¾Í¶Á²»³öÀ´ÄØ£¿
±È½Ï½ô¼± ¿ÒÇë¸÷λ´óÏÀÖ¸½Ì ÏÈÔÚÕâÀïл¹ý´ó¼Ò^^
ÄãÊý¾Ý¿âÓÐÁ´½ÓÂð¡£
ResultSet rs Õâ¸öÖ»ÊÇ»ñµÃÕâÕűíµÄ½á¹û¼¯¡£
Äã¿ÉÒÔ Ò»¸öÑ­»· À´»ñÈ¡Õâ¸öÊý¾Ý¼¯ÖеÄÊý¾Ý£¬
¾ßÌåÔõô²Ù×÷£¬ÓеãÒÅÍüÁË£¬ºÃ¾ÃûÓÐÓÃjavaÁË£¬Äã×Ô¼º¿´Ò»Ï°ɡ£²é²é×ÊÁÏ¡£


¼ÇµÃÊÇRS.GET("×Ö¶Î")

Statement sta=con.createStatement();  
  ResultSet rs=sta.executeQuery(sql);  
  rs.next();  
  System.out.println(rs.getInt(1));  
  System.out.println(rs.getInt(2));  
  System.out.println(rs.getString(3));  
  System.out.println(rs.getString(4));  


лл´ó¼Ò~ ÆäʵÊÇÎÒÁ¬½ÓÓеãÎÊÌâ ÒѾ­½â¾öÁË


Ïà¹ØÎÊ´ð£º

oracle²¢·¢´¦ÀíSOS - Oracle / ¿ª·¢

ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾ­ºÜ³ÉÊìÁË

ÒýÓÃ
oracle ......

OracleµÄblob×Ö¶ÎÎÊÌâ - Oracle / ¿ª·¢

²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......

oracle °²×° 01092 ´íÎó - Oracle / »ù´¡ºÍ¹ÜÀí

oracle 11g °²×° 01092 ´íÎó,
ÈÕÖ¾ÐÅÏ¢£º
[oracle@linux trace]$ vi alert_orcl.log 
MMON started with pid=14, OS id=9089
RESETLOGS after incomplete recovery UNTIL CHANGE 522752
Errors in file / ......

sqlÓÅ»¯ - Oracle / »ù´¡ºÍ¹ÜÀí

select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' 
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ