Want to import data from Txt file to Oracle ?
Using OraLoader, you can import data from TXT file to Oracle easily and fast, no need to program, just a few mouse clicks!
Import data from TXT file to Oracle
Click “Load From File” at task dialog.
then show the wizard.
1. Open a TXT file.
2. Select a table and config fields.
3. Preview data.
4. Import.
More about OraLoader – the tool to import data from TXT file to Oracle
Oracle → TXT reference
Type mapping
| Value kind | in Oracle | in TXT |
|---|---|---|
| Int | NUMBER(10) | 1234, or right-aligned in a fixed-width column |
| Bigint | NUMBER(19) | 9007199254740993 |
| Decimal | NUMBER(p,s) | 1234.56 |
| Float | BINARY_DOUBLE | 1.234e+10 |
| Text | VARCHAR2(n) | written as-is; padding depends on the chosen layout |
| Long text | CLOB | written as-is |
| Date | DATE | whatever the writer chose |
| Datetime | TIMESTAMP | whatever the writer chose |
| Binary | BLOB | not representable |
| Boolean | NUMBER(1) | Y / N, or 1 / 0, or TRUE / FALSE |
Dialect differences
Oracle is a database server and TXT is a file format, so the gap is wider than a dialect difference - the rows below are where values and structure stop lining up.
| Property | in Oracle | in TXT |
|---|---|---|
| port | 1521 | — |
| identifiers | "double quotes" | None by convention |
| row limit | FETCH FIRST n ROWS ONLY | — |
| dates | DATE, TIMESTAMP | Whatever the writer produced; no convention is guaranteed |
| long text | CLOB, NCLOB | — |
| binary | BLOB, BFILE | Not supported |
| separator | — | Whatever was chosen - often fixed column widths |
| encoding | — | No declaration - UTF-8 works only with a BOM |
| typing | — | None - every field is text |
| shape | Tables of rows and columns | Free form; a parser has to be told the layout |
| ceiling | — | No formal limit |
Command line
| Side | Command |
|---|---|
| Oracle | exp / expdp |
| Oracle (load) | sqlldr (SQL*Loader) |
Convert your data online, free
Free in-browser converters for CSV, Excel, JSON, XML and SQL: Withdata Online Data Conversion. Large files, batch conversion or scheduling? See the offline desktop apps, or browse all data conversion tools.