Insert a row into a table with max id plus 1

[James Lee]

Hi,

Can anyone show me how to do it? Basically something like this:

insert into customer(id, column_2...) values (select max(id) + 1 from customer, value_2...)

but it's not working.

It can be done with two queries but I'm wondering if it can be done with only one query.

Thanks.

[Sona Patel]

Hi James,

Check this http://www.coderanch.com/t/81154/Oracle-OAS/Using-Select-query-inside-insert

which version of oracle are you using?

[James Lee]

Hi Sona,

I've figured it out using sequence.

Thanks a lot.