Home » RDBMS Server » Server Administration » Decimal format in SqlLoder
Decimal format in SqlLoder [message #372080] Tue, 09 January 2001 08:38
Archana
Messages: 18
Registered: January 2001
Junior Member
Hi

I have file with implied decimal fields. I want to load the file using Sqlloader in direct mode. when I apply "(:x_amt/100)" syntax to get the decimal position, it gives me an error as
SQL*Loader-417: SQL string (on column X_AMT) not allowed in direct path.

(The same syntax works if i don't use direct mode)

Is there any other way of getting implied decimal in the direct mode method of sqlloder?

Thanks
Archana

Report message to a moderator

Previous Topic: To get primary and corresponding foreign key
Next Topic: default values not defaulting
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 18 09:31:41 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.