I want to insert (`user_id`) value from a select statement like below. It works, but `user_id` doesn't get increased since `user_id` is not an identity column. I want to increase `user_id` count on every insert query run. Right now it's not happening. I created a db fiddle. I want this code to work on both SQL Server and Oracle versions.

<https://dbfiddle.uk/?rdbms=sqlserver_2019l&fiddle=ba954e4d37831a46aea3b3f3b499cc51>

```
CREATE TABLE b_user (
  user_id      INT,
  user_name    VARCHAR(250),
  user_email   VARCHAR(250),
  user_address VARCHAR(250),
  user_city    VARCHAR(50),
  user_state   VARCHAR(5),
  user_country VARCHAR(5),
  user_zip     VARCHAR(10)
)

insert into b_user (
  user_id,
  user_name,
  user_email,
  user_address,
  user_city,
  user_state,
  user_country,
  user_zip
) values (
  1,
  'Alice',
  'alice@example.com',
  'A house',
  'A city',
  'STATE',
  'ABC',
  'ZZ0123'
);

insert into b_user (user_id,
                    user_name,
                    user_email,
                    user_address,
                    user_city,
                    user_state,
                    user_country,
                    user_zip)
values (
   (select max(user_id)  from b_user),
   'david brown',
   'david@david.com',
   'david''s house',
   'chicago',
   'il',
   'usa',
   60007
)

```

[db fiddle screenshot](https://i.stack.imgur.com/cajtQ.png)