MOSS2007µÄBDCÁ¬½ÓORACLEÊý¾Ý¿â
×÷ΪÊý¾Ý¼¯³ÉµÄMOSS×é¼þBDC£¬ÔÚMOSS2007°æ±¾Öл¹Óкܶ಻³ÉÊìµÄµØ·½£¬ËäÈ»¿ÉÒÔ´æÈ¡ÆäËûÊý¾Ý¿âÖеÄÊý¾Ý£¬µ«ÅäÖÃȷʵºÜ¸´ÔÓ£¬È±Ê¡µÄ¹¤¾ßÒ²ºÜÈõ£¬ÕâÊÇÔÚÒ»¸öÏîÄ¿ÖÐÓõ½µÄÁ¬½ÓORACLEÊý¾Ý¿âÅäÖÃÎļþ£¬¼Í¼ÔÚ´ÎÒÔ±ãºóÓá£
<?xml version="1.0"?>
<LobSystem xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:schemaLocation="http://schemas.microsoft.com/office/2006/03/BusinessDataCatalog BDCMetadata.XSD" Type="Database" Version="1.0.0.0" Name="OracleLOBSystem" xmlns="http://schemas.microsoft.com/office/2006/03/BusinessDataCatalog">
<Properties>
<Property Name="WildcardCharacter" Type="System.String">%</Property>
</Properties>
<LobSystemInstances>
<LobSystemInstance Name="OracleInstance">
<Properties>
<Property Name="DatabaseAccessProvider" Type="System.String">Oracle</Property>
<Property Name="AuthenticationMode" Type="System.String">PassThrough</Property>
<Property Name="RdbConnection Data Source" Type="System.String">(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = djin-pc)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = umboydb.bingosoft)))</Property>
<Property Name="RdbConnection Pooling" Type="System.String">false</Property>
<Property Name="RdbConnection User ID" Type="System.String">system</Property>
<Property Name="RdbConnection Password" Type="System.String">123456</Property>
<Property Name="RdbConnection Integrated Security" Type="System.String" />
<Property Name="WildcardCharacter" Type="
Ïà¹ØÎĵµ£º
oracle 8i ÒÔºó¼Ó´¦µÄ¹¦ÄÜ£¬Oracleר¼Ò¿Éͨ¹ýÒ»ÖÖ¼òµ¥µÄ·½Ê½À´ÎªCBOÊÕ¼¯Í³¼ÆÊý¾Ý¡£Ä¿Ç°£¬ÒѾ²»ÔÙÍƼöÄãʹÓÃÀÏʽµÄ·ÖÎö±íºÍdbms_utility·½·¨À´Éú³ÉCBOͳ¼ÆÊý¾Ý¡£ÄÇЩ¹ÅÀϵķ½Ê½ÉõÖÁÓпÉÄÜΣ¼°SQLµÄÐÔÄÜ£¬ÒòΪËüÃDz¢·Ç×ÜÊÇÄܹ»²¶×½µ½ÓйرíºÍË÷ÒýµÄ¸ßÖÊÁ¿ÐÅÏ¢¡£ CBOʹÓöÔÏóͳ¼Æ£¬ÎªËùÓÐSQLÓï¾äÑ¡Ôñ×î¼Ñµ ......
½ñÌìµçÄÔÄûؼң¬Æô¶¯oracleÊý¾Ý¿âµÄ¼àÌý·þÎñʱ·¢ÏÖÎÞ·¨Æô¶¯¡£¸ø³öµÄ´íÎóÌáʾÊÇ˵£¬Õâ¸ö·þÎñÆô¶¯ÁËÓÖÍ£Ö¹ÁË£¬²»ÖªµÀÊÇΪʲô¡£ÒòΪÔÚѧУµÄʱºòÓÃÊÇûÓÐÎÊÌâµÄ¡£ÎÒÏëÓ¦¸ÃÊÇÒòΪipµÄÊÇÎÊÌâ¡£ÔÚÍøÉϲéÁËһϣºÄãÊÇ·ñÐÞ¸ÄÄãµÄ»úÆ÷Ãû»òIPµØÖ·£¬Èç¹ûÓÐÐ޸ģ¬°ÑORACLE\ora81\network\admin\listener.oraÎļþÖеÄhostÐÞ¸ÄΪлúÆ÷à ......
ʹÓÃOracle 9i Êý¾Ý¿â
°²×°Íê±ÏºóOracleÊý¾Ý¿â»á×Ô¶¯Æô¶¯£¬ÏÂÃæÎÒÃÇÓÃʵ¼Ê³¬×÷À´ËµÃ÷Ò»ÏÂOracle 9iÊý¾Ý¿âµÄÆô¶¯ºÍ¹Ø±Õ¡£
ÒÔOracleÓû§µÇ½Êý¾Ý¿â£¬¿ª¸ö¿ØÖÆ̨´°¿Ú£»
¹Ø±ÕOracle 9i Êý¾Ý¿â
-------------Ç¿ÖƹرÕÊý¾Ý¿â
-------------shutdown abort
[Oracle@wing /Oracle]$ sqlplus " / as sysdba" //ÒÔsysdbaÓû ......
ÔÀ´ÓõÄSQL server£¬Ö÷ÒªÓÐÁ½ÖÖ·ÖÒ³·½·¨£ºÓαêºÍÆ´×Ö·û´®£¬Óα귨̫Âý£¬Æ´´®·¨Ò²ÓÐһЩȱÏÝ¡£
ÏÖÔÚÕÒµ½ÁËÒ»¸öOracleµÄ·ÖÒ³·½·¨£¬Ò²¿ÉÒÔ˵ÊÇÆ´×Ö·û´®£¬µ«ÊÇÓÃÆðÀ´¾Í±ÈSQL serverµÄÒª·½±ã£¬Ã»ÓÐ֮ǰµÄÎÊÌ⣺
SELECT * from
(
SELECT A.*, ROWNUM RN
from (SELECT * from TABLE_NAME) A
WHERE ROWNUM <= 40
)
W ......