Hello experts;
What is the best approach to implementing this. THis is for knowledge based only.
I have the following same data below in case needed
create table test
(
Id number
,req_place varchar2
,req_date date
);
insert into test values (1, 'New York', to_date('1/1/2018', 'MM/DD/YYYY');
insert into test values (2, 'Boston', to_date('2/11/2018', 'MM/DD/YYYY');
insert into test values (3, 'Dallas', to_date('3/17/2018', 'MM/DD/YYYY');
insert into test values (4, 'Los Angeles', to_date('4/20/2018', 'MM/DD/YYYY');
I want to be able remove any given row and re-add back that same row..Hence, what is the best approach to this.
All help is appreciated.