ͨ¹ýä¯ÀÀÆ÷·ÃÎÊÆóÒµ¹ÜÀíÆ÷£¬Ò³Ãæ¿Õ°×£¬Ö»ÓÐ×óÉϽÇÓÐÆæ¹ÖµÄͼ°´£¬ÓеãÏñÂÒÂëÄÇÖֵģ¬ÎªÊ²Ã´»áÕâÑù£¿ÎҶ˿ڶ¼Ð´¶ÔµÄ
ÊÇ·ÃÎÊemô¡£
¿ÉÒÔhttp:\\host:1158\em
¶Ë¿ÚÒ²ÓпÉÄÜÖ¸¶¨ÆäËûµÄ¶Ë¿ÚÁË
¿ÉÒÔÔÚ%ORACLE_HOME%\install\portlist.iniÖп´¿´
ÕâÖÖÇé¿öÎÒÒ²Óöµ½¹ý,µ±Ê±ÊǶ˿ÚÕÒ´íÁ˵¼ÖµÄ.
grid cont ......
´´½¨ÊÓͼÈçÏ£º
......
--Ö÷ÒªÄÚÈÝ£º
select name,(case when nvl(sid,'') is null then cast(studentid as varchar(36)) else ybkh end case) as studentid
from student;
......
´´½¨µÄʱºò±¨´í£ºÈ±ÉÙÓÒÀ¨ºÅ¡£¡£¡£
Çë´ó¼Ò°ï°ï濴϶¡£¡£
caseµÄ×÷ÓÃÊÇ ......
32λoracle×°ÔÚWindows server 2003
¿Í»§»ú¿ÉÒÔ²éѯÊý¾Ý¿â£¬µ«ÊÇ
²é¿´ODBCÊý¾ÝÔ´¹ÜÀíÆ÷ £¬Ã»ÓÐoracleµÄÇý¶¯³ÌÐò¡£
²»ÖªÎªºÎ£¿¡¢
ÊÇÒòΪ32λ oracle×°ÔÚ64Ϊ²Ù×÷ϵͳÂð£¿
»¹ÓÐÓëÏÂÃæµÄÏÖÏó²»ÖªÓÐûÓйØÏµ¡£
Æô¶¯·þÎñÆ÷ʱ£¬±¨´í
·þÎñÆ÷¿ØÖƹÜÀíÆ÷
¡°ÔÚϵͳÆô¶¯Ê±ÖÁÉÙÓÐÒ»¸ö·þÎ ......
ÎÒÃǹ«Ë¾ÓõÄOracle,µ«×ܳöÏÖ´æÖÐÎĵıêµã·ûºÅ·Ê±£¬ÔÚÊý¾Ý¿âÖлá±ä³ÉÂÒÂ룬¶øÆäËûµÄÖÐÎͼ¿ÉÒÔÕý³£´æ´¢£¬ÇëÎʸÃÈçºÎ½â¾ö°¡£¿ÕæÊÇÒ»µã°ì·¨¶¼Ã»ÓÐÁË£¬Ð»Ð»Ö¸µã
select chr(41380) from dual¿´¿´ÕâÑùÄÜÕý³£³ö·Õâ¸ö·ûºÅÂð
×Ö·û¼¯µÄÎÊÌâ°É
Ëü´æµ½Êý¾Ý¿âÖоͱä³É£¿ºÅÁË£¬²»Ðа¡
select value from v$nls_para ......
¹«Ë¾Í¬ÊÂÔÚOracle.DataAccess»ù´¡ÉÏ×öÁ˸öDataServices.dll£¬ÒÀÀµOracle.DataAccess 9.2.0.700.
±¾µØ°²×°ORACLE CLIENTʱ£¬ dll°æ±¾ÊÇ9.2.0.2102.
ÕâʱÔõô´¦ÀíÒÀÀµ¹ØÏµ£¿
ÊÇÖ»ÓÃ9.2.0.2102»¹ÊÇ2¸ö°æ±¾µÄ¶¼Òª£¿
ÊìϤOracleµÄÇëÖ¸½Ì¡£
ÎÊÌâÎʵò»ºÃ¡£ ÖØÐÂÃèÊöһϡ£
Èç¹ûÓÐÒ»¸ödll£¬ ÒýÓ ......
ÏÖÔÚÒªÏòOracleÖÐÉÏ´«Ò»¸öÎļþ£¬´úÂëÈçÏ£º
create or replace function plan_fliles_load_file
(filePath varchar2,fileName varchar2) return boolean
/* *******************************************************************************************
--¹¦ ÄÜ£ºÏò±íÖÐÉ ......