ÎÒÔÚ°ÑÊý¾Ý¿â´Ó²âÊÔ»úÇ¨ÒÆµ½Õýʽ¿âÖ®ºó£¬ÓÐЩ¶ÔÏóÐèÒªÖØÐÂÊÚȨ¸øÓû§£¿ÓÐЩÓû§ÐèÒªÊÚÓèÁíһЩȨÏÞ£¿
Êý¾Ý¿â±¸·Ý:exp system/manager@TESTDB file=.. full=y
Êý¾Ýµ¼Èë:imp sys/change@TRUEDB as sysdba file=..
µ¼ÈëÍê³Éºó£¬ÖØÐ±àÒëËùÓжÔÏó£¬ÔÚGISÓû§ÏµÄijЩ³ÌÐò°ü»áͨ²»¹ý±àÒë ......
ÈçÌâ£¬Ã²ËÆoracleµ¥Ò»´æ´¢¹ý³Ì²»ÄÜ·µ»ØÈçSelect * from table
µ«Èç¹û²ÉÓÃÓα꣬ÕâÑùÊDz»ÊǵIJÉÓðüÀ´ÊµÏÖ
ÕâÑù²»ÖªµÀrdlcÖÐÄܲ»ÄÜÖ§³Öµ÷ÓðüÖеĴ洢¹ý³Ì
¶àл£¡
ÒýÓÃ
ºÃÏñoracleÓÐËü×Ô¼ºµÄreport service¡£
http://www.oracle.com/technology/products/reports/index.html
µ«ÊÇÏÖÔÚÐèÒªÔÚrdlcÖе ......
ѰÇó½â¾ö·½°¸£¡¹ØÓÚOracle²éѯËٶȵģ®
Ö÷ÊÇ´óÊý¾ÝÁ¿¡¡£«¡¡´óÁ¿¼ÆËãºó²éѯµÄËÙ¶È
ÓÐЩʲôÑùµÄ·½°¸ÄÜÌá¸ß¡¡ÕâÖÖ²éѯЧÂÊ
Êý¾ÝÁ¿Ò²¾ÍһǧÍò×óÓÒ
²»¹ý¼ÆËãÉÏÉÔ΢Óе㸴ÔÓ¡¡
ÏÖÔÚµÄÕý³£Çé¿öÏ¡¡ÒªÊ®¼¸ÃëµÄʱ¼ä£®£®
»¹ÓÐЩʲôÑùµÄ·½°¸ÄÜÈÃÕâ¸ö²éѯЧÂÊÌá¸ß
ÄÜÔÚÎåÃëÄÚÊÇ×îºÃµÄ£®£®£®
SQL ЧÂʾö¶¨²éѯËÙ¶È.. Ïë°ì·¨ ......
ÔÚ¿Í»§¶ËµÃsqlplusÄÜÁ¬ÉÏ!
µ«ÊÇÓÃasp.netÁ¬²»ÉÏ
using System.Data.OracleClient;
OracleConnection OraConn = new OracleConnection("data source=(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.13)(PORT = 1521)))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = orcl) ......
SELECT (select placename from sysloginplace where id = a.YardName) YardNameDisp,
a.YardName,
a.CntrOrUnit2,
count(*) CntrNum,
  ......
¸÷λÀÏ´ó£¬ÎÒÏÖÔÚ¹¤×÷ÁËËÄÄêÁË£¬¶¼ÊÇÓÃORACLE+Pro*C+AIX¡£²»¹ý×î½üÏëµ½×Ô¼ºÊÖÉÏûÓÐÒ»¸öÏñÑùµÄÖ¤£¨Ö»Óйú¼ÒÈí¼þˮƽ¿¼ÊԵϹÊÇÈí¿¼¸Ä¸ïǰµÄ£©¡£Òò´ËÏÖÔÚ×¼±¸È¥¿¼Ò»ÏÂOCPÖ¤Ê飬ÇëÎÊÕâ¸öÖ¤ÊéµÄº¬½ðÁ¿ÔõôÑù£¬ÁíÍ⻹ÓÐÒ»¸öʲôWDPÊÇʲô¶«¶«£¿Ð»Ð»À²~~~~~
http://topic.csdn.net/u/20090708/00/E81C71ED-9E54-4F54-A96B-B3CDF ......