pl/sql Óï¾äµÄ¼¸µãÓÅ»¯
1.
SQL> desc gjh_a05 ;
Name Type Nullable Default Comments
----- ------------- -------- ------- --------
A0500 VARCHAR2(2) Y
A0501 VARCHAR2(6)
A0502 VARCHAR2(10) Y
A0503 VARCHAR2(10) Y
A0504 VARCHAR2(20) Y
A0505 VARCHAR2(255) Y
A0506 VARCHAR2(1) Y
A0507 VARCHAR2(4) Y
A0508 VARCHAR2(8) Y
A0509 CHAR(1) Y
A0510 VARCHAR2(8
Ïà¹ØÎĵµ£º
-----------------------------------------------------
--×÷ÓãºÓÃÓÚsql server 2005 µ¼³öÓû§±íÊý¾Ý×Öµä
--1 ĬÈϵ¼³öµ±Ç°Êý¾Ý¿âÖÐËùÓÐÓû§±í(xtype = 'u')µÄÊý¾Ý×ֵ䣻
--2 ¿ÉÒÔÔÚxtype = 'u'Ìæ»»ÎªÈçÏÂËùʾÓï¾äxtype = 'u' and name in ('son','Person') µ¼³ö×Ô¶¨ÒåµÄ±íµÄÊý¾Ý×ֵ䣻
--3 ¿ÉÒÔÀûÓü¯³É·þÎñSSISµ¼³ ......
SQL Server 2005 ´´½¨µ½ Oracle10g µÄÁ´½Ó·þÎñÆ÷
ÓÉ lwgboy @ MoFun.CC, ÔÚ 08-9-12 ÏÂÎç5:00
±ê¼Ç: linkserver, oracle, sqlserver, Á´½Ó·þÎñÆ÷
SQL Server 2005 ´´½¨µ½ Oracle10g µÄÁ´½Ó·þÎñÆ÷
SQL Server 2005 ÒìÀàÊý¾ÝÔ´(ORACLE10G)Á´½Ó·þÎñÆ÷µÄ½¨Á¢
±¾ÎļòÊöSqlServer 2005 Á´½Óµ½ Oracle10g ·þÎñÆ÷µÄ¹ý³Ì¼°»ù ......
·Ö²¼Ê½²éѯ
OPENROWSET
´ÓExcelÈ¡Êý¾Ý
SELECT * from OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=d:\1.xls',[Sheet1$])
´ÓOracleÈ¡Êý¾Ý
SELECT * from OPENROWSET('MSDAORA.1','NetServiceName ......
ת×Ô£ºhttp://hong9270503.blog.163.com/blog/static/127292320091611319516/
ͨ¹ýSQL*PLUSÎÒÃÇ¿ÉÒÔ¹¹½¨ÓѺõÄÊä³ö£¬Âú×ã¶àÑù»¯Óû§ÐèÇó¡£
¡¡¡¡
±¾Àýͨ¹ý¼òµ¥Ê¾Àý£¬½éÉÜͨ¹ýsql*plusÊä³öxls£¬htmlÁ½ÖÖ¸ñʽÎļþ.
¡¡¡¡ Ê×ÏÈ´´½¨Á½¸ö½Å±¾:
¡¡¡¡
1.main.sql
¡¡¡¡ ÓÃÒÔÉèÖû·¾³£¬µ÷ÓþßÌ幦Äܽű¾
¡¡¡¡ 2.¹¦Äܽű¾-ge ......
Ò», °²×° unixODBC
ÏÂÔØ°²×°°ü. ÔÚ RedHat °²×°¹âÅÌÉϾÍÓÐ
unixODBC-2.2.11-1.RHEL4.1.i386.rpm
unixODBC-devel-2.2.11-1.RHEL4.1.i386.rpm
unixODBC-kde-2.2.11-1.RHEL4.1.i386.rpm
°²×°
rpm -Uvh unixODBC-2.2.11-1.RHEL4.1.i386.rpm
rpm -Uvh unixODBC-devel-2.2.11-1.RHEL4.1.i386.rpm
Èç¹û°²×°ÖÐÌáʾÓÐ¶ÔÆäË ......