An external table is a read-only table stored outside a database in flat files. The metadata for an external table is not created at the time of table creation. However, the CREATE TABLE statement is used to create metadata. External tables are used to load and unload Oracle data as flat files. The following can be used to query data stored in an external table:
- SQL statements
- PL/SQL
- JAVA
Indexes cannot be created for an external table. The following are the two types of access drivers provided by an Oracle server for an external table:
- Download free practice test for oca-dba10g OCA DBA 10g exam.
- Become Oracle OCA DBA 11g certified.
- Get certified in first attempt download oca-dba9i - OCA DBA 9i simulation.
- Best exam simulation Oracle oca-pl-sql download free trial.
- Click here to download ocp-dba10g test study guide and practice question.
- Get certified in first attempt download ocp-dba-11g - OCP DBA 11g simulation.
- Get certified in first attempt download ocp-dba9i - OCP DBA 9i simulation.
- Download free practice test for Oracle OCP PL/SQL Developer exam.
- Download free practice test for Oracle Oracle Certified Master 10g exam.
- Download free practice test for Oracle Oracle PL/SQL Developer exam.
- Download free practice test for Oracle Performance Tuning Expert 11g exam.
- Download free practice test for Oracle RAC Certified Expert 10g exam.
- Become Oracle SQL Certified Expert 10g certified.
- Get certified in first attempt download sql-certified-expert-11g - SQL Certified Expert 11g simulation.
- Best exam simulation Oracle 1Z0-047 download free trial.
- Download free practice test for Oracle OCA: Oracle Database 11g: Administration I exam.
Like this article? Share it with others
If you like this article, please leave a comment or subscribe this blog via RSS or via e-mail, Bookmark and share through your network. Click the AddThis button below. Thanks.
If you like this article, please leave a comment or subscribe this blog via RSS or via e-mail, Bookmark and share through your network. Click the AddThis button below. Thanks.
