Home » RDBMS Server » Server Utilities » sql loader
sql loader [message #368369] Mon, 04 December 2000 09:57 Go to next message
nadeem
Messages: 11
Registered: December 2000
Junior Member
How to generate unique, sequential key values in specified columns through sql loader.

Report message to a moderator

Re: sql loader [message #368372 is a reply to message #368369] Mon, 04 December 2000 11:15 Go to previous message
Preeti
Messages: 14
Registered: November 2000
Junior Member
Try this:

columnname SEQUENCE(MAX,1)

this will automatically generate a sequence for the colname starting from 1

Report message to a moderator

Previous Topic: Startup Problem
Next Topic: Re: Direct load using functions like NVL in the control file
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 13:11:33 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.