
November 1st, 2003, 12:32 PM
|
|
Registered User
|
|
Join Date: Apr 2007
Posts: 22,309
Time spent in forums: < 1 sec
Reputation Power: 24
|
|
|
Inserting into a sequence question.
Hello all. I created a sequence and know how to insert all the values into the table at once, but how do you insert just selected values into a field? I tried the insert command just identifying the specific field, as in a regular insert statement, but it does not work. What is the syntax for selected field inserts with a sequence using the NEXTVAL command? Thanks for the help! Tony.
|