Database Administration (MOSC)

MOSC Banner

Specifying date format for external tables

edited Dec 6, 2008 11:23PM in Database Administration (MOSC) 5 commentsAnswered ✓
I am trying to define an external table that has a date in it.  The date in the file is formatted MM/DD/YYYY.  I can't figure out how to specify it as a date in the external table definition.  I have tried:   DATE_RECORDED date "mm/dd/yyyy" and I keep getting an ORA-00907: missing right parenthesis error.  Anyone know what I am doing wrong?
Richard

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center