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

javascriptÁ¬½ÓoracleÊý¾Ý¿â

<script> 
var cpt_d="//192.168.8.163:1521/orclerp";
var john="taizhou_qy";
var doe="11hello!";

//Óà JavaScript д·þÎñÆ÷¶ËÁ¬½ÓÊý¾Ý¿âµÄ´úÂëʾÀý 
var conn = new ActiveXObject("ADODB.Connection");
conn.Open("Provider=OraOLEDB.Oracle;Data Source="+cpt_d+";User ID="+john+";Password="+doe+";PLSQLRset=1"); 
........
ÔËÐнá¹ûÏÔʾÕâÒ»¾ä´íÎó£¬
¡°Î´ÕÒµ½Ìṩ³ÌÐò£¬¸Ã³ÌÐò¿ÉÄÜδÕýÈ·°²×°¡±

Çë¸ßÊÖ°ïÖúÐ޸ġ£
ÎÒ¾ÍÊÇÏëÓÃjavascriptÁ¬½Óoracle£¬ÒÔǰÓÃvbscriptÁ¬½Ó£¬¶¼Õý³££¬µ«ÊÇ£¬javascript¿ÉʹÓõĺ¯ÊýºÜ¶à£¬Ïë¸ÄÓÃËüÀ´±à³Ì¡£
±¾»úµÄODBCÊý¾ÝÔ´ÄÜÕâÑùÁ¬½ÓoracleÂð

JavaScriptÁ¬½ÓÊý¾Ý¿â£¿²»ÖªÊÇÎÒÂäºóÁË»¹ÊÇ£¿

lzÍæÕâÖÖ£¿£¿

²»¶¥²»ÐР

¶¥Ìù»úq:525093551 ¶¥Ìû»ú
  xyq1986

Ö»ÄÜЦЦÁË

¾ÍËãÄÜÁ¬ÉÏ£¬¿´ÁËjs´úÂ룬µØÇòÈ˶¼ÖªµÀÄãÊý¾Ý¿âµÄÓû§ÃÜÂëÁË

¶¥Â¥ÉÏ

Óýű¾Á¬Êý¾Ý¿â ûÓùý

¿¼µ½Õâ¸ö±êÌâÎÒ¾ÍÔÚÏ룺ΪʲôҪʹÓÃJavaScriptÁ¬½ÓÊý¾Ý¿â°¡£¿
Ϊʲô²»Ê¹ÓÃvbscriptÁ¬½Ó°¡£¿
ÄѵÀ¾ÍÒòΪÏÖÔÚJSºÜÁ÷ÐÐÂð£¿


ÄÜÁ¬ÉÏÒ²²»Ó㬲»°²È«

ÒýÓÃ
<script>
var cpt_d="//192.168.8.163:1521/orclerp";
var john="taizhou_qy";
var doe="11hello!";

//Óà JavaScript д·þÎñÆ÷¶ËÁ¬½ÓÊý¾Ý¿âµÄ´úÂëʾÀý
var conn = new ActiveXObject("ADODB.Connection");


Ïà¹ØÎÊ´ð£º

oracleÓëaix - Oracle / ¸ß¼¶¼¼Êõ

ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼­¾íºÅlv04 
#lslv -l lv04 ......

oracle 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......

server 2000Êý¾Ý×ªÒÆµ½oracle - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔ­À´oracleÀïµÄÔ­ÓеÄÊý¾Ý¿â,Ö»ÄÜн¨

ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......

Ò»¸öpl/sqlÎÊÌâ - Oracle / ¿ª·¢

ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
  declare
  TYPE test_rec IS record(
  code varchar(10),
  name varchar(30)
  );
  v_book test_rec;
    ......

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ºÅ