oracleÍⲿ±í£¨External Table£©µÄʹÓÃ
ÔÎĵØÖ·£ºhttp://arvinnan.javaeye.com/blog/308638
²Î¿¼
http://www.blogjava.net/wxqxs/archive/2008/10/13/237180.html?opt=admin
http://hi.baidu.com/ray315/blog/item/153c97a33cd26caacbefd0de.html
¶¨Òå
External tables access data in
external sources
as if it were in a table in the database.
You can connect to the database and create metadata for the external table
using DDL
.
The DDL for an external table consists of two parts:
one part that describes the Oracle
column types
, and
another part (the access parameters) that describes the mapping of
the external data to the Oracle
data columns.
u
´´½¨µÄÓï·¨ÀàËÆÓÚ£º "CREATE TABLE ... ORGANIZATION EXTERNAL"
u
Êý¾ÝÔÚÊý¾Ý¿âµÄÍⲿ×éÖ¯£¬ÊDzÙ×÷ϵͳÎļþ¡£
u
²Ù×÷ϵͳÎļþÔÚÊý¾Ý¿âÖеıêÖ¾ÊÇ
ͨ¹ýÒ»¸öÂ߼Ŀ¼À´Ó³Éä
µÄ¡£
u
Êý¾ÝÊÇ
Ö»¶Á
µÄ¡££¨Íⲿ±íÏ൱ÓÚÒ»¸öÖ»¶ÁµÄÐé±í£©
u
²»¿ÉÒÔÔÚÉÏÃæÔËÐÐÈκΠDML ²Ù×÷
£¬
²»¿ÉÒÔ´´½¨Ë÷Òý
¡£
u
¿ÉÒÔ²éѯ²Ù×÷ºÍÁ¬½Ó
¡£¿ÉÒÔ²¢ÐвÙ×÷¡£
½¨Á¢Íⲿ±íµÄ²½Öè
£º
1¡¢´´½¨ÒÔ“,”·Ö¸ôµÄÎļþ“TestTable.csv”ÖÁ“D:\Test
”
2¡¢´´½¨Ò»¸öDirectory£º
create
directory
TestTable_dir
as
'D:\Test'
;
3¡¢´´½¨Ò»¸öÍⲿ±í£º
create
table
TestTable(
ID
varchar2
(
10
),
 
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
select * from user_recyclebin where original_name like 'FINANCE_%' order by droptime desc;
FLASHBACK TABLE FINANCE_CASE_FEE_ITEM TO BEFORE DROP
¼´ËùÓÐdropµÄ±í¶¼ÔÚ user_recyclebin Õâ¸öoracle»ØÊÕÕ¾ÀïÃæµÄ£¬ÔÙͨ¹ýflashbackÃüÁԼ´¿É¡£
¿´ÁËÍøÉÏ»¹¿ÉÒÔͨ¹ýµ÷Õûoracleʱ¼ä £¬»Øµ½É¾³ýµÄÄ ......
¡¡¡¡1. Oracle°²裝Íê³ÉºóµÄ³õʼ¿ÚÁ
¡¡¡¡internal/oracle
¡¡¡¡sys/change_on_install
¡¡¡¡system/manager
¡¡¡¡scott/tiger
¡¡¡¡sysman/oem_temp
¡¡¡¡2. ORACLE9IAS WEB CACHEµÄ³õʼĬÈÏÓû§ºÍÃÜÂ룿
¡¡¡¡administrator/administrator
¡¡¡¡3. oracle 8.0.5Ôõô´´½¨Êý¾Ý¿â£¿
¡¡¡¡ÓÃorainst¡£Èç¹ûÓ ......
http://blog.csdn.net/lzysystem/archive/2009/03/05/3960853.aspx
http://www.linuxidc.com/Linux/2009-06/20390.htm
http://www.linuxdiyf.com/viewarticle.php?id=163893
http://blog.sina.com.cn/s/blog_4ed66efa0100gfjx.html### ......
PowerBuilderÈ¡µÃ¾Þ´ó³É¾ÍµÄÔÒò¾ÍÊÇÓй¦ÄÜÇ¿´óºÍÁé»î¶à±äµÄDatawindow¶ÔÏ󣬱¾ÈËÓÃPowerBuilder¿ª·¢¹ýÒ»¶Îʱ¼äºó£¬×ܽá³öһЩ¼¼ÇÉ£¬ÒÔ¹©¹ã´óµÄPB¿ª·¢Õß½è¼øʹÓá£
1¡¢ ÈçºÎ´´½¨Ò»¸ö¾ßÓÐÖð½¥µÝÔöÇóºÍ¹¦Äܵı¨±í£¬ÈçÏÂÐÎʽ£º Running TotalÁУ¬ÎÒÃÇ¿ÉʹÓüÆËãÁУºCumulativeSum£¨Quantity for all£©£¬¼´¿É´ïµ½Öð½¥µÝÔöÇóºÍ ......