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

oracleÎ÷Å·×Ö·û¼¯

oracle·þÎñÆ÷¶Ë²ÉÓõÄÊÇÎ÷Å·×Ö·û¼¯:AMERICAN_AMERICA.WE8ISO8859P1£¬ÎÒÔÚ³ÌÐòÀï²éѯ³öÀ´ºóÊÇÂÒÂë
Çë¸ßÊÖ°ïæ

ÔÚÏßµÈ... 


ÔÚ³ÌÐòÀïÖ¸¶¨ÏàͬµÄ×Ö·û¼¯¿ÉÐУ¿

ÔÚ³ÌÐòÀïÖ¸¶¨ÏàͬµÄ×Ö·û¼¯£¬½«»á·Ç³£µÄ·±Ëö
ÓÐûÓÐÆäËüµÄ°ì·¨

ÄãÊÇÓõÄʲô³ÌÐò£¬jdbc thin£¬jdbc oci£¬ occi»¹ÊÇÆäËû±¾µØ¿âµÄ·½Ê½?

Èç¹ûÊÇjdbc thin£¬ÐèÒª°Ñ½á¹û¼¯×ªÂëÖÁISO-8859-1£¬Èç¹ûÊÇociÕâÑùµÄ±¾µØ¿âµ÷Óõķ½Ê½µÄ·½Ê½£¬ÐèÒªÉèÖÃNLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1


Ïà¹ØÎÊ´ð£º

PHP Á¬½ÓOracle ³ö´í

<?php
  getenv("ORACLE_HOME");
  $conn=ocilogon("test","test","test_db");
  if($conn)  
  echo success;  
&nb ......

ORACLEÊý¾Ý¿âÖÐµÄ group by Óï¾ä£¿

  with adod_dict do
    begin
    close;
    commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......

ÇóʹÓÃt-sqlÓï¾ä½«paradoxÊý¾Ýµ¼ÈëoracleµÄ°ì·¨

ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......

lomboz eclipse ÖмÓÈëoracleµÄÎÊÌâ

ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿


......

imp µ¼Èë oracle ÎÊÌâ

µ¼³ö¡¢µ¼Èë¶¼ÊÇ oracle 10g ¡£

ÔÚµ¼Èë¹ý³ÌÖгöÏÖÈçÏÂÇé¿ö£º

IMP-00017: ÓÉÓÚ ORACLE ´íÎó 6550, ÒÔÏÂÓï¾äʧ°Ü:
"DECLARE  SREC DBMS_STATS.STATREC; BEGIN SREC.MINVAL := '4E014E50 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ