'Repeat a single row in all rows Oracle grouped

I need to repeat the car answer in all rows until the next survey set of answer.

The example I need is in the last column.

The need is with this way, I can create a car parameter filter to fetch all the answer rows.

I've tried some ways but no success.

Is that possible?

Thanks a lot for any help.

surv_id date_time   question_id question    answer_id   answer  car
CAR_CHECK1  30/03/2022 08:42    5169    type    4509    return to supplier  RMN9H51
CAR_CHECK1  30/03/2022 08:43    5132    date_time   4624    2022-03-30-08.43.00 RMN9H51
CAR_CHECK1  30/03/2022 08:43    5174    car group   4629    V   RMN9H51
CAR_CHECK1  30/03/2022 08:48    5134    car 4632    RMN9H51 RMN9H51
CAR_CHECK1  30/03/2022 08:48    5135    car km  4633    51389   RMN9H51
CAR_CHECK1  30/03/2022 08:48    5142    picture 4634    YES RMN9H51
CAR_CHECK1  30/03/2022 08:55    5166    signature   4627    SIGNATURE   RMN9H51
CAR_CHECK1  30/03/2022 10:42    5169    type    4509    return to supplier  AAA1525
CAR_CHECK1  30/03/2022 10:43    5132    date_time   4624    2022-03-30-08.43.00 AAA1525
CAR_CHECK1  30/03/2022 10:43    5174    car group   4629    V   AAA1525
CAR_CHECK1  30/03/2022 10:48    5134    car 4632    AAA1525 AAA1525
CAR_CHECK1  30/03/2022 10:48    5135    car km  4633    51389   AAA1525
CAR_CHECK1  30/03/2022 10:48    5142    picture 4634    YES AAA1525
CAR_CHECK1  30/03/2022 10:55    5166    signature   4627    SIGNATURE   AAA1525
CAR_CHECK1  01/04/2022 10:42    5169    type    4509    return to supplier  CCC1122
CAR_CHECK1  01/04/2022 10:42    5132    date_time   4624    2022-03-30-08.43.00 CCC1122
CAR_CHECK1  01/04/2022 10:42    5174    car group   4629    V   CCC1122
CAR_CHECK1  01/04/2022 10:42    5134    car 4632    CCC1122 CCC1122
CAR_CHECK1  01/04/2022 10:42    5135    car km  4633    51389   CCC1122
CAR_CHECK1  01/04/2022 10:42    5142    picture 4634    YES CCC1122
CAR_CHECK1  01/04/2022 10:42    5166    signature   4627    SIGNATURE   CCC1122

enter image description here



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source