|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
July 18th, 2005, 11:37 PM
|
|||
|
|||
data type checking!!!
Hey all...
can anyone help me how to check a data type.i'm doing a migration project and i need to import data from excel and text files to oracle database. now i need to know how to check the data types in those file eg. the correct date/time format so that i import the datas correctly to the oracle.anyone has any suggestion or ideas.thanx in advance..
|
|
#2
July 19th, 2005, 10:46 AM
|
|||
|
|||
|
sqlldr with a CTL file will create a log file with errors in it.
The safest way to do this is to create a temporary table which has the same columns - one temp table for one real table. Run the sqlldr proc to point at the temp table. After each failed run delete everything from the temp table. Once all the data loads, use sql to insert the rows from the temp table into the real table. That way, you don't run the risk of screwing up production data. Or violating constraints.
|
|
| Viewing: Dev Shed Forums > Databases > Oracle Development > data type checking!!! |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
