-
Sequence as Default Value
I have a table that is loaded by sqlloader every day. I have to add a column to the table and in that column I want a sequence number to be placed when loading. The question is can I just make the column have a default value of theseq.nextval or do I have to put it in the control file or a insert trigger?
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|