Loading data into a database

Data Loading Methods Several methods are available for loading data into tables in an Oracle database. Of the methods available, Direct Load insert and SQL*Loader are discussed here. Export and Import are covered in the Oracle9i Database Administration Fundamentals II course. SQL*Loader SQL*Loader loads data from external files into tables of an Oracle database. It has a powerful data parsing engine that places little limitation on the format of the data in the data file. Direct Load Direct Load insert can be used to copy data from one table to another table within the same database.

40p trinh02 28-01-2013 69 5   Download

Loading Data Several methods are available for loading data into tables in an Oracle database. Of the methods available Direct-Load insert and SQL*Loader are discussed here. SQL*Loader SQL*Loader loads data from external files into tables of an Oracle database. It has a powerful data parsing engine that puts little limitation on the format of the data in the datafile. Direct-Load insert Direct-load insert can be used to copy data from one table to another table within the same database.

32p trinh02 28-01-2013 67 4   Download

[ Team LiB ] Recipe 2.1 Retrieving Hierarchical Data into a DataSet Problem You want to fill a DataSet with parent and related child data, even if the DataSet already has a schema that includes the relationship. Solution There are several techniques you can use to load parent and child data into a DataSet.

4p luvpro 04-08-2010 77 6   Download

[ Team LiB ] Recipe 2.20 Retrieving Data from an Oracle Package Problem Given an Oracle package that returns multiple result sets for related tables as REF CURSOR data types, you want to access this data using a DataReader and load the data into a DataSet. Solution Use the data type OracleType.Cursor .

5p luvpro 04-08-2010 91 7   Download