Describe how to load data through External Tables

Describe how to load data through External Tables.

<<Previous Next>>

Oracle - Describe how to load data through External Tables - June 27, 2009 at 11:00 AM

Describe how to load data through External Tables.

Create an external table with columns matching data fields in the external file.
Create a similar table.
Execute INSERT INTO ... SELECT statement to load data from the external file.

Also read

How many types of Tables supported by Oracle? Explain them

Ordinary (heap-organized) table, Clustered table, Index-organized table, Partitioned table...........

Explain how to view all columns in an Existing Table.

Use the command DESC and the table name to view the information about the columns..........

Explain how to recover a dropped Table in Oracle.

<<Previous Next>>

Write your comment - Share Knowledge and Experience


Interview questions
Oracle interview Oracle architecture Oracle FAQs Download Oracle/Java FAQ Test Oracle skills New More Oracle FAQs Oracle processes Oracle memory area Oracle file types Oracle database objects Oracle operators Oracle composite Oracle constraints Oracle data types Oracle DCL and TCL Oracle DML commands Oracle error handling Oracle functions Oracle procedure, package Oracle import and export Oracle sub queries Oracle table Oracle triggers Oracle views Oracle synonym Oracle indexes Oracle joins Oracle cursors Oracle form Oracle security Oracle system privilege Oracle object privileges Oracle table privileges Oracle view privileges Oracle backup & recovery Oracle DBA Oracle PL/SQL Oracle nested table & varrays Oracle large objects Oracle replication Oracle transaction Oracle optimizer Oracle auditing Oracle backup Oracle database tuning Oracle application tuning Oracle procedures Oracle functions Oracle loops Oracle exceptions Oracle Select into clause Oracle string functions Oracle numeric functions Oracle date functions Oracle translate and decode Oracle correlated sub-queries Oracle union, intersect, minus Oracle clusters Oracle sequences Oracle tablespaces Oracle object datatypes Oracle Tutorial


Latest MCQs
» General awareness - Banking	» ASP.NET	» PL/SQL	» Mechanical Engineering
» IAS Prelims GS	» Java	» Programming Language	» Electrical Engineering
» English	» C++	» Software Engineering	» Electronic Engineering
» Quantitative Aptitude	» Oracle	» English	» Finance
Home \| About us \| Sitemap \| Contact us \| We are hiring
© Copyright 2016. All Rights Reserved. Terms of use \| Follow us on Facebook!