HomeForum
Welcome, Guest
ETL-Forum
Forum
Data Warehousing and Data integration

Loading data into Oracle Database
(1 viewing) (1) Guest
Data Warehousing and Data integration
Reply Topic
New Topic
  • Page:
  • 1

TOPIC: Loading data into Oracle Database

Loading data into Oracle Database 12 months ago #2732

  • Dimitri
  • OFFLINE
  • Fresh Boarder
  • Posts: 2
  • Karma: 0
Help me please,

I am trying the Visual Importer, and need to import CSV into Oracle.
One field needs to go to an Oracle column with DATE datatype.
I can't find any conversion functions (StringToDate) or any other way of doing it.
The date in CSV is in this format: "1-Oct-08'

Regards,
Dimitri
Reply Quote

Re: Loading data into Oracle Database 12 months ago #2733

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2183
  • Karma: 12
There is no need to use conversion functions

Just assign appropriate date format

There is a chapter in the documentation about it

Mike
Reply Quote
Reply Topic
New Topic
  • Page:
  • 1
ETL-Forum
Forum
Data Warehousing and Data integration
Powered by Kunena
Time to create page: 0.14 seconds

Testimonials

"I needed to integrate and automate disparate systems running different database platforms that speak different languages, even different flavors of SQL. Visual Importer products have become that common link for me."

Gene Kovacs,
Director of Technical Business Operations,
A2B

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC

Databases we work with

Submit to Delicious Submit to Digg Submit to Facebook Submit to Google Bookmarks Submit to Stumbleupon Submit to Technorati Submit to Twitter Submit to LinkedIn
Go to top