Re: Dynamic SQL using INSERT with a predefined query and an id.

if i understand your problem, i have an awful hack for you.

use the sequence, but subtract rownum from it (and add 1). i.e., your Query in the List table looks like

"select myseq.nextval + 1 - rownum, ..."

like i said, it's a hack, but for each "population" that first column should be the same number. another drawback is, the sequence will still iterate of course, and you will have big gaps in the id's.

otherwise what you're trying to do shouldn't be that hard if you used PL/SQL. Received on Wed Jun 27 2001 - 14:33:29 CDT