Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE client_doc (
  ID              INT
                  GENERATED ALWAYS AS IDENTITY
                  CONSTRAINT client_doc__id__pk PRIMARY KEY,
  Value_Date      DATE
                  NOT NULL,
  Doc_Description VARCHAR2(50)
);
CREATE VIEW client_doc_view ( id, value_date, doc_id, doc_description ) AS
SELECT id,
       value_date,
       ROW_NUMBER() OVER ( PARTITION BY value_date ORDER BY id ),
       doc_description
FROM   client_doc;
INSERT INTO client_doc ( value_date, doc_description )
SELECT DATE '2020-11-01', 'Test Doc'     FROM DUAL UNION ALL
SELECT DATE '2020-11-01', 'User Info'    FROM DUAL UNION ALL
SELECT DATE '2020-11-01', 'Customer Doc' FROM DUAL UNION ALL
SELECT DATE '2020-11-02', 'Live'         FROM DUAL UNION ALL
SELECT DATE '2020-11-02', 'Region'       FROM DUAL UNION ALL
SELECT DATE '2020-11-03', 'Test'         FROM DUAL;
6 rows affected

SELECT *
FROM   client_doc_view;


ID
VALUE_DATE
DOC_ID
DOC_DESCRIPTION


1
01-NOV-20
1
Test Doc

2
01-NOV-20
2
User Info

3
01-NOV-20
3
Customer Doc

4
02-NOV-20
1
Live

5
02-NOV-20
2
Region

6
03-NOV-20
1
Test

ID	VALUE_DATE	DOC_ID	DOC_DESCRIPTION
1	01-NOV-20	1	Test Doc
2	01-NOV-20	2	User Info
3	01-NOV-20	3	Customer Doc
4	02-NOV-20	1	Live
5	02-NOV-20	2	Region
6	03-NOV-20	1	Test