OracleµÄÇ°¶ËÔ¼ÊøÊÇʲôÒâ˼
ÊéÉÏ˵ Ô¼Êø Ò»¹²ÓÐÁ½ÖÖ ÆäÖÐÒ»ÖÖÇ°¶ËÔ¼ÊøÈçÏÂÃèÊö
ÓÐһЩ·½·¨¿ÉÒÔÓÃÓÚÖ´ÐÐÇ°¶Ë£¨¼´ÓÃÓÚÊäÈëÊý¾ÝµÄÊäÈëÐÎʽÖУ©Ô¼Êø£¨¸ÃÊý¾Ý¿â³ÆΪϵͳºó¶Ë£©
Ç°¶ËÔ¼Êø ÊÇʲôÒâ˼£¿
ÄÄλ´ó´óÂé·³ ½âÊÍÏ лл ¡£
Ç°¶ËÔ¼Êø:¿ÉÒÔÀí½â³É insert ±í֮ǰµÄÔ¼Êø
Â¥ÉϵĴó´ó˵µÄ Ô¼Êø ÊÇ·ÅÔÚcreate ½ÐÇ°¶ËÔ¼Êø £¬·ÅÔÚinsert µÄʱºòºó¶ËÔ¼Êø¡£
²»¹ýºóÀ´¿´Á˼¸±éÊéÉϵÄÒâ˼£¬Ç°¶ËÔ¼Êø ÊéÉϵĽâÊÍÊÇ ·ÅÔÚ¿Í»§¶ËµÄ java´úÂëÖеÄÊý¾ÝÔ¼Êø£¨»òÕßÊÇɸѡ´«³öÐèÒªÔ¶³Ì´«ÈëµÄÊý¾Ý£©¡£
лл¥ÉϵĻظ´
Ïà¹ØÎÊ´ð£º
»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£
......
<?php
getenv("ORACLE_HOME");
$conn=ocilogon("test","test","test_db");
if($conn)
echo success;
&nb ......
1.OracleÖÐÃèÊöµÄ¿Í»§¶ËÓ¦Óõ½µ×Ö¸µÄʲô?
2.OracleתÂëʱ,Èç¹û¿Í»§¶ËΪ×Ó¼¯(UASCII)·þÎñ¶ËΪ³¬¼¯(AL32UTF8).
ÄÇÑϸñµÄ½²ÊÇ×Ó¼¯×ª³¬¼¯, ¿ÉÒÔתµÄͨ.
²éѯµÄʱºò³¬¼¯×ª×Ó¼¯ÄDz»¾Í³öÎÊÌâÁËô?
Äĸö»Ø¸öÌ ......
oracle not available
shared memory realm does not exist
ÇëÎʸßÊÖÕâ¸öÎÊÌâÈçºÎ½â¾ö£¿
http://www.inthirties.com/thread-109-2-1.html
Ö¸¶¨ÏÂORACLE_SID,ORACLE_HOME¿´¿´£¬²»ÐоÍÓÃ1Â¥µÃ·½·¨ÁË..
cm ......
ÔÚoracleÖÐÓÃjdbcÀ´Á¬½ÓÊý¾Ý¿â£¬ÎªÊ²Ã´ResultsetÀïÃæǶÌ×ResultSet,µ½Ñ»·µÄµÚ¶þ´Î¾Í±¨¿ÕÖ¸Õ룬ÄÄλ֪µÀÊÇÔõô»ØÊÂÂð£¿
´úÂ룺Java code:
while(prors.next()){
System.out.println(prors.getRow ......