Insert operation

[smiley]

hi all,

I need a query insert data into table with two columns one is number which is unique and the other column is name. Inserting data shud be in such a way that the number should be total number of rows plus one like count(rows)+1 should be the number that i should insert into the table.
i am unable to use aggregate functions in insert command.

 

[Marco Kalter]

Perhaps you can use a sequence and insert the nextval?

By the way: how is this related to the Query Reporter product?