Data Loading with External Tables (172)
The main use for external tables is to use them as a row source for loading data into an
actual table in the database. After you create an external table, you can then use a
CREATE TABLE AS SELECT or INSERT INTO ... AS SELECT statement, using the
external table as the source of the SELECT clause.
When you access the external table through a SQL statement, the fields of the external
table can be used just like any other field in a regular table. In particular, you can use
the fields as arguments for any SQL built-in function, PL/SQL function, or Java
function. This lets you manipulate data from the external source. For data
warehousing, you can do more sophisticated transformations in this way than you can
with simple datatype conversions. You can also use this mechanism in data
warehousing to do data cleansing.
While external tables cannot contain a column object, constructor functions can be
used to build a column object from attributes in the external table .
Note: You cannot insert data into external tables or update records in
them; external tables are read only.
外部表載入資料
1. 不能將記錄插入到外部表中 , 不能更改外部表中的資料 , 外部表是隻讀的
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-981389/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- External Tables: Querying Data From Flat Files in OracleOracle
- Parallel Access to External Tables (173)Parallel
- CRICOS Data Structures and AlgorithmsHash TablesStructGo
- Structure of the Data Dictionary : Base Tables (258)Struct
- use azure data studio to create external table for oracleOracle
- 【OCP最新題庫解析(052)--題3】Which two are true about external tables?
- A C++ half-edge data structure for a triangle mesh with no external dependencies whatsoeveC++Struct
- 【12.2】Oracle 12C R2新特性-外部表支援分割槽了(Partitioning External Tables)Oracle
- External Views (33)View
- dba_tables,dba_all_tables,user_tables,all_tables有什麼區別
- 深入理解mysqldump原理 --single-transaction --lock-all-tables --master-dataMySqlAST
- ERROR3948: Loading local data is disabled - this must be enabled on both the client and server sidesErrorclientServerIDE
- Redshift建立外部架構external schema和外部表external table架構
- abc172D 約數之和
- sqlldr與external tableSQL
- Oracle TablesOracle
- PostgreSQL DBA(172) - PG 13(WAL activity in EXPLAIN)SQLAI
- 做題小計 arc172e
- oracle 外部表 external tableOracle
- Oracle外部表 External TableOracle
- ORACLE_DATAPUMP & External TableOracle
- Oracle Externale TablesOracle
- Oracle - Tables/IndexesOracleIndex
- Oracle X$TablesOracle
- Oracle X$ TablesOracle
- Edit SAP tables
- Oracle Partitioned TablesOracle
- loading
- MySQL 5.5 LOCK TABLES 和 UNLOCK TABLES 語句介紹MySql
- The differences between index-organized tables and ordinary tables (228)IndexZed
- 資料庫表--external table資料庫
- Profitability Analysis – General tables
- 【oracle】user_tablesOracle
- Views and Base Tables (243)View
- Restrictions on Analyzing TablesREST
- Overview of Tables (154)View
- Partitioned Tables (165)
- mysql關於FLUSH TABLES和FLUSH TABLES WITH READ LOCK的理解MySql